Data Pump Export Fails with ORA-39014 ORA-39029 ORA-31671 ORA-00600 [qmx: no ref]

(Doc ID 760226.1)

Last updated on AUGUST 13, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2104***

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 /oracle/diag/rdbms/dbsbx04/DBSBX04/trace/DBSBX04_dw01_6176902.trc (incident=104722):
ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []
Incident details in:
/oracle/diag/rdbms/dbsbx04/DBSBX04/incident/incdir_104722/DBSBX04_dw01_6176902_i104722.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

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