ORA-16191 PING[ARC2]: Heartbeat failed to connect to standby

2014-11-24 17:27:36 · 作者: · 浏览: 0

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
------------------------------------------------------------
FAL[client, USER]: Error 16191 connecting to Rac for fetching gap sequence
Thu Apr 03 18:16:24 2014
RFS[6]: Assigned to RFS process 3836
RFS[6]: Opened log for thread 2 sequence 30 dbid -1867447592 branch 839537688
Archived Log entry 13 added for thread 2 sequence 30 rlc 839537688 ID 0x90b182d8 dest 2:
Thu Apr 03 18:16:26 2014
Media Recovery Log +FRA1/dg/archivelog/2014_04_03/thread_2_seq_30.288.843934585
Media Recovery Waiting for thread 2 sequence 31
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
------------------------------------------------------------
FAL[client, USER]: Error 16191 connecting to Rac for fetching gap sequence


RAC2错误如下:


PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 16191.
Thu Apr 03 18:23:28 2014
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 'DG'. Error is 16191.
Thu Apr 03 18:24:29 2014
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 'DG'. Error is 16191.


问题排查:


检查remote_loging_passwordfile参数设置皆为EXCLUSIVE。其他参数没有任何可疑问题。


问题解决:


既然日志中提示认证出现问题,且只有一个节点可以连接到standby database,那么将该节点的密码文件传到节点RAC2。