3 Replies Latest reply: May 15, 2013 3:36 AM by Mahir M. Quluzade RSS

    Data Guard Primary having shared server connections

    user11983096
      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.