SAP Knowledge Base Article - Preview

3195202 - Oracle crash . . . ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst #, osid ######'

Symptom

ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 260146'
Incident details in: /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/incident/incdir_8068220/N6P_ora_1676492_i8068220.trc
[3 character Day of Week] [3 character Mon] DD HH[24]:01:03 YYYY
Errors in file /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/<SID>_ora_1681006.trc (incident=8068364):
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 260146'
Incident details in: /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/incident/incdir_8068364/N6P_ora_1681006_i8068364.trc
[3 character Day of Week] [3 character Mon] DD HH[24]:01:35 YYYY
Killing enqueue blocker (pid=######) on resource CF-00000000-00000000-00000000-00000000 by (pid=1676492)
by killing session 9964.41969
KILL SESSION for sid=(9964, 41969):
Reason = RAC enqueue blocker
Mode = KILL SOFT -/-/-
Requestor = USER (orapid = 3338, ospid = 1676492, inst = 1)
Owner = Process: CKPT (orapid = 27, ospid = 260146)
Result = ORA-29
Killing enqueue blocker (pid=260146) on resource CF-00000000-00000000-00000000-00000000 by (pid=1676492)
by terminating the process
USER (ospid: 1676492): terminating the instance due to ORA error 2103
Cause - 'Instance is being terminated due to ospid 260146 holding an enqueue CF-00000000-00000000-00000000-00000000)'
Day Mon ## 24:MM:SS YYYY
System state dump requested by (instance=#, osid=#######), summary=[abnormal instance termination].


Read more...

Environment

Oracle DB

NFS file system

NFS file share mounted to service Oracle DB control files

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.