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

 

Cause:

The network between primary and standby must be broken

ERROR:

ORA-16664: unable to receive the result from a database
DGM-17017: unable to determine configuration status

SOLUTION:

  • Check lại tnsnames.ora (đường dẫn, sid, _DGMGRL)
  • Nếu ok hết rồi thì restart configuration
DGMGRL> disable configuration;
DGMGRL> enable configuration;
  • Restart DG Broker
SQL> alter system set dg_broker_start=false;

System altered.

SQL> alter system set dg_broker_start=true;

System altered.

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log