ODG broker error: ORA-1005: null password given; logon denied

I have an Oracle DataGuard envrionment that it has been upgraded from 12.1.0.2 to 18C recently. After the upgrade, the ODG broker gave the following error: ORA-1005: null password given; logon denied

DGMGRL> show configuration;          

Configuration - DG_APROD

  Protection Mode: MaxPerformance
  Members:
  DB1 - Primary database
    Error: ORA-1005: null password given; logon denied

    DB2- Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:
ERROR   (status updated 0 seconds ago)

It was because the oracle password was missing after the upgrade from the new $ORACLE_HOME/dbs. After I copied it over, the broker detected it automatically and showed:

GMGRL> show configuration

Configuration - DG_APROD

  Protection Mode: MaxPerformance
  Members:
  DB1 - Primary database
    DB2 - Physical standby database 
      Error: ORA-16599: Oracle Data Guard broker detected a stale configuration

Fast-Start Failover: DISABLED

Configuration Status:
ERROR   (status updated 124 seconds ago)

ORA-16599 usually is just a transient error. It will go away after a few minutes. If not, you can try to disable/enable the configuration or re-create the configuration.

Advertisement

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 )

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