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 22.214.171.124 to 126.96.36.199 [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.
While refreshing a materialized view in 188.8.131.52, the following error is raised:
There is no Current SQL Statement in the associated incident trace file, but the PL/SQL Call Stack shows:
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:
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 global information:
process: 0x79601d30, call: 0x65911460, xact: 0x6865c0d8, curses:
0x796dc658, usrses: 0x796dc658
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.
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