Home » Server Options » RAC & Failsafe » Alert log error (ORACLE RAC 12c R1 -ORA-29770 and ORA-1092 as below for few weeks on a 2 node ORACLE RAC 12c Cluster)
Alert log error [message #657334] Mon, 07 November 2016 01:55 Go to next message
naveen_rc2000@yahoo.com
Messages: 7
Registered: November 2016
Location: India
Junior Member
Hi All,

I have been noticing the following ORA-29770 and ORA-1092 as below for few weeks on a 2 node ORACLE RAC 12c Cluster :

Starting background process CJQ0
Sun Nov 06 22:28:14 2016
CJQ0 started with pid=338, OS id=26736
Completed: ALTER DATABASE OPEN /* db agent *//* {0:5:77} */
Sun Nov 06 22:28:18 2016
Setting Resource Manager plan SCHEDULER[0x4212]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Nov 06 23:28:34 2016
LMS3 (ospid: 14860) has not called a wait for 91 secs.
Errors in file C:\ORACLE\diag\rdbms\orcl11\orcl111\trace\orcl111_lmhb_7440.trc (incident=988192):
ORA-29770: global enqueue process LMS3 (OSID 14860) is hung for more than 70 seconds
Incident details in: C:\ORACLE\diag\rdbms\orcl11\orcl111\incident\incdir_988192\orcl111_lmhb_7440_i988192.trc
LOCK_DBGRP: GCR_SYSTEST debug event locked group GR+DB_ORCL11 by memno 1
ERROR: Some process(s) is not making progress.
LMHB (ospid: 7440) 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.
Sun Nov 06 23:28:35 2016
System state dump requested by (instance=1, osid=7440 (LMHB)), summary=[abnormal instance termination].
System State dumped to trace file C:\ORACLE\diag\rdbms\orcl11\orcl111\trace\orcl111_diag_22344_20161106232835.trc
Sun Nov 06 23:28:35 2016
LMHB (ospid: 7440): terminating the instance due to error 29770
Sun Nov 06 23:28:36 2016
opiodr aborting process unknown ospid (23996) as a result of ORA-1092
Sun Nov 06 23:28:36 2016
ORA-1092 : opitsk aborting process
Sun Nov 06 23:28:37 2016
License high water mark = 6
Sun Nov 06 23:28:42 2016
opiodr aborting process unknown ospid (8236) as a result of ORA-1092
Sun Nov 06 23:28:42 2016
ORA-1092 : opitsk aborting process
Sun Nov 06 23:29:24 2016
Instance terminated by LMHB, pid = 7440
Sun Nov 06 23:29:57 2016
Adjusting the default value of parameter parallel_max_servers
from 2560 to 376 due to the value of parameter processes (500)
Starting ORACLE instance (normal) (OS id: 20800)
Sun Nov 06 23:29:57 2016
CLI notifier numLatches:97 maxDescs:915


Request for help in troubleshooting the issue.

Regards,
Naveen
Re: Alert log error [message #657335 is a reply to message #657334] Mon, 07 November 2016 02:03 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have been having node evictions for a few weeks? And have done nothing about it?? If your employer has invested in RAC in order to gain some high availability, he will not be happy. Better start searching on MOS for those various messages, and if you can't find anything, raise a TAR pronto.
Re: Alert log error [message #657362 is a reply to message #657334] Mon, 07 November 2016 09:14 Go to previous message
bpeasland
Messages: 51
Registered: February 2015
Location: United States
Member

LMNn is one of the multiple processes involved in Cache Fusion. If it is having difficulties, there are typically one of two areas of concern, either a slow or improperly functioning Cluster Interconnect or resource starvation (typically CPU).

Cheers,
Brian
Previous Topic: Doubts on Oracle RAC
Next Topic: Oracle 11gr2 RAC checklist required
Goto Forum:
  


Current Time: Thu Mar 28 05:10:10 CDT 2024