2 Replies Latest reply: May 28, 2014 10:36 AM by SM.A RSS

    RAC to RAC dataguard broker

    SM.A

      Hello Everyone,

      Environment :

      Db: 11gr2 64bit, Version: 11.2.0.1.0.

      OS: OEL 5.5

      Prod: testdb  (2 Node RAC), db unique name: testdb , Instance:testdb1, testdb2

      DR :testdr (2 Node RAC), db unique name: testdr, Instance: testdr1,testdr2

      ========================================================

      I am trying to configure dataguard broker between my Primary RAC and Secondary RAC database. But I am having connectivity issues for my secondary database. Here is the error from dgmgrl log

      Can't get db connect descriptor to database testdr (error=16501)

      Connect Identifier testdr

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = testdg-scan.htw.com)(PORT = 1521))

      (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = testdr.htw.com)

      )

      )

      ========================================================

      My tnsnames.ora is below :

       

      # tnsnames.ora Network Configuration File: /d01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

       

      TESTDB =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = testrc-scan.htw.com)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = testdb.htw.com)

          )

        )

       

      TESTDB1 =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = testrc1-vip.htw.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = testdb.htw.com)

          )

        )

       

      TESTDB2 =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = testrc2-vip.htw.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = testdb.htw.com)

          )

        )

       

      TESTDR =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = testdg-scan.htw.com)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

           (SERVICE_NAME = testdr.htw.com)

          )

        )

       

      TESTDR1 =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = testdg1-vip.htw.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = testdr.htw.com)

          )

        )

       

      TESTDR2 =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = testdg2-vip.htw.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = testdr.htw.com)

          )

        )

      ======================================================================

      My Listener.ora file on Node1 of primary.

       

      # listener.ora Network Configuration File: /d01/app/grid/product/11.2.0/grid/network/admin/listener.ora

       

      # Generated by Oracle configuration tools.

       

       

       

      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (GLOBAL_DBNAME = testdb.htw.com)

            (ORACLE_HOME = /d01/app/grid/product/11.2.0/grid)

            (SID_NAME = testdb1)

          )

        (SID_DESC =

            (GLOBAL_DBNAME = testdb_DGMGRL.htw.com)

            (ORACLE_HOME = /d01/app/grid/product/11.2.0/grid)

            (SID_NAME = testdb1)

          )

        )

       

      LISTENER =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))

        )

      ADR_BASE_LISTENER = /d01/app/oracle

      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

      LISTENER_SCAN1 =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))

        )

       

      ADR_BASE_LISTENER_SCAN1 = /d01/app/oracle

      =================================================================

      I can connect secondary database using all of the connect identifiers (testdr, testdr1, testdr2 ) from my primary.

      sqlplus sys/password@testdr as sysdba

      and vice versa.

       

      Do I need to make some changes in my listener.ora and tnsnames.ora ?

      Any help in this regard will be highly appreciated.

      Regards

        • 1. Re: RAC to RAC dataguard broker
          mseberg

          Hello;

           

          Did you add _DGMGRL to the listener?

           

          This error generally has an accompanying message, do you have this?

           

          Best Regards

           

          mseberg

          • 2. Re: RAC to RAC dataguard broker
            SM.A

            Hello,

             

            did you mean adding DGMGRL after db_unique_name for static registration like this ? if Yes. Please check the following.

             

            (SID_DESC =

                  (GLOBAL_DBNAME = testdb_DGMGRL.htw.com)

                  (ORACLE_HOME = /d01/app/grid/product/11.2.0/grid)

                  (SID_NAME = testdb1)

                )

            ===========================================

            Here is the log from the primary

             

            2014-05-28 17:30:54.129 00001000   291484106 DMON: Entered rfm_get_chief_lock() for MON_VERIFY, reason 0

            2014-05-28 17:30:54.132 00001000   291484106 DMON: chief lock convert for client healthcheck

            2014-05-28 17:30:54.132                      INSV: Received message for inter-instance publication

            2014-05-28 17:30:54.133                            req ID 1.1.291484106, opcode MON_VERIFY, phase BEGIN, flags 5

            2014-05-28 17:30:55.000                      INSV: Reply received for message with

            2014-05-28 17:30:55.001                            req ID 1.1.291484106, opcode MON_VERIFY, phase BEGIN

            2014-05-28 17:31:12.082                      NSV1: Site testdr returned ORA-16664.

            2014-05-28 17:31:12.083 00000000   291484106 DMON: Database testdr returned ORA-16664

            2014-05-28 17:31:12.083 00000000   291484106       for opcode = MON_VERIFY, phase = BEGIN, req_id = 1.1.291484106

            2014-05-28 17:31:12.083                      INSV: Received message for inter-instance publication

            2014-05-28 17:31:12.083                            req ID 1.1.291484106, opcode MON_VERIFY, phase RESYNCH, flags 10005

             

            ==========================================

            Here is the log from secondary

            2014-05-28 17:30:54.089                            req ID 1.1.291484106, opcode MON_VERIFY, phase BEGIN, flags 5

            2014-05-28 17:30:54.367                      RSM Warning: Property 'ArchiveLagTarget' has inconsistent values:METADATA='0', SPFILE='', DATABASE='0'

            2014-05-28 17:30:54.368                      RSM0: HEALTH CHECK WARNING: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting

            2014-05-28 17:30:54.415                      RSM Warning: Property 'LogArchiveMinSucceedDest' has inconsistent values:METADATA='1', SPFILE='', DATABASE='1'

            2014-05-28 17:30:54.415                      RSM0: HEALTH CHECK WARNING: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting

            2014-05-28 17:30:54.515                      SPFILE is missing value for property 'LogArchiveTrace' with sid='testdr1'

            2014-05-28 17:30:54.516                      RSM Warning: Property 'LogArchiveTrace' has inconsistent values:METADATA='0', SPFILE='(missing)', DATABASE='0'

            2014-05-28 17:30:54.516                      RSM0: HEALTH CHECK WARNING: ORA-16714: the value of property LogArchiveTrace is inconsistent with the database setting

            2014-05-28 17:30:54.541                      SPFILE is missing value for property 'LogArchiveFormat' with sid='testdr1'

            2014-05-28 17:30:54.541                      RSM Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='%t_%s_%r.ARC', SPFILE='(missing)', DATABASE='%t_%s_%r.ARC'

            2014-05-28 17:30:54.542                      RSM0: HEALTH CHECK WARNING: ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting

            2014-05-28 17:30:54.572 00000000   291484106 Operation MON_VERIFY continuing with warning, status = ORA-16792

            2014-05-28 17:30:54.572                      INSV: Reply received for message with

            2014-05-28 17:30:54.572                            req ID 1.1.291484106, opcode MON_VERIFY, phase BEGIN

            2014-05-28 17:30:54.573                      DMON: HEALTH CHECK ERROR: ORA-16766: Redo Apply is stopped

            2014-05-28 17:30:54.573 00000000   291484106 Operation MON_VERIFY canceled during phase 1, error = ORA-16810

            2014-05-28 17:30:54.575 00000000   291484106 DMON: Entered rfm_release_chief_lock() for MON_VERIFY

            not validNAME = testdb.htw.com)T = testrc-scan.htw.com)(PORT = 1521))

            2014-05-28 17:30:54.575                      NSV0: Can't get db instance specific connect descriptor to database testdb (error=16501)

            2014-05-28 17:30:54.575                      NSV0: Failed to connect to 0x01001001

            2014-05-28 17:30:54.575                      NSV0: Failed to send message to site testdb. Error code is ORA-16501.

            2014-05-28 17:30:54.576                      DMON: Database testdb returned ORA-16501

            2014-05-28 17:30:54.576                            for opcode = MON_VERIFY, phase = BEGIN, req_id = 1.1.291484106

            2014-05-28 17:31:12.032                      drcx: could not find task req_id=1.1.291484106 for PROBE.

             

             

             

            Regards