#背景: 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版本才修复。
ORA-29770: global enqueue process LMON is hung
来源:这里教程网
时间:2026-03-03 17:21:37
作者:
编辑推荐:
- ORA-29770: global enqueue process LMON is hung03-03
- [20220104]in list 几种写法性能测试.txt03-03
- [20220105]建立非唯一主键对性能有影响吗.txt03-03
- [20220105]再论ORA-29275与toad 12.txt03-03
- [20220105]sqlplus &1替换最大支持239个字符.txt03-03
- [重庆思庄每日技术分享]-ORACLE12.2以上版本 对象名长度限制超过30个字符03-03
- 十个关于互联网圈的冷知识03-03
- oracle ocp 19c考题9,科目082考试题-关于SAVEPOINT03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 十个关于互联网圈的冷知识
十个关于互联网圈的冷知识
26-03-03 - Oracle:SCN
Oracle:SCN
26-03-03 - 内存卡视频删除后怎么恢复?三个步骤一看就会
内存卡视频删除后怎么恢复?三个步骤一看就会
26-03-03 - 批量锁(适用各种关系型数据库)
批量锁(适用各种关系型数据库)
26-03-03 - DATAGUARD配置参数详细解释
DATAGUARD配置参数详细解释
26-03-03 - 数据迁移
数据迁移
26-03-03 - 临时表空间ORA-1652问题解决
临时表空间ORA-1652问题解决
26-03-03 - 【CORE】在UNIX环境下从核心文件获取堆栈信息
【CORE】在UNIX环境下从核心文件获取堆栈信息
26-03-03 - 「Oracle」客户端 PL/SQL DEVELOPER 安装使用
「Oracle」客户端 PL/SQL DEVELOPER 安装使用
26-03-03 - Oracle的过载保护-数据库资源限制
Oracle的过载保护-数据库资源限制
26-03-03
