Re: RAC instance crash

Posted by ErmanArslansOracleBlog on Nov 21, 2019; 2:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RAC-instance-crash-tp7856p7881.html

Okay. I will try to help you..

*load averages seem acceptable. There are some peaks but not so sharp peaks.

*You have an instance termination ->

Errors in file /u01/app/oracle/diag/rdbms/cdbiamas/cdbiamas1/trace/cdbiamas1_lmhb_368993.trc  (incident=6943370) (PDBNAME=CDB$ROOT):
ORA-29770: global enqueue process IPC0 (OSID 368909) is hung for more than 70 seconds
Incident details in: /u01/app/oracle/diag/rdbms/cdbiamas/cdbiamas1/incident/incdir_6943370/cdbiamas1_lmhb_368993_i6943370.trc
2019-11-15T14:51:57.035439+04:00
ERROR: Some process(s) is not making progress.
LMHB (ospid: 368993) 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

*your syslog is clean.

*your db version is 12.2.0.1.


OKAY.. We need to see the LHMB trace as well..
There is a known issue about this-> LMHB (ospid: XXXX): terminating the instance due to error 29770 (Doc ID 2438319.1)
Did you review the note above?