ORA-00600 [KCBGTCR_1A] On Advanced Queue After Database Upgrade TO 11.2.0.2.0 (Doc ID 1377882.1)

Last updated on MARCH 09, 2019

Applies to:

Symptoms

Alert log shows following error after database upgrade to Oracle release 11.2.0.2.0:

ORA-00600: internal error code, arguments: [kcbgtcr_1a], [0], [0], [1], [808], [], [], [], [], [], [], []

Trace file shows querying a queue with following stack trace:

select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no,
enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid,
time_manager_info, sender_name, sender_address, sender_protocol
from "APPS"."ECX_OUTQUEUE"
where time_manager_info <= :1 and state <> :2  for update skip locked

Stack trace:

kcbgtcr <- ktrgtc2 <- kdiixs1 <- kwqmsiots <- kwqmScanScIndexSeg
<- kwqitFreeIndexBlock <- kwqitremb <- kwqitmmit <- kwqitmmsgs <- kwqitptm
<- kwqmnslv <- ksvrdp <- opirip <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main <- start

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.