Data Pump Export Fails with ORA-39014 ORA-39029 ORA-31671 ORA-00600 [qmx: no ref] (Doc ID 760226.1)

Last updated on MAY 26, 2023

Applies to:

Symptoms

New installation of 11.1.0.7 database.

All database components and options, including XDB and XML (as shown by dba_registry) are in VALID status. There are no invalid objects in the database.

When doing a full Data Pump export getting:
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1602
ORA-06512: at line 2

In the alert log is reported:

Errors in file <ADR_base>/diag/product_type/product_id/instance_id>/trace/<SID>_dw01_<INCIDENT_NUMBER>.trc
ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []
Incident details in:
/oracle/diag/rdbms/<instance_id>/incident/incdir_<number>/<SID>_dw01_<INCIDENT_NUMBER>.trc

The incident trace file shows:
ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=bvxvafwph2t7b) -----
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CLUSTER_T',
'7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'CLUSTER'
,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_CLUSTER_VIEW KU$ WHERE NOT (BITAND
(KU$.SCHEMA_OBJ.FLAGS,16)=16) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND
NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='CLUSTER' AND
A.NAME=KU$.SCHEMA_OBJ.NAME AND A.SCHEMA=KU$.SCHEMA_OBJ.OWNER_NAME) AND NOT
EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND
A.NAME=KU$.SCHEMA_OBJ.OWNER_NAME)
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
7000000b6e9c460 1069 package body SYS.DBMS_METADATA
7000000b6e9c460 1280 package body SYS.DBMS_METADATA
7000000b6e9c460 2008 package body SYS.DBMS_METADATA
7000000b6e9c460 2314 package body SYS.DBMS_METADATA
7000000b6e9c460 4676 package body SYS.DBMS_METADATA
7000000b6676d50 2 anonymous block

Call Stack Trace

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf ...

Environment variables for OS user that did the export are correctly set (LD_LIBRARY_PATH is correctly set).

Cause

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