使用dgmgrl做switchover切换报错ORA-16501, ORA-16625等

Database Status:

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

ORA-16501: the Data Guard broker operation failed

ORA-16625: cannot reach database "oradgphy"

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

用grid用户把oracle用户下的tnsnames.ora文件拷贝到grid用户下就可以了，

cp /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora /u01/app/grid/11.2.0/network/admin/tnsnames.ora

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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

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