Home > Oracle > After a Dataguard Broker switchover, the “show configuration” command returns errors ORA-16501, ORA-16625, DGM-17017

After a Dataguard Broker switchover, the “show configuration” command returns errors ORA-16501, ORA-16625, DGM-17017

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

DGMGRL> switchover to FBOXI4SB
Site “fboxi4sb” was not found
DGMGRL> switchover to ‘FBOXI4SB’
Performing switchover NOW, please wait…exit
Operation requires a connection to instance “FBOXI4SB” on database “FBOXI4SB”
Connecting to instance “FBOXI4SB”…
Connected.
New primary database “FBOXI4SB” is opening…
Operation requires startup of instance “FBOXI4P” on database “FBOXI4P”
Starting instance “FBOXI4P”…
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is “FBOXI4SB”

 

Afterwards the Dataguard command “show configuration” returns errors ORA-16501, ORA-16625

DGMGRL> show configuration


Fast-Start Failover: DISABLED
Configuration Status:
ORA-16501: the Data Guard broker operation failed
ORA-16625: cannot reach database “FBOXI4P”
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 FBOXI4P -o mount
Cause

The tnsnames.ora was not present in $GRID_HOME directory, namely in $GRID_HOME/network/admin

Solution

Make sure the tnsnames.ora file is present in $GRID_HOME/network/admin directory;  For example copy the tnsnames.ora file from the $ORACLE_HOME/network/admin to $GRID_HOME/network/admin

 

 

 

 

 

 

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: