Transparent Application failover on 9i rac

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Tue, 30 Jun 2009 15:09:49 -0400
Message-ID: <7d81ec570906301209u7c52be03r23974b606c88ef53_at_mail.gmail.com>

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

Received on Tue Jun 30 2009 - 14:09:49 CDT