ora-16191 ping[arc2]: heartbeat failed to connect to standby
随记一下今天遇到的一个问题吧。
环境介绍：
gi version：11.2.0.4.0
database version：11.2.0.4.0
oracle linux：linux server release 6.4
rac双节点asm+restart-alone asm
问题描述：
在duplicate 数据库后再启动standby 数据库的实时应用时出现在rac1可以正常连接 standby,但rac2无法连接，如下错误：
standby database：
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。