alert 报错

TNS-00505: Operation timed out
    nt secondary err code: 238
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x x x x)(PORT=59960))
Wed Mar 24 18:08:12 2021
LMS0 (ospid: 28907) has not called a wait for 2 secs.
Errors in file /u01/app/oracle/diag/rdbms/bxpasdb/bxpasdb2/trace/bxpasdb2_lmhb_28929.trc  (incident=736205):
ORA-29770: global enqueue process LMS0 (OSID 28907) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/bxpasdb/bxpasdb2/incident/incdir_736205/bxpasdb2_lmhb_28929_i736205.trc
ERROR: Some process(s) is not making progress.
LMHB (ospid: 28929) 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: 28929): terminating the instance due to error 29770
Wed Mar 24 18:08:21 2021
opiodr aborting process unknown ospid (6644) as a result of ORA-1092
Wed Mar 24 18:08:21 2021
System state dump requested by (instance=2, osid=28929 (LMHB)), summary=[abnormal instance termination].
Wed Mar 24 18:08:21 2021
opiodr aborting process unknown ospid (17767) as a result of ORA-1092
System State dumped to trace file /u01/app/oracle/diag/rdbms/bxpasdb/bxpasdb2/trace/bxpasdb2_diag_28893_20210324180821.trc
Wed Mar 24 18:08:26 2021
ORA-1092 : opitsk aborting process
Wed Mar 24 18:08:26 2021
Instance terminated by LMHB, pid = 28929
Wed Mar 24 18:08:34 2021
Starting ORACLE instance (normal)

复制

trace 文件

*** 2021-03-24 18:08:18.935
==============================
LMS0 (ospid: 28907) has not moved for 130 sec (1616580498.1616580368)
Incident 736205 created, dump file: /u01/app/oracle/diag/rdbms/bxpasdb/bxpasdb2/incident/incdir_736205/bxpasdb2_lmhb_28929_i736205.trc
ORA-29770: global enqueue process LMS0 (OSID 28907) is hung for more than 70 seconds

kjfmGCR_HBdisambig: action=Inst-kill
kjgcr_Main: KJGCR_ACTION - id 1

*** 2021-03-24 18:08:21.065
kjgcr_poll: Group locked by memno - 3

*** 2021-03-24 18:08:21.065
kjgcr_grouplock: Acquired group lock!

*** 2021-03-24 18:08:21.065
==============================
LMS0 (ospid: 28907) has not moved for 132 sec (1616580500.1616580368)
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+592<-kjzdssdmp()+720<-kjzduptcctx()+512<-kjzdicrshnfy()+160<-$cold_ksuitm()+5808<-kjgcr_KillInstance()+304<-kjgcr_Main()+9744<-kjfmlmhb_Main()+208<-ksbrdp()+2832<-opirip()+1312<-opidrv()+1152<-sou2o()+256<-opimai_real()+352<-ssthrdmain()+608<-main()+336
<-main_opd_entry()+80 
----- End of Abridged Call Stack Trace -----

*** 2021-03-24 18:08:21.124
LMHB (ospid: 28929): terminating the instance due to error 29770

复制

问题点：为什么(ospid: 28929)会导致实例终止