Data Guard奇葩的ORA-16191: Primary log shipping client not logged on standby问题
Data Guard奇葩的ORA-16191: Primary log shipping client not logged on standby问题
搞了一个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了。