ITPub博客

首页 > 数据库 > Oracle > ORA-29770: global enqueue process LMON is hung

ORA-29770: global enqueue process LMON is hung

原创 Oracle 作者:骑驴射大飞机 时间:2022-01-04 15:55:19 0 删除 编辑

#背景:

AIX Oracle11.2.0.4 RAC

节点2实例异常重启。



#数据库alert日志:


Sun Jan 02 23:08:13 2022

LMON (ospid: 4981218) waits for event 'rdbms ipc message' for 90 secs.

Sun Jan 02 23:08:28 2022

Errors in file /u01/app/oracle/diag/rdbms/bjsbjl/bjsbjl2/trace/bjsbjl2_lmhb_3736326.trc  (incident=336164):

ORA-29770: global enqueue process LMON (OSID 4981218) is hung for more than 70 seconds

Incident details in: /u01/app/oracle/diag/rdbms/bjsbjl/bjsbjl2/incident/incdir_336164/bjsbjl2_lmhb_3736326_i336164.trc

Sun Jan 02 23:08:36 2022

Sweep [inc][336164]: completed

Sweep [inc2][336164]: completed

Sun Jan 02 23:08:40 2022

ERROR: Some process(s) is not making progress.

LMHB (ospid: 3736326) is terminating the instance.

Please check LMHB trace file for more details.

Please also check the CPU load, I/O load and other system properties for anomalous behavior

ERROR: Some process(s) is not making progress.

LMHB (ospid: 3736326): terminating the instance due to error 29770

Sun Jan 02 23:08:40 2022

System state dump requested by (instance=2, osid=3736326 (LMHB)), summary=[abnormal instance termination].

System State dumped to trace file /u01/app/oracle/diag/rdbms/bjsbjl/bjsbjl2/trace/bjsbjl2_diag_6619226_20220102230840.trc

Instance terminated by LMHB, pid = 3736326




#lmbh的trace文件:


*

略

*

Short stack dump: ORA-32516: cannot wait for process 'Unix process pid: 4981218, image: oracle@gshsqjdb02 (LMON)' to finish executing ORADEBUG command 'SHORT_STACK'; wait time exceeds 2495 ms

*

略

*

kjfmGCR_HBCheckAll: 1 process failed HBStatusCheck

kjfmGCR_HBAnalyze: LMON has no heartbeat


*** 2022-01-02 23:08:28.904

==============================

LMON (ospid: 4981218) has not moved for 113 sec (1641136108.1641135995)

Incident 336164 created, dump file: /u01/app/oracle/diag/rdbms/bjsbjl/bjsbjl2/incident/incdir_336164/bjsbjl2_lmhb_3736326_i336164.trc

ORA-29770: global enqueue process LMON (OSID 4981218) is hung for more than 70 seconds


ORA-32515: cannot issue ORADEBUG command 'SHORT_STACK' to process 'Unix process pid: 4981218, image: oracle@gshsqjdb02 (LMON)'; prior command execution time exceeds 2486 ms

*

略

*



#MOS上有篇文档:


OERR: ORA-29770 "global enqueue process %s (OSID %s) is hung for more than %s seconds" Reference Note (Doc ID 2010718.1)

其中找到29770关于LMON的一个bug:

Bug Fixed Description

27254851 18.3, 19.1 INSTANCE CRASHED WITH ORA-29770 DUE TO LMON HAS NOT HEARTBEAT

该问题在18,19版本才修复。


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

请登录后发表评论 登录
全部评论

注册时间:2018-12-03

  • 博文量
    11
  • 访问量
    9505