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))))
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.