Transparent Application failover on 9i rac

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.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: