4 Replies Latest reply on Jan 12, 2018 10:39 AM by SUPRIYO DEY

    DG Configuration on 2 NODE RAC

    Jhil

      Dear all ,

       

      I am  trying to configure Dataguard setup on RAC System.

      DB Version : 11.2.0.2 on  LINUX

       

       

       

      I have some questions, please clarify my doubts

       

       

       

      1)  Do i need to configure  tnsnames.ora  on  both nodes (rac1 and  rac2)  of  Primary DB Server ?

      2)  Do i need additional  entries regarding standby database in tnsnames.ora  and listener. ora files ?

       

      >> Primary DB details

       

      $ srvctl config database -d samdb
      Database unique name: samdb
      Database name: samdb
      Oracle home: /u01/app/oracle/product/11.2.0/db_home
      Oracle user: oracle
      Spfile: +DATA/samdb/spfilesamdb.ora
      Domain: com
      Start options: open
      Stop options: immediate
      Database role: PRIMARY
      Management policy: AUTOMATIC
      Server pools: samdb
      Database instances: samdb1,samdb2
      Disk Groups: DATA,RECO
      Mount point paths: 
      Services: 
      Type: RAC
      Database is administrator managed
      

       

      >> Primary  DB  Server  details of  both nodes

       

      $ cat /etc/hosts
      # Do not remove the following line, or various programs
      # that require network functionality will fail.
      127.0.0.1        localhost.localdomain localhost
      #::1             localhost6.localdomain6 localhost6
      
      # Public
      192.168.56.10    rac1.oracle.com      rac1
      192.168.56.20    rac2.oracle.com      rac2
      
      # Private
      192.168.10.1      rac1-priv
      192.168.10.2      rac2-priv
      
      # Virtual
      192.168.56.70    rac1-vip
      192.168.56.71    rac2-vip
      
      # Scan
      192.168.56.90    rac-scan
      192.168.56.91    rac-scan
      192.168.56.92    rac-scan
      

       

      >> TNSNAMES.ORA FROM  $ORACLE_HOME

       

      $ cd $ORACLE_HOME/network/admin
      [oracle@RAC1 admin]$ cat tnsnames.ora
      # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_home/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.
      
      SAMDB =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = samdb.com)
          )
        )
      
      SAMDB1 =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = samdb.com)
            (INSTANCE_NAME = samdb1)
          )
        )
      
      SAMDB2 =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = samdb.com)
            (INSTANCE_NAME = samdb2)
          )
        )
      

       

      >> LISTENER.ORA  FROM  $GRID_HOME

       

      $ pwd
      /u01/product/11.2.0/grid/network/admin
      [grid@RAC1 admin]$ cat  listener.ora
      LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
      LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
      
      

       

       

      FYI : Do i need to update listener.ora too ,
               if yes , please provide little information.