Data Guard Client Failover
edited Nov 21, 2011 1:39AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 25 commentsAnswered
So, I now have my first 11g DataGuard setup and and I did a switchover. Very nice.
I am now looking at failover capability for the client, and am not finding what I'd expect to find in the documents. I have managed to configured tnsames.ora on the client and by adding service_names parameter on the database I can now connect to the primary whichever server it is on. Here is what I'm doing:
Primary is D20AC, Standby is D21AC
To both I added
service_names='D20AC,D21AC'
then for tnsnames.ora I have:
<!-- /* Font Definitions */
I am now looking at failover capability for the client, and am not finding what I'd expect to find in the documents. I have managed to configured tnsames.ora on the client and by adding service_names parameter on the database I can now connect to the primary whichever server it is on. Here is what I'm doing:
Primary is D20AC, Standby is D21AC
To both I added
service_names='D20AC,D21AC'
then for tnsnames.ora I have:
<!-- /* Font Definitions */
0