This content has been marked as final. Show 3 replies
user11983096 wrote:Yes you must change in tnsnames.ora file for primary and standby side, together.
I am configuring dataguard from RAC primary to RAC standby. The RAC primary is using shared server mode. The primary server tnsnames.ora looks like this:
(ADDRESS = (PROTOCOL = TCP)(HOST = hwpr-vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hwpr-vip2)(PORT = 1521))
(LOAD_BALANCE = yes)
(SERVER = SHARED) <<<<< this is my concern
(SERVICE_NAME = hwpr)
while documentation says that for dataguard dedicated server is required. so what changes do i need to do. Is it only required to changed the tnsnames.ora from shared to dedicated or any other init parameter is also required to be changed.