RE: dataguard connection question
Date: Wed, 10 Jun 2009 09:15:03 -0400
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.
Senior Oracle DBA
[mailto:oracle-l-bounce_at_freelists.org] 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
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.
http://www.freelists.org/webpage/oracle-l Received on Wed Jun 10 2009 - 08:15:03 CDT