Transparent Application failover on 9i rac
- From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 30 Jun 2009 15:09:49 -0400
Hi Gurus,
I'm trying to setup transparent application failover on my 2 node test 9i RAC.
The tnsnames.ora on node1 and node2 are pretty simple excepting for
the ipaddress.
ORCL.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
To test TAF, i'm connecting from my laptop sqlplus client which has
the following tnsnames.ora
LISTENERS_ORCL.EZHOME.COM =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521))
)
ORCL.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = YES)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT =
1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
ORCL1.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(INSTANCE_NAME = ORCL1)
(FAILOVER_MODE =
(BACKUP = ORCL2.EZHOME.COM)
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
ORCL2.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(INSTANCE_NAME = ORCL2)
(FAILOVER_MODE =
(BACKUP = ORCL1.EZHOME.COM)
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
select instance_name, host_name,
NULL AS failover_type,
NULL AS failover_method,
NULL AS failed_over
FROM v$instance
UNION
SELECT NULL, NULL, failover_type, failover_method, failed_over
FROM v$session
WHERE username = 'HR';
RESULT:
INSTANCE_NAME HOST_NAME
FAILOVER_TYPE FAILOVER_M FAI
----------------
----------------------------------------------------------------
------------- ---------- ---
orcl1 sunny1pub.ezhome.com
NONE NONE NO
2 rows selected.
1) As you can see, the failover_type, failover_method, failed_over are
None and no respectively. I have been searching the internet for the
past couple days but i dont find any sample files. Appreciate if
someone could send me a sample tnsnames.ora sample file.
2) Also do i need to have the LISTENERS_ORCL.EZHOME.COM ? What is the
use/purpose of it?
Please help. Thanks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
