Data Guard 奇葩的 ORA-16191: Primary log shipping client not logged on standby 问题
来源:互联网 发布:时时彩断组计算软件 编辑:程序博客网 时间:2024/05/12 16:58
搞了一个Data Gurad,switchover之后,检查配置情况:
SQL> select dest_name,status,error from v$archive_dest where rownum<3;
DEST_NAME STATUS ERROR
-------------------- --------- -------------------------------
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-16191: Primary log shipping client not logged on standby
报了ORA-16191 的错误。
alert log的信息如下:
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect tostandby 'dave'. Error is 16191.
Thu Jul 18 21:41:20 2013
Error 1017 received logging on to thestandby
------------------------------------------------------------
Check that the primaryand standby are using a password file
andremote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS passwordis same in the password files.
returning error ORA-16191
错误讲的很清楚,口令文件的问题。
检查了一下,remote_login_passwordfile参数没有问题,然后在所有节点都使用orapwd命令重建了口令文件,依旧报错。
[oracle@davedbs]$ orapwd file=$ORACLE_HOME/dbs/orapwdave1 password=oracle
[oracle@davedbs]$ orapwd file=$ORACLE_HOME/dbs/orapwdave2 password=oracle
使用alter user 重建密码也不行。
最后在主库创建了一份口令文件,然后把口令文件传送到其他节点,并rename,过了几分钟,再次查询,就ok了。
好奇葩吧,备注一下,以防下次在遇到。
--------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
QQ: 251097186
Skype: tianlesoftware
Email: tianlesoftware@gmail.com
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
- Data Guard 奇葩的 ORA-16191: Primary log shipping client not logged on standby 问题
- ORA-16191: Primary log shipping client not logged on standby
- ORA-16191: Primary log shipping client not logged on standby
- ORA-16191: Primary log shipping client not logged on standby---待测
- [Dataguard]ORA-16191: Primary log shipping client not logged on standby问题解决
- Monitor Data Guard Log Shipping
- ORA-01012: not logged on(问题)
- ORA-01012:not logged on的解决办法
- ORA-01012:not logged on的解决办法
- ORA-01012:not logged on的解决办法
- ORA-01012: not logged on
- ORA-01012:not logged on
- ORA-01012 not logged on
- ORA-01012: not logged on
- ORA-01012: not logged on
- Oracle Data Guard ORA-16086: standby database does not contain available standby 处理方法
- Oracle Data Guard ORA-16086: standby database does not contain available standby 处理方法
- Data Guard 配置 Standby Redo Log
- android中用SAX方式解析XML文档
- zeromq 发布订阅 无数据丢失性能测试
- 软工III经验总结
- Ubuntu12.04 安装 ant
- poj 1077-Eight;hdu 1043-Eight
- Data Guard 奇葩的 ORA-16191: Primary log shipping client not logged on standby 问题
- 111111111111111111111111
- 01-八步擒单士
- 学习MyBatis从零开始_01(基础环境搭建以及基本使用)
- 02-海底捞月
- 03-单车对士象全
- [unity基础教程]UI方案及制作细节(NGUI/EZGUI/原生UI系统)
- 04-顺手炮弃马十三招
- 公钥加密的简单理解和Java的keytool的用途