“DGM-17016: failed to retrieve status for database” in Data Guard Broker

The following error occurred in DG broker command on primary database side:

DGMGRL> show database verbose 'STDBYDB'

Database - STDBYDB

 Role: PHYSICAL STANDBY
...
..
.
Database Status:
DGM-17016: failed to retrieve status for database "STDBYDB"
ORA-16664: unable to receive the result from a database

Standby Data Guard log:

...
..
.
02/16/2018 09:09:23
Failed to connect to remote database PRIMDB. Error is ORA-12523
Failed to send message to site PRIMDB. Error code is ORA-12523.
..
.
Fatal NI connect error 12521, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racnode2)
(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PRIMDB_DGB)(INSTANCE_NAME=
PRIMDB1)(CID=(PROGRAM=oracle)(HOST=stybynode1)(USER=oracle))))

RESOLUTION

So the issue is standby database cannot talk to primary database.  check and find TNS alias  for ‘PRIMDB’ is not right. After correcting the TNS alias ‘PRIMDB’, then everything is working fine.

2 thoughts on ““DGM-17016: failed to retrieve status for database” in Data Guard Broker”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.