程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> ORA-16191PING[ARC2]:Heartbeatfailedtoconnecttostandby

ORA-16191PING[ARC2]:Heartbeatfailedtoconnecttostandby

編輯:Oracle教程

今天是2014-04-03。隨記一下今天遇到的一個問題吧。

環境介紹:

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。最終問題得到解決:


  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved