报错信息:
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
产生情况是这样的,一套rac的dataguard,在搭建完成后开启standby seesion后主备库都在不断报ORA-16191,这个错误出现时候也没有发现伴随错误,而且三个实例的password是一样的,只是orapw文件是每个实例单独生成.
根据错误描述,是怀疑此DG的pri和std的密码文件密码不一致导致,逐用统一命令重建实例1和STD的密码文件,报错依旧.节点2重建密码文件,报错依旧.
其次对节点1的密码文件拷贝到std中,并修改orapw对应的实例名,重启standby session,rac节点1和standby的实例不再报错ora-16191,而实例二依然再报ora-16191,将节点1的密码文件拷贝至节点2,并修改对应实例名,报错消失,至此日志传输以及应用恢复正常.
相关Metalink文档排障思路参考文档:
Troubleshooting – Heartbeat failed to connect to standby (文档 ID 1432367.1)
