DGM-17016: failed to retrieve status for database ; ORA-16664: unable to receive the result from a database

######### ERROR  #####
DGM-17016: failed to retrieve status for database
ORA-16664: unable to receive the result from a database
DGMGRL> show configuration
Configuration – DG_Config
Protection Mode: MaxPerformance
Databases:
swx – Primary database
swxstandby – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
Error: ORA-16664: unable to receive the result from a database
SOLUTION
——————–
Drop and Add the configuration again from the Node where you got this error
DGMGRL> remove configuration;
DGMGRL> CREATE CONFIGURATION ‘DG_Config’ AS PRIMARY DATABASE IS ‘swx’ connect identifier is ‘swx’;
Configuration “DG_Config” created with primary database “swx”
DGMGRL> ADD DATABASE ‘swxstandby’ AS CONNECT IDENTIFIER IS swxstandby;
Database “swxstandby” added
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration
Configuration – DG_Config
Protection Mode: MaxPerformance
Databases:
swx – Primary database
swxstandby – Physical standby database (disabled)
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
 
 
BEST SOLUTION :
————–
IF NOTHING WORKS RE-CREATE THE PASSWORD FILES ON BOTH RAC NODES AND STANDBY IF NECCESARY
cd /oracle/app/oracle/product/11.2.0/db_1/dbs/
orapwd file=orapwswx2 force=y ignorecase=y

Category: Database

Tags:

4 comments

  1. Hi,
    removing configuration went ok. create new one went also ok, but..
    I got this error:
    DGMGRL> ADD DATABASE ‘vav’ AS CONNECT IDENTIFIER IS ‘vav’;
    Error: ORA-16603: database is part of another Data Guard broker configuration

    1. DGMGRL> ADD DATABASE ‘vav’ AS CONNECT IDENTIFIER IS ‘vav’;
      Error: ORA-16603: database is part of another Data Guard broker configure

Leave a Reply

Article by: Shadab Mohammad