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

【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宝典今日头条号地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ........................................................................................................................ ● 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 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ........................................................................................................................ ● 小麦苗的微店 ： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麦苗出版的数据库类丛书 ： 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 ， 学习最实用的数据库技术。 ........................................................................................................................

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26736162/viewspace-2200090/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26736162/viewspace-2200090/