Datapump Export Fails With ORA-7445 [qmtsGetSchemaDepLvl_int() ] (Doc ID 949167.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

You are performing a Data Pump export (expdp) and  fails with the following errors:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

In the alert log is reported the error: 

ORA-7445: exception encountered: core dump [qmtsGetSchemaDepLvl_int()+1613]  [SIGSEGV] [ADDR:0x18] [PC:0x5447A67] [Address not mapped to object] []

Review of the trace file shows the following statement:

----- Current SQL Statement for this session (sql_id=52ctyk6wnzqtq) -----
SELECT /*+rule*/ KU$.STRIPPED_VAL, 0 ,KU$.LOCAL ,KU$.URL ,KU$.URL ,'XMLSCHEMA' ,
KU$.OWNER_NAME FROM SYS.KU$_XMLSCHEMA_VIEW KU$ WHERE KU$.OWNER_NAME LIKE '%'
AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='XMLSCHEMA'
AND A.NAME=KU$.URL AND A.SCHEMA=KU$.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM
SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.OWNER_NAME) ORDER
BY KU$.SCHEMA_LEVEL
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x87859680 424 package body XDB.DBMS_XDBUTIL_INT
0x8bd82520 1350 package body SYS.DBMS_METADATA
0x8bd82520 2008 package body SYS.DBMS_METADATA
0x8bd82520 2314 package body SYS.DBMS_METADATA
0x8bd82520 4676 package body SYS.DBMS_METADATA
0x84f9d7b0 2421 package body SYS.KUPW$WORKER
0x84f9d7b0 8504 package body SYS.KUPW$WORKER
0x863b9d50 1 anonymous block
0x8aa11190 1575 package body SYS.DBMS_SQL
0x84f9d7b0 8342 package body SYS.KUPW$WORKER
0x84f9d7b0 1545 package body SYS.KUPW$WORKER
0x7f3cab18 2 anonymous block

The rrace file will show stack similar to the following:

... qmtsGetSchemaDepLvl_int <- qmtsGetSchemaDepLvlCB <- rpiswu2 <- qm_run_as_user <- qmtsGetSchemaDepList <- qmpxGetSchemaDepLevel <- spefcifa <- spefmccallstd <- pextproc <- peftrusted ....

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