RE: Question for Dataguard users

DB01 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-lax)(PORT = 1521))
(CONNECT_DATA =

      (SID = db01)
    )
  )

DB01-DEN =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-den)(PORT = 1521))
(CONNECT_DATA =

      (SID = db01)
    )
  )

Standby tnsnames.ora:

DB01-LAX =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-lax)(PORT = 1521))
(CONNECT_DATA =

      (SID = db01)
    )
  )

DB01 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-den)(PORT = 1521))
(CONNECT_DATA =

      (SID = db01)
    )
  )

Michael Dinh

NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this email (and attachments) is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender of the error and delete the e-mail you received. Thank you. From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Storey, Robert (DCSO) Sent: Wednesday, July 27, 2011 10:43 AM
To: oracle-l-freelists
Subject: Question for Dataguard users

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-l