7 Replies Latest reply: Jan 23, 2013 3:09 PM by Pinela RSS

    Error During DataGuard Broker configuration

    sandy121
      DB version - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
      Primary DB Name - orcl
      Physical Standby DB - standby1

      Both the standby and primary db's are in sync . We are implementing datagaurd broker . Below are the steps taken :-

      _______________________________
      DGMGRL> connect sys/oracle
      Connected.
      DGMGRL> create configuration 'dgorcl'
      as
      primary database is 'orcl'
      connect identifier is orcl ;
      Configuration "dgorcl" created with primary database "orcl"
      DGMGRL> show configuration;

      Configuration - dgorcl

      Protection Mode: MaxPerformance
      Databases:
      orcl - Primary database

      Fast-Start Failover: DISABLED

      Configuration Status:
      DISABLED

      DGMGRL> add database 'standby1' as
      connect identifier is standby1
      maintained as physical ;
      Database "standby1" added
      DGMGRL> enable configuration
      Enabled.

      -------------------------------------------

      Now while trying to check the status as below, it is showing error.
      DGMGRL> show configuration

      Configuration - dgorcl

      Protection Mode: MaxPerformance
      Databases:
      orcl - Primary database
      standby1 - Physical standby database
      Error: ORA-16664: unable to receive the result from a database

      Fast-Start Failover: DISABLED

      Configuration Status:
      ERROR

      <<<>>>>>>>>>>>>>>>>>>>>>>>>>

      DGMGRL> show database standby1

      Database - standby1

      Role: PHYSICAL STANDBY
      Intended State: APPLY-ON
      Transport Lag: (unknown)
      Apply Lag: (unknown)
      Real Time Query: OFF
      Instance(s):
      standby1

      Database Status:
      DGM-17016: failed to retrieve status for database "standby1"
      ORA-16664: unable to receive the result from a database
      <<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      I have checked tnsnames.ora and listener.ora in both primay and standby servers, tried to enable and disable the configuration, nothing worked for me !!

      Any assistance will be highly appreciated.
        • 1. Re: Error During DataGuard Broker configuration
          sb92075
          16664, 0000, "unable to receive the result from a database"
          // *Cause:  During execution of a command, a database in the Data Guard
          //          broker configuration failed to return a result.
          // *Action: Check Data Guard broker logs for the details of the failure.
          //          Ensure network communication is working properly amongst the 
          //          members of the configuration. Fix any possible network problems
          //          and reissue the command.
          what clues exist within alert_SID.log files on both Primary & Standby?
          • 2. Re: Error During DataGuard Broker configuration
            P.Forstmann
            Check also Data Guard broker trace file named drc<$ORACLE_SID>.log that you can find in same directory as alert log on primary and stanbdy nodes.
            • 3. Re: Error During DataGuard Broker configuration
              sandy121
              Nothing significant is noticed on on primary alert log. Standby alert log shows the below messages :-
              _______________________________________________________________
              2013-01-21 23:16:24.646 00000000 1816493532 DMON: Database standby1 returned ORA-16664
              2013-01-21 23:16:24.647 00000000 1816493532 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.1816493532
              -------------------------------------------------------------------------------------------------------------------------------------------------------------
              I reexamined network connectivity files ie listener.ora and tnsnames.ora

              Here are the details :-

              Listener.ora in primary

              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))
              )
              )

              ADR_BASE_LISTENER = /u01/oracle/app/oracle



              SID_LIST_LISTENER
              (SID_LIST =
              (SID_DESC =
              (GLOBAL_DBNAME = orcl_DGMGRL )
              (ORACLE_HOME = /u01/oracle/app/oracle/product/11.2.0)
              (SID_NAME = orcl)

              Tnsnames.entry in Primary Server

              standby1
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.21)(PORT = 1521))
              )
              (CONNECT_DATA =
              (SERVICE_NAME = standby1)
              )
              )

              ORCL =
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))
              )
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = orcl)
              )
              )
              ___________________________________
              Listener.ora in standby Server

              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.21)(PORT = 1521))
              )
              )




              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (GLOBAL_DBNAME = orcl_standby)
              (SID_NAME = orcl_standby)
              (ORACLE_HOME = /u01/oracle/app/oracle/product/11.2.0/dbhome_1)
              )
              )





              ADR_BASE_LISTENER = /u01/oracle/app/oracle




              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (GLOBAL_DBNAME = standby1_DGMGRL)
              (ORACLE_HOME = /u01/oracle/app/oracle/product/11.2.0/dbhome_1)
              (SID_NAME = standby1)
              )
              )

              Tnsnames.ora in Standby server :-

              GP =
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))
              )
              (CONNECT_DATA =
              (SERVICE_NAME = gp)
              )
              )



              SANDY =
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))

              )
              (CONNECT_DATA =
              (SERVICE_NAME = orcl)
              )
              )

              ORCL =
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))
              )
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = orcl)
              )
              )





              STANDBY1 =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.128)(PORT = 1521))
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = standby1)
              )
              )


              Can you please suggest any further trouble shooting steps ? Thanks in advance for great support as always here in this forum.
              • 4. Re: Error During DataGuard Broker configuration
                vlethakula
                on primary
                can you type
                select message from v$dataguard_status

                Edited by: vlethakula on Jan 21, 2013 12:10 PM
                • 5. Re: Error During DataGuard Broker configuration
                  Pinela
                  Hi,

                  well,
                  that usually means either connectivity or permissions problem.
                  Do you have the orapw file configured correctly on both?
                  Can you sqlplus as sys between both the envs using the listener?

                  and check this.
                  Data Gurad Broker reported ORA-16664 [ID 1390892.1]

                  br,
                  jpinela.

                  Edited by: Pinela on Jan 21, 2013 7:14 PM
                  • 6. Re: Error During DataGuard Broker configuration
                    sandy121
                    The problem was with network connectivity, I recreated the network related files i.e listener.ora,tnsnames.ora in both primary and standby and it got fixed.
                    Thanks everyone !!
                    • 7. Re: Error During DataGuard Broker configuration
                      Pinela
                      Great. Congrats.

                      br,
                      jpinela.

                      p.s. - if you found any comments helpful consider marking them as such. thank you.