> 데이터 베이스 > MySQL 튜토리얼 > ORA-16191 PING[ARC2]: Heartbeat failed to connect to standby

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

WBOY
풀어 주다: 2016-06-07 16:47:35
원래의
2329명이 탐색했습니다.

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

관련 라벨:
원천:php.cn
본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
인기 튜토리얼
더>
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿