Home » Server Options » RAC & Failsafe » combining primary and standby tnsname entry and TAF
combining primary and standby tnsname entry and TAF [message #227825] Thu, 29 March 2007 09:35
olawumig
Messages: 1
Registered: May 2006
Location: Houston, TX
Junior Member
QUESTION
=========
1. We have several standby databases

2. we have several oracle homes (100's)

3. We are planning to develop a common tns name entry (TAF) that can work when role change happens (switchover / failover / switchback)with no changes.

4. The changes in client tnsnames accross the servers / client machines are very expensive and time consuming and we need to implement a best possible approach.

5. I tried the following entry and did not help me, It always tries to connect the standby database which is in mrp mode
and fails

<TAF_TNS_ALIAS> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTO = TCP)(HOST = <STANDBY_RAC_INSTANCE_1>)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST = <STANDBY_RAC_INSTANCE_2>)(PORT = 1525)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = <PRIMARY_RAC_INSTANCE_1>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <PRIMARY_RAC_INSTANCE_2>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <service_name>)
)
)

6. Has anyone ever been successful with such implementation, or does anyone have an idea on how to implement the change in the tnsname entry.

7. Thanks in advance
Previous Topic: restore oracle 9.2.0.6 (RAC) for RMAN
Next Topic: Clusterware installation root.sh problem
Goto Forum:
  


Current Time: Fri Mar 29 05:42:00 CDT 2024