Expdp Fails With ORA-600 [17147] ORA-600 [17278] or Similar Internal Errors When the Parameter SCHEMAS is Used (Doc ID 960091.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

DataPump export started with user SYSTEM and parameter SCHEMAS fails with errors

ORA-00600: internal error code, arguments: [17114], [0x9FFFFFFFFCDF1F38], [], [], [], [], [], []

The trace file mentions:

ORA-00600: internal error code, arguments: [17114], [0x9FFFFFFFFCDF1F38], [], [], [], [], [], []

or ORA-600 [17147]

Current SQL statement for this session:
SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(:"SYS_B_00", :"SYS_B_01")),
KU$.OBJ_NUM ,
KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SCHEMA_OBJ.NAME
,KU$.SCHEMA_OBJ.NAME ,:"SYS_B_02" ,
KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_PROCDEPOBJ_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND NOT
BITAND(KU$.BASE_OBJ.FLAGS,:"SYS_B_03")!=:"SYS_B_04" AND KU$.BASE_OBJ.OWNER_NAME IN (
SELECT object_name FROM "SYSTEM"."SYS_EXPORT_SCHEMA_18" WHERE process_order = -:"SYS_B_05" AND
duplicate BETWEEN :"SYS_B_06" AND :"SYS_B_07") AND NOT EXISTS (
...

with a stack trace similar to:

kgherror kghfrmrg kghfre kghfrh_internal kghfrh $cold_qescaFree $cold_qerjoFetch qerjoFetch rwsfcd qerhjFetch qerflFetchOutside kpofrws opifch2 opifch opipls  ...

Also an ORA-600 [17278] is a possible symptom of this issue.

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