【dgmgrl】使用dgmgrl做switchover切換報錯ORA-16501, ORA-16625, DGM-17017,DGM-17016

---

---

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

---

---

About Me

........................................................................................................................ ● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除 ● 本文在itpub（ http://blog.itpub.net/26736162 ）、部落格園（ http://www.cnblogs.com/lhrbest ）和個人weixin公眾號（ xiaomaimiaolhr ）上有同步更新 ● 本文itpub地址： http://blog.itpub.net/26736162 ● 本文部落格園地址： http://www.cnblogs.com/lhrbest ● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/ ● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA寶典今日頭條號地址： ........................................................................................................................ ● QQ群號： 230161599 （滿） 、618766405 ● weixin 群：可加我 weixin ，我拉大家進群，非誠勿擾 ● 聯絡我請加QQ好友 （ 646634621 ） ，註明新增緣由 ● 於 2018-08-01 06:00 ~ 2018-08-31 24:00 在魔都完成 ● 最新修改時間：2018-08-01 06:00 ~ 2018-08-31 24:00 ● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解 ● 版權所有，歡迎分享本文，轉載請保留出處 ........................................................................................................................ ● 小麥苗的微店 ： ● 小麥苗出版的資料庫類叢書 ： http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麥苗OCP、OCM、高可用網路班 ： http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麥苗騰訊課堂主頁 ： https://lhr.ke.qq.com/ ........................................................................................................................ 使用 weixin 客戶端 掃描下面的二維碼來關注小麥苗的 weixin 公眾號（ xiaomaimiaolhr ）及QQ群（DBA寶典）、新增小麥苗 weixin ， 學習最實用的資料庫技術。 ........................................................................................................................