Datapump Import Fails With ORA-00600[qerxtGetRefOffset_911] Error On 12c Database (Doc ID 2132456.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Importing into a 12c database a 10g dump file is failing with:

...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-600: internal error code, arguments: [qerxtGetRefOffset_911], [], [],[], [], [], [], [], [], [], [], []
ORA-6512: at "SYS.DBMS_SQL", line 1707
ORA-6512: at "SYS.KUPD$DATA", line 2495
ORA-6512: at "SYS.KUPD$DATA", line 3503
ORA-6512: at "SYS.KUPD$DATA", line 3764
...
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated

 The error is raised for an insert statement when loading the data into a table with xmltype column:

INSERT /*+ APPEND PARALLEL("ANT_LTRS_REQ_RESP_DETAILS",1)+*/ INTO RELATIONAL("TEST"."ANT_LTRS_REQ_RESP_DETAILS" NOT XMLTYPE) ("BAL_ID", "CUSTOMER_TYPE", "BAL_INSTANCE_NAME", "CUSTOMER_OWNING_ID", "LETTER_ID",
"VOL_REFERENCE_ID", "ACCOUNT_NUMBER", "LETTER_REQUEST_DATE","LETTER_RESPONSE_DATE", "LETTER_REQUEST_STATUS", "LETTER_RESPONSE_STATUS","LTRS_STATUS", "ALTMEDIA_INDICATOR", "LTRS_REQUEST_DATA", "LTRS_RESPONSE_DATA")
SELECT "BAL_ID", "CUSTOMER_TYPE", "BAL_INSTANCE_NAME","CUSTOMER_OWNING_ID", "LETTER_ID", "VOL_REFERENCE_ID", "ACCOUNT_NUMBER","LETTER_REQUEST_DATE", "LETTER_RESPONSE_DATE", "LETTER_REQUEST_STATUS",
"LETTER_RESPONSE_STATUS", "LTRS_STATUS", "ALTMEDIA_INDICATOR", SYS.XMLTYPE.CREATEXML("LTRS_REQUEST_DATA"), SYS.XMLTYPE.CREATEXML("LTRS_RESPONSE_DATA") FROM "TEST"."ET$0072646B0001" KU$;

 and the call stack trace generated for this ORA-600 [qerxtGetRefOffset_911] looks like:

... qerxtGetRefOffset qerxtAgentOpen qerxtFetch rwsfcd qerltcFetch insexe opiexe opiall0 opikpr opiodr  rpidrus  skgmstack  rpiswu2 kprball kkxspdbswitch_cbk kkxsexr kkxsexe pevm_icd_call_commo pfrinstr_ICAL ...

Using VERSION=10.2 with impdp does not helped.

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