Heim > Datenbank > MySQL-Tutorial > ORA-16191 PING[ARC2]: Heartbeat failed to connect to standby

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

WBOY
Freigeben: 2016-06-07 16:47:35
Original
2340 Leute haben es durchsucht

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。

linux

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage