ORA-29770: global enqueue process is hung for more than 70 seconds 问题分析

上午8点52分左右,数据库2节点发生单节点重启,未影响业务。查看alert日志,数据库alert日志报错如下:

Wed Sep 12 08:52:58 2018
LMS3 (ospid: 54068602) has not called a wait for 91 secs.
Errors in file /opt/app/oracle/diag/rdbms/tnmsdb/tnmsdb2/trace/tnmsdb2_lmhb_28770344.trc  (incident=3252514):
ORA-29770: global enqueue process LMS3 (OSID 54068602) is hung for more than 70 seconds
Incident details in: /opt/app/oracle/diag/rdbms/tnmsdb/tnmsdb2/incident/incdir_3252514/tnmsdb2_lmhb_28770344_i3252514.trc
ERROR: Some process(s) is not making progress.
LMHB (ospid: 28770344) is terminating the instance.

查看8点51分左右的系统资源情况:

 
Cpu,内存等资源处于正常状态,排查系统资源不足造成的单节点重启。查看tnmsdb2_lmhb_28770344.trc

 
通过搜索MOS,发现和Bug 13718279 – DB instance terminated due to ORA-29770 in RAC (文档 ID 13718279.8) 情况基本吻合,都是kjfmGCR_HBCheckAll去检查LMS进程的时候报出status 2,然后waiting for event ‘gcs remote message’

 
解决办法就是把_gc_defer_time设置为3.

分享到: 更多

Post a Comment

Your email is never published nor shared. Required fields are marked *