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.
only changes in tnsnames.ora. what about dispatchers parameter in init.ora ?
Not need change DISPATCHERS parameter. Because, you need only dedicated, connections. It is controlling with Network Service Name in tnsnames.ora file.