ORA-00600: internal error code, arguments: [17281], [1001]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: ORA-600,ORA-01001,ORA-10388 during impdp


expdp.exe bkp/bkp10g dumpfile=DPBKP_LLARB:expdp_1.dmp, DATA_PUMP_DIR:expdp_2.dmp, DPBKP_LLARB:expdp_3.dmp, DATA_PUMP_DIR:expdp_4.dmp, DATA_PUMP_DIR:expdp_5.dmp logfile=dpbkp_llarb:expdp_llarb.log filesize=10G parallel=4 tablespaces=LL914ARBDATA,LL97TEMP


### Import Data Pump parameters ###
impdp  content=METADATA_ONLY DUMPFILE=impdpdir1:EXPDP_1.DMP, impdpdir1:EXPDP_3.DMP, impdpd
ir2:EXPDP_2.DMP, impdpdir3:EXPDP_4.DMP, impdpdir3:EXPDP_5.DMP LOGFILE=impdpdir1:impdp.log PARALLEL=4
TABLESPACES=LL914ARBDATA,LL97TEMP


import.log shows

Import: Release 10.2.0.4.0 - 64bit Production on Monday, 07 June, 2010 9:03:01

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BKP"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded
Starting "BKP"."SYS_IMPORT_TABLESPACE_01":  bkp/******** content=DATA_ONLY DUMPFILE=impdpdir1:EXPDP_1.DMP, impdpdir1:EXPDP_3.DMP, impdpdir2:EXPDP_2.DMP, impdpdir3:EXPDP_4.DMP, impdpdir3:EXPDP_5.DMP LOGFILE=impdpdir1:impdp_data.log PARALLEL=4 TABLESPACES=LL914ARBDATA,LL97TEMP
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "LL914ARB"."LLATTRBLOBDATA"                 9.434 GB 12569399 rows
. . imported "LL914ARB"."DTREEACL"                       6.830 GB 209164495 rows
. . imported "LL914ARB"."DAUDIT"                         2.651 GB 43994139 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 4 with process name "DW04" prematurely terminated
ORA-31672: Worker process DW04 died unexpectedly.
Job "BKP"."SYS_IMPORT_TABLESPACE_01" stopped due to fatal error at 11:42:11
ORA-39014: One or more workers have prematurely exited.


alert_llarb.log


Mon Jun  7 11:42:35 2010
Errors in file /orasys/admin/bdump/llarb_p000_15150.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x53EE97CF8], [], [], [], [], []
ORA-01001: invalid cursor
ORA-10388: parallel query server interrupt (failure)
Mon Jun  7 11:42:35 2010
Errors in file /orasys/admin/bdump/llarb_p001_15152.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x53EE97CF8], [], [], [], [], []
ORA-01001: invalid cursor
ORA-10388: parallel query server interrupt (failure)


Solution:


You had probably a temporary corruption in memory,
Import again would finish with no errors

It is tricky to identify the exact root cause,

Get Oracle Certifications for all Exams
Free Online Exams.com