Question for Dataguard users
From: Storey, Robert (DCSO) <"Storey,>
Date: Wed, 27 Jul 2011 12:42:45 -0500
Message-ID: <6727A8A8C9EAF343B21C48BF04DB6453723A18_at_dcsosvms01.dcso.org>
Okay, have a question for the dataguard users. Probably more for the non-RAC folks than anything.
Date: Wed, 27 Jul 2011 12:42:45 -0500
Message-ID: <6727A8A8C9EAF343B21C48BF04DB6453723A18_at_dcsosvms01.dcso.org>
Okay, have a question for the dataguard users. Probably more for the non-RAC folks than anything.
My setup is a primary and a single physical standby.
In the event of a switchover, all user connections are broken and the switch occurs. Then users have to reconnect.
But, I'm looking for the best way to structure the TNSNAMES file. I'm probably over thinking this, but, there has to be a way to create both entries for both servers in the file, but only have them use the production one. Something tickles my brain from way back that it will run the TNS list in order looking for a connection.
Just curious how others have set up their files.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 27 2011 - 12:42:45 CDT