| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
