RE: dataguard connection question

From: Goulet, Richard <>
Date: Wed, 10 Jun 2009 09:15:03 -0400
Message-ID: <>


        The idea is to make the standby database, when active, look and feel as much like the primary as possible. Therefore service names should be identical. For that matter, think of a service name as similar to a SID. You can't have two instances of Oracle on the same machine with the same SID, but you can if they are on separate servers. Same with service name. The one thing between the two databases that HAS to be different is the DB_UNIQUE_NAME.

Dick Goulet
Senior Oracle DBA
PAREXEL International

-----Original Message-----

[] On Behalf Of Joan Hsieh Sent: Tuesday, June 09, 2009 6:24 PM
To: Joan Hsieh
Cc: Mathias Zarick; oracle_l
Subject: Re: dataguard connection question

Hi Mathias,

  How should the tnsnames.ora looks like?   and what is the value on both primary and standby if you show parameter in sqlplus service_names = ?

   I am so confusing on this now.

  Thanks again,


-- Received on Wed Jun 10 2009 - 08:15:03 CDT

Original text of this message