My Oracle Support Banner

After a Dataguard Broker switchover, the "show configuration" command returns errors ORA-16501, ORA-16625, DGM-17017 and "Fast-Start Failover: DISABLED" (Doc ID 1484542.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

A dataguard broker is being used to manage a standby database environment.  A switchover operation is performed, for example: 

DGMGRL> switchover to chicago;
Performing switchover NOW, please wait...
New primary database "chicago" is opening...
Operation requires shutdown of instance "newyork" on database "newyork"
Shutting down instance "newyork"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "newyork" on database "newyork"
Starting instance "newyork"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "chicago"

 

Afterwards the Dataguard command "show configuration" returns errors ORA-16501, ORA-16625, DGM-17017 and "Fast-Start Failover: DISABLED", for example: 

DGMGRL> show configuration

...
Fast-Start Failover: DISABLED

Configuration Status:
ORA-16501: the Data Guard broker operation failed
ORA-16625: cannot reach database "newyork"
DGM-17017: unable to determine configuration status
...
Fast-Start Failover: DISABLED

Configuration Status:
ERROR

  

In SQLPlus we can see that the standby database is running.  Stopping the standby database via sqlplus with "shutdown immediate" and then restarting the standby with srvctl command works around the issue.

SQL> shutdown immediate

 

$ srvctl start database -d newyork

  

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.