Compilation Of DBMS_WORKLOAD_REPLAY Fails With ORA-00600 [qmxtcCreateCreateIdn :lxXmlIdConv] (Doc ID 2471177.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Compiling the invalid sys.DBMS_WORKLOAD_REPLAY fails with ORA-00600 [qmxtcCreateCreateIdn :lxXmlIdConv] in an upgraded database from 11.2.0.4 to 12.2.0.1

Example:

select host_name, instance_name, version from v$instance;

HOST_NAME                      INSTANCE_NAME    VERSION
------------------------------ ---------------- -----------------
<host>                              orcl1                     12.2.0.1.0

SQL> select owner,object_name,object_type,status from dba_objects where owner in ('SYS','SYSTEM','MDSYS') and status='INVALID';

OWNER    OBJECT_NAME                      OBJECT_TYPE             STATUS
-------- -------------------------------- ----------------------- -------
SYS      DBMS_WORKLOAD_REPLAY             PACKAGE BODY            INVALID

SQL> alter package DBMS_WORKLOAD_REPLAY compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_WORKLOAD_REPLAY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
8956/5   PL/SQL: SQL Statement ignored
8956/14  PL/SQL: ORA-00600: internal error code, arguments:
        [qmxtcCreateCreateIdn :lxXmlIdConv], [], [], [], [], [], [], [],
        [], [], [], []

11805/5  PL/SQL: SQL Statement ignored
11813/30 PL/SQL: ORA-00600: internal error code, arguments:
        [qmxtcCreateCreateIdn :lxXmlIdConv], [], [], [], [], [], [], [],
        [], [], [], []

Db characterset:

SQL> SELECT substrb(parameter,1,24)parameter,
2  substrb(value,1,12)value
3  FROM nls_database_parameters
4  WHERE parameter LIKE '%SET' ORDER BY 1;

PARAMETER                VALUE
------------------------ ------------
NLS_CHARACTERSET         ZHS32GB18030    <---- Simplified Chinese
NLS_NCHAR_CHARACTERSET   AL16UTF16

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.