This discussion is archived
7 Replies Latest reply: Jan 23, 2013 1:09 PM by Pinela RSS

Error During DataGuard Broker configuration

sandy121 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Great. Congrats.

    br,
    jpinela.

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

Legend

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