环境是MAA架构,主库是RAC,备库是RAC,做主备切换,主备切换成功后在在备库的alert日志中出现发现新主库二节点的的archivelog能传输至备库,新主库的一节点的archivelog不能传输备库,同时在新的主库一节点的alert告警日志中出现以下报错:
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'yang1'. Error is 16191.
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
可以确定一点,sys用户的密码没有改,看很多朋友发的要把新主库的密码文件传输至备库一份,这也是一种解决思路。
说一下我当时的解决过程
首先进到新的主库的$ORACLE_HOME/dbs下看密码的文件时候发现
数据库的密码文件权限不对,图中属于root用户,root组的密码文件就是当时新的主库密码把密码文件的权限修改完成以后(密码文件应该属于oracle用户和oisntall组),在备库上重新应用了一下日志,发现新的主库的archivelog可以传输至备库。