Monday, October 17, 2016

DGM-17016: failed to retrieve status for database "db1tesd"

Problem:

Dataguard is show multiple error:
ORA-16810 ORA-16737 ORA-16662 DGM-17016
Error: ORA-16810: multiple errors or warnings detected for the database
Error: ORA-16662: network timeout when contacting a database
DGM-17016: failed to retrieve status for database "db1tesd"
DGMGRL> connect sys
Password:
Connected as SYSDG.
DGMGRL> show configuration
Configuration - db1tes_dg
  Protection Mode: MaxPerformance
  Members:
  db1tesp - Primary database
    Error: ORA-16810: multiple errors or warnings detected for the database
    db1tesd - Physical standby database
      Error: ORA-16662: network timeout when contacting a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR   (status updated 428 seconds ago)
DGMGRL>
DGMGRL> show database db1tesp
Database - db1tesp
  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    db1tesp1
      Error: ORA-16737: the redo transport service for standby database "db1tesd" has an error
    db1tesp2
      Error: ORA-16737: the redo transport service for standby database "db1tesd" has an error
Database Status:
ERROR
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesd
Database - db1tesd
  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    db1tesd1
Database Status:
DGM-17016: failed to retrieve status for database "db1tesd"
ORA-16662: network timeout when contacting a database
DGMGRL>




Cause:

Reason in my case is that the DR host is shutdown and primary can not connect to it.


Fix:

Start the DR host and things start looking normal again.






No comments: