Re: Transparent Application failover on 9i rac
- From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 2 Jul 2009 11:53:51 -0400
Hi Gurus,
It is very surprising that noone had replied me on this issue. I'm
stuck on this issue. Please help.
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.
On Tue, Jun 30, 2009 at 3:09 PM, sundar
mahadevan<sundarmahadevan82@xxxxxxxxx> wrote:
> 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:
