ORA-00494: enqueue [CF] held for too long (more than 900 seconds); LGWR:Terminating Instance Due to Error 2103 (Doc ID 1089733.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

You see the following issue in the alert.log:

KCF: write/open error block=0x9a989 online=1
file=7 /Oratemp/oradata/M6DTH/temp07.dbf
error=27063 txt: 'IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 24576'
Automatic tempfile offline due to write error on
file 7: /Oratemp/oradata/M6DTH/temp07.dbf

ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 2876448'

LGWR: terminating instance due to error 2103
ORA-02103: PCC: inconsistent cursor cache (out-of-range cuc ref)



Some or all of the following function codes may be found in the 'stack trace' portion of the associated trace file.:
------------- Call Stack ---------------
sskgpwwait
skgpwwait
ksliwat
kslwaitns_timed
kskthbwt
kslwait
kcbbpibr
kcfbsy
kcfbof
kcfofa
ksbabs
ksbrdp
opirip
opidrv
sou2o
opimai_real
main
__start()

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms