【BUG】RAC instance eviction in oracle11.2.0.4

系统环境：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, patch 19188987 should be applied
For 11.2.0.3 DB PSU12, patch 19675328 should be applied

For 11.2.0.4 DB PSU6, patch 20799483 should be applied

 

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29487349/viewspace-2140836/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29487349/viewspace-2140836/