问题: Dataguard 无法应用 redo log,alert 无任何报错信息
现象: Oracle RAC 一节点 alert 无报错信息, 另一节报如下错误
- Thu Mar 15 15:26:22 2018
- 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
- PING[ARC2]: Heartbeat failed to connect to standby bbdg. Error is 16191.
处理方法: 将无报错节点的密码文件 orapwbbsvri1 拷贝到报错的节点
总结: 如果 sys 密码在 oracle 安装后更改过, 则在搭建 dataguard 的时候必须确保 oracle 所有节点和 dataguard 的密码文件是同一个文件
来源: http://www.bubuko.com/infodetail-2528191.html