LMHB (ospid: XXXX): terminating the instance due to error 29770
(Doc ID 2438319.1)
Last updated on FEBRUARY 15, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
From DB Alert log
Thu Aug 02 13:45:11 2018
opiodr aborting process unknown ospid (359201) as a result of ORA-609
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_lmhb_4038.trc (incident=5794665):
ORA-29770: global enqueue process LMON (OSID 3997) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/ORCL/ORCL1/incident/incdir_5794665/ORCL1_lmhb_4038_i5794665.trc
Thu Aug 02 13:45:16 2018
Dumping diagnostic data in directory=[cdmp_20180802134514], requested by (instance=2, osid=310375 (PXMN)), summary=[incident=5091556].
Thu Aug 02 13:45:21 2018
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_ora_336098.trc (incident=5799425):
ORA-00445: background process "P0BG" did not start after 120 seconds
Incident details in: /u01/app/oracle/diag/rdbms/ORCL/ORCL1/incident/incdir_5799425/ORCL1_ora_336098_i5799425.trc
Thu Aug 02 13:45:30 2018
LOCK_DBGRP: GCR_SYSTEST debug event locked group GR+DB_ORCL by memno 0
Thu Aug 02 13:45:45 2018
ERROR: Some process(s) is not making progress.
LMHB (ospid: 4038) 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: 4038): terminating the instance due to error 29770 ============> Terminating the instance.
Thu Aug 02 13:46:02 2018
ORA-1092 : opitsk aborting process
Thu Aug 02 13:46:10 2018
ORA-1092 : opitsk aborting process
Thu Aug 02 13:46:11 2018
Instance terminated by LMHB, pid = 4038
Thu Aug 02 13:46:12 2018
USER (ospid: 361469): terminating the instance
Thu Aug 02 13:46:12 2018
Instance terminated by USER, pid = 361469 ==========================> Instance Terminated.
Thu Aug 02 13:46:17 2018
Starting ORACLE instance (normal) (OS id: 369291)
opiodr aborting process unknown ospid (359201) as a result of ORA-609
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_lmhb_4038.trc (incident=5794665):
ORA-29770: global enqueue process LMON (OSID 3997) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/ORCL/ORCL1/incident/incdir_5794665/ORCL1_lmhb_4038_i5794665.trc
Thu Aug 02 13:45:16 2018
Dumping diagnostic data in directory=[cdmp_20180802134514], requested by (instance=2, osid=310375 (PXMN)), summary=[incident=5091556].
Thu Aug 02 13:45:21 2018
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_ora_336098.trc (incident=5799425):
ORA-00445: background process "P0BG" did not start after 120 seconds
Incident details in: /u01/app/oracle/diag/rdbms/ORCL/ORCL1/incident/incdir_5799425/ORCL1_ora_336098_i5799425.trc
Thu Aug 02 13:45:30 2018
LOCK_DBGRP: GCR_SYSTEST debug event locked group GR+DB_ORCL by memno 0
Thu Aug 02 13:45:45 2018
ERROR: Some process(s) is not making progress.
LMHB (ospid: 4038) 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: 4038): terminating the instance due to error 29770 ============> Terminating the instance.
Thu Aug 02 13:46:02 2018
ORA-1092 : opitsk aborting process
Thu Aug 02 13:46:10 2018
ORA-1092 : opitsk aborting process
Thu Aug 02 13:46:11 2018
Instance terminated by LMHB, pid = 4038
Thu Aug 02 13:46:12 2018
USER (ospid: 361469): terminating the instance
Thu Aug 02 13:46:12 2018
Instance terminated by USER, pid = 361469 ==========================> Instance Terminated.
Thu Aug 02 13:46:17 2018
Starting ORACLE instance (normal) (OS id: 369291)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |