Oracle alert文件分析(五)
up to hang ID=139 detected
2013-05-20 08:53:10.928000 +08:00
DIA0 terminating blocker (ospid: 18743428 sid: 903 ser#: 7) of hang with ID = 139
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
significant number of affected sessions.
by terminating the process
DIA0 successfully terminated process ospid:18743428.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=139.
2013-05-20 08:54:22.281000 +08:00
LMON (ospid: 6357366) waits for event 'Disk file operations I/O' for 81 secs.
2013-05-20 08:54:37.385000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_lmhb_6619738.trc (incident=72153):
ORA-29770: global enqueue process LMON (OSID 6357366) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/tlodb/tlodb1/incident/incdir_72153/tlodb1_lmhb_6619738_i72153.trc
2013-05-20 08:54:48.544000 +08:00
ERROR: Some process(s) is not making progress.
LMHB (ospid: 6619738) is terminating the instance. -- http://www.askmaclean.com/archives/11gr2-lmhb-lock-manager-heart-beat.
html
Please check LMHB trace file for more details.
Please also check the CPU load, I/O load and other system properties for anomalous behavior
Please check LMHB trace file for more details.
Incident details in: /u01/app/oracle/diag/rdbms/tlodb/tlodb1/incident/incdir_72153/tlodb1_lmhb_6619738_i72153.trc
2013-05-20 08:54:48.544000 +08:00
2013-05-20 08:54:48.544000 +08:00
ERROR: Some process(s) is not making progress.
LMHB (ospid: 6619738) is terminating the instance.
LMHB (ospid: 6619738) 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: 6619738): terminating the instance due to error 29770
Please also check the CPU load, I/O load and other system properties for anomalous behavior
Please also check the CPU load, I/O load and other system properties for anomalous behavior
ERROR: Some process(s) is not making progress.
Please also check the CPU load, I/O load and other system properties for anomalous behavior
ERROR: Some process(s) is not making progress.
ERROR: Some process(s) is not making progress.
LMHB (ospid: 6619738): terminating the instance due to error 29770
System state dump requested by (instance=1, osid=6619738 (LMHB)), summary=[abnormal instance termination].
Dumping diagnostic data in directory=[cdmp_20130520085448], requested by (instance=1, osid=6619738 (LMHB)), summary=[abnorma
System state dump requested by (instance=1, osid=6619738 (LMHB)), summary=[abnormal instance termination].
Dumping diagnostic data in directory=[cdmp_20130520085448], requested by (instance=1, osid=6619738 (LMHB)), summary=[abnorma
l instance termination].
ORA-1092 : opitsk aborting process
Dumping diagnostic data in directory=[cdmp_20130520085448], requested by (instance=1, osid=6619738 (LMHB)), summary=[abnorma
l instance termination].
ORA-1092 : opitsk aborting process
2013-05-20 08:55:02.927000 +08:00
Termination issued to instance processes. Waiting for the processes to exit
2013-05-20 08:55:08.929000 +08:00
Instance