Saturday, September 17, 2022

Oracle: Dataguard: Error: ORA-16664: unable to receive the result from a member

 dgmgrl Physical Standby is showing offline and Real Time Query is showing OFF.


DGMGRL> show configuration


Configuration - orcl


  Protection Mode: MaxPerformance

  Members:

  orclprm - Primary database

    orclstb - Physical standby database 

      Error: ORA-16664: unable to receive the result from a member


Fast-Start Failover:  Disabled


Configuration Status:

ERROR   (status updated 66 seconds ago)


DGMGRL> show database orclprm


Database - orclprm


  Role:               PRIMARY

  Intended State:     TRANSPORT-ON

  Instance(s):

    orcl


Database Status:

SUCCESS


DGMGRL> show database orclstb


Database - orclstb


  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-ON


  Transport Lag:      (unknown)

  Apply Lag:          (unknown)

  Average Apply Rate: (unknown)

  Real Time Query:    OFF

  Instance(s):

    orcl


Database Status:

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

ORA-16664: unable to receive the result from a member


Primary node listener is not started and that's what caused the inability to communicate with the Physical Standby database.

oracle@Primary ~]$ lsnrctl status


LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 16-SEP-2022 16:36:15


Copyright (c) 1991, 2019, Oracle.  All rights reserved.


Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

[oracle@Primary ~]$ lsnrctl start


The Physical Standby status returns from ON after starting up the listener.


[oracle@Primary ~]$ dgmgrl /

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Sep 16 16:36:32 2022

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


Welcome to DGMGRL, type "help" for information.

Connected to "ORCLPRM"

Connected as SYSDG.

DGMGRL> show configuration


Configuration - orcl


  Protection Mode: MaxPerformance

  Members:

  orclprm - Primary database

    orclstb - Physical standby database 

      Error: ORA-16664: unable to receive the result from a member


Fast-Start Failover:  Disabled


Configuration Status:

ERROR   (status updated 71 seconds ago)


DGMGRL> show database orclstb


Database - orclstb


  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-ON

  Transport Lag:      0 seconds (computed 0 seconds ago)

  Apply Lag:          0 seconds (computed 0 seconds ago)

  Average Apply Rate: 2.00 KByte/s

  Real Time Query:    ON

  Instance(s):

    orcl


Database Status:

SUCCESS


 


 

No comments:

Post a Comment