ORA-00600 [qmtcolcb_nomatch], [ID], [annotation] During Upgrade From 11.2.0.x To 12.2.0.1

(Doc ID 2311381.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
IBM AIX on POWER Systems (64-bit)

Symptoms

The upgrade of an 11.2.0.x database to 12.2.0.1 failed with ORA-00600 [qmtcolcb_nomatch], [ID], [annotation].

The upgrade spool file, catupgrd0.log, shows multiple occurrences of the error, e.g.:

...
...
16:16:38 SQL> create or replace force view sys.ku$_xmlschema_elmt_view
16:16:38 2 of sys.ku$_xmlschema_elmt_t with object identifier(schemaoid, elemnum) as
16:16:38 3 select
16:16:38 4 opq.obj#,
16:16:38 5 opq.intcol#,
16:16:38 6 opq.schemaoid,
16:16:38 7 extractValue(value(schm),
16:16:38 8 '/schema/@x:schemaURL',
16:16:38 9 'xmlns="http://www.w3.org/2001/XMLSchema"'||
16:16:38 10 ' xmlns:x="http://xmlns.oracle.com/xdb"'),
16:16:38 11 opq.elemnum,
16:16:38 12 DBMS_XMLSCHEMA.GetSchemaElementName( opq.schemaoid,opq.elemnum)
16:16:38 13 from sys.opqtype$ opq, xdb.xdb$schema schm
16:16:38 14 where opq.schemaoid = schm.sys_nc_oid$
16:16:38 15 /
from sys.opqtype$ opq, xdb.xdb$schema schm
*
ERROR at line 13:
ORA-00600: internal error code, arguments: [qmtcolcb_nomatch], [ID], [annotation], [], [], [], [], [], [], [], [], []
...
...


The call stack from incident trace file of the ORA-00600 [qmtcolcb_nomatch] shows:

<- qmtkcolinfo_cb <- opifcr <- qersoFetchSimple <- qersoFetch <- opifch2 <- opiall0
<- opikpr <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2
<- kprball <- qmtkGetColumnInfo_exp <- koksxmlticm <- koksicm2 <- kokaccx <- kokacmc
<- kksLoadChild <- kglobld <- kglobpn <- kglpim <- kglpin <- kxsGetRuntimeLock
<- kksfbc <- kkspsc0 <- kokapvpr <- kokacau <- kokasuc <- kokavpr
<- kokageti <- qmskLoadXob_helper <- qmskGetXobd <- qmxiCreateRefXob <- qmxiManifestVArray <- qmxiManifestFromImage_int
<- qmxiManifestFromImage <- qmxManifest0 <- qmxManifest <- qmsCreateXobdFromImage <- qmskLoadXob_helper <- qmskGetXobd
<- qmtLoadSchema <- rpiswu2 <- qm_run_as_ksys <- qmtlod <- kqlCallback <- kqllod_new

 

Changes

 

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