TNSNAMES.ORA question for automatic failover when Switching Roles in DG
765350Apr 8 2010 — edited Apr 8 2010Hello All,
I have set up a Primary and Standby Oracle server using DataGuard and have performed a switchover several times. I would like to make this as efficient as possible and thus I have configured my TNSNAMES file as below.
This works perfect when the primary database is down and refusing connections however: When I switch roles and both servers are up (and the fist server is in standby mode and the second is primary) the client connects to the standby server sucessfully (thus does not failover) and then gets an ORA error.
Is there a way I can configure the TNS to failover on specific ORA codes as well as refused connections? What does everyone else do?
Many Thanks,
Oliver
TNSNAMES.ORA
(DESCRIPTION_LIST =
(FAILOVER=on)
(LOAD_BALANCE=off)
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=BHTDEVARC01)(PORT=1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CDBARCH))
)
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=BHTDEVARC02)(PORT=1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CDBARCH6))
)
)
Edited by: user8000750 on 08-Apr-2010 02:46