DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-600 [15212] (Doc ID 1309638.1)

Last updated on JUNE 03, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jun-2013***

Symptoms

1. The DataPump import fails with the following errors:

impdp test/test directory=exp_dir DUMPFILE=test.dmp table_exists_action=replace LOGFILE=import_dump.log

 

;;
Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 29 March, 2011 16:58:26
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 "TEST"."SYS_IMPORT_FULL_03" successfully loaded/unloaded
Starting "TEST"."SYS_IMPORT_FULL_03": test/******** directory=exp_dir DUMPFILE=test.dmp table_exists_action=replace LOGFILE=import_dump.log

Processing object type SCHEMA_EXPORT/USE

ORA-39097: Data Pump job encountered unexpected error -600
ORA-39065: unexpected master process exception in MAIN
ORA-00600: internal error code, arguments: [15212], [0x1105FD488], [0], [0x70000020D63EB50], [0x7000001FEC74708], [0x000000000], [], []

Job "TEST"."SYS_IMPORT_FULL_03" stopped due to fatal error at 17:04:20


2.  The following errors are reported in the alert log and can generate a trace file

Errors in file /u01/oracle/admin/NYDWQA/bdump/nydwqa_dm00_1564872.trc:
ORA-00600: internal error code, arguments: [15212], [0x1105C3A60], [0], [0x70000020E87E340], [0x7000001FCF7BAC0], [0x000000000], [], []


3.  There may be a current SQL reported in the trace file:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15212], [0x1105C3A60], [0], [0x70000020E87E340], [0x7000001FCF7BAC0], [0x000000000], [], []
Current SQL statement for this session:
SELECT error_msg FROM USER_RESUMABLE WHERE name LIKE :1 AND error_msg IS NOT NULL AND ROWNUM = 1
----- PL/SQL Call Stack -----
object line object
handle number name
70000020d4d53e8 790 package body SYS.KUPM$MCP
7000001faea0e08 2 anonymous block

O/S info: user: oracle, term: UNKNOWN, application name: Data Pump Master, hash value=674186793
action name: SYS_IMPORT_FULL_03, hash value=4050146548


4. The call stack contains the functions:

ksedst <- ksedmp <- ksfdmp <- kgeriv <- kgesiv <- ksesic5 <- kksfbc <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexecv8 <- kpuexec <- OCIStmtExecute <- kupprdp <- opirip <- opidrv <- sou2o <- opimai_real <- main <- start

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