【BUG】RAC instance eviction in oracle11.2.0.4

xysoul_雲龍發表於2017-06-16
Oracle

系統環境：oracle rac 11.2.0.4 （無任何補丁）  作業系統：aix 7100

現象：兩個節點RAC， 例項只能啟動一臺，兩個例項同時起，會出現節點驅逐，IPC send timeout 等情況，檢視警告日誌，出現以下類似（原系統無法複製日誌）輸出：

  • alert_<evicting instance>.log

點選(此處)摺疊或開啟

  1. Sat Jan 25 21:59:54 2014
  2. Remote instance 2 kill is issued with system inc 7
  3. LMON received an instance eviction notification from instance 1
  4. The instance eviction reason is 0x2
  5. The instance eviction map is 2
  6. Reconfiguration started (old inc 7, new inc 9)
  7. List of instances:
  • alert_<evicted instance>.log

點選(此處)摺疊或開啟

  1. Sat Jan 25 21:59:54 2014
  2. LMON received an instance eviction notification from instance 1
  3. The instance eviction reason is 0x2
  4. The instance eviction map is 2
  5. Sat Jan 25 21:59:54 2014
  6. LMS1 (ospid: 18350986) received an instance eviction notification from instance 1 [2]
  7. Sat Jan 25 21:59:56 2014
  8. PMON (ospid: 17367262): terminating the instance due to error 481


lmd0 trace：

點選(此處)摺疊或開啟

  1. tkt total 333 avl 0 sp_rsv 13 max_sp_rsv 82 ==>>>> avl 0

出現以上問題屬於BUG：

關於LMS LMD程式類 可參考以下文章：

http://blog.itpub.net/29487349/viewspace-2140833/

關於BUG說明 可以參考以下：
BUG 18153979 - KJFCDRMRCFG: WAITED 249 SECS FOR LMD TO RECEIVE ALL FTDONES IN SYNC STEP 34
BUG 18181293 - LMON RECEIVED AN INSTANCE EVICTION NOTIFICATION FROM INSTANCE N 
BUG 17588778 - INSTANCE EVICTED WITH TIMEOUT WAITING FOR RECEIVER SYNC FOR INDIRECT MESSAGING 
BUG 18182076 - THIRD INSTANCE GOT RESTARTED
BUG 18096151 - LMS0 : TERMINATING THE INSTANCE DUE TO ERROR 481 

各版本補丁：

The solution is to apply merge patch of the following bugs:

Bug 16819962 - cdb_rac : instance terminated by lmd0 - lmon received an instance eviction

Fixed in 12.1.0.2

Bug 17452841 - lms hit ora-600 [kjctsrw:1]

Fixed in 12.1.0.2

Bug 17801017 - fa + index comp : instance terminated by lmd0 - lmon received an instance evict

Fixed in 12.1.0.2

Bug 17847764 - fa + index comp: ora-481 lmon inst evict - abnormal instance termination by lmd0

Fixed in 12.1.0.2

Bug 16088176 - RAC hang / LMD crashes instance with ORA-600[kjmscndscq:timeout]

Fixed in 11.2.0.3 DB PSU11, 11.2.0.4, 12.1.0.2


For 11.2.0.3 DB PSU11,  should be applied
For 11.2.0.3 DB PSU12,  should be applied

For 11.2.0.4 DB PSU6,  should be applied

 

As a temporary workaround, increase hidden parameter _lm_tickets by 50%.




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29487349/viewspace-2140836/，如需轉載，請註明出處，否則將追究法律責任。

相關文章