My Oracle Support Banner

ORA-600 [ktcrcm: caller passed invalid xcb] on Materialized View Refresh after 12.2 Upgrade (Doc ID 2267485.1)

Last updated on MAY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 While refreshing a materialized view in 12.2.0.1, the following error is raised:

ORA-00600: internal error code, arguments: [ktcrcm: caller passed invalid xcb], [4], [0x1CDA0C9D8], [0x000000000], [1], [4232], [], [], [], [], [], []

 

There is no Current SQL Statement in the associated incident trace file, but the PL/SQL Call Stack shows:

----- PL/SQL Call Stack -----
object line object
handle number name
0x19e4d6fc0 762 package body SYS.DBMS_SNAPSHOT_UTL.WRAP_UP

 

The Call Stack Trace in the associated incident trace file shows:

... ktcCommitTxn_new ktcCommitTxn kkzibwu spefcmpa spefmccallstd peftrusted psdexsp kxe_push_env_internal_pp_
kkx_push_env_for_ICD_for_new_session psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL ...

 

The same incident trace file shows that the error is raised during a transaction commit phase:

PROCESS STATE

-------------
Process global information:
process: 0x79601d30, call: 0x65911460, xact: 0x6865c0d8, curses:
0x796dc658, usrses: 0x796dc658
in_exception_handler: no
SO: 0x6865c0d8, type: 79, owner: 0x796dc658, flag: INIT/-/-/-/0x00 if: 0x3 c:0x3
proc=0x79601d30, name=transaction, file=ktccts.h LINE:492, pg=0,conuid=0
(trans) flg = 0x00000e03, flg2 = 0x00014000, flg3 = 0x00000000, prx =(nil), ros = 2147483647, crtses=0x796dc658
flg = 0x00000e03: ALC TRN VUS VID CHG
flg2 = 0x00014000: IMU IMP
flg3 = 0x00000000:
pdb = 0
bsn = 0x570d37 bndsn = 0x570d38 tbndsn = 0x570d37 spn = 0x570e26
efd = 22 rfd = 0 DID:0001-0048-000381B7 file:kta.c lineno:1804

 

The ORA-600[ktcrcm: caller passed invalid xcb] error is signaled because, while the current transaction is 0x000000000, Oracle is trying to commit 0x0680B6EA8.  However, there is no transaction state object 0x0680B6EA8 available in the incident trace file, implying that this transaction has ended long before.

 

Changes



Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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