This discussion is archived
3 Replies Latest reply: May 15, 2013 1:36 AM by MahirM.Quluzade RSS

Data Guard Primary having shared server connections

user11983096 Newbie
Currently Being Moderated
Hi fellows,

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:

HWPR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hwpr-vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hwpr-vip2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points