系统环境：oracle rac 11.2.0.4 （无任何补丁）操作系统：aix 7100

现象：两个节点RAC，实例只能启动一台，两个实例同时起，会出现节点驱逐，IPC send timeout 等情况，查看警告日志，出现以下类似（原系统无法拷贝日志）输出：

alert_<evicting instance>.log

点击(此处)折叠或打开

Sat Jan 25 21:59:54 2014
Remote instance 2 kill is issued with system inc 7
LMON received an instance eviction notification from instance 1
The instance eviction reason is 0x2
The instance eviction map is 2
Reconfiguration started (old inc 7, new inc 9)
List of instances:

alert_<evicted instance>.log

点击(此处)折叠或打开

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

lmd0 trace：

点击(此处)折叠或打开

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博客

【BUG】RAC instance eviction in oracle11.2.0.4

最新文章