######### 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
4 comments
very good post Thanks..
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
DGMGRL> ADD DATABASE ‘vav’ AS CONNECT IDENTIFIER IS ‘vav’;
Error: ORA-16603: database is part of another Data Guard broker configure
Thank you very much…after removing DG configuration and re-creating my problem is solved.