My Oracle Support Banner

Datapump import worker process fails with ORA-00448 ORA-01403 (Doc ID 1550769.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


While running Datapump import, the job fails with a fatal error in the import.log:

Import: Release - Production on Mon Apr 29 11:07:19 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."IMPDP_8_042913_1" successfully loaded/unloaded
Starting "SYSTEM"."IMPDP_8_042913_1":  system/******** TRACE=480300 METRICS=Y parfile=/oracle10/u01/data_pump_dir/refresh_stage_no_blob.par logfile=impdp.log
Processing object type DATABASE_EXPORT/SCHEMA/USER
    Completed 1 USER objects in 0 seconds
    Completed 17 SYSTEM_GRANT objects in 0 seconds

. . imported "SCOTT"."XXXXXXXXXX"                                 114.2 GB 318742408 rows
. . imported "SCOTT"."ZZZZZZZZZZ"                                 329.7 MB 9481582 rows
Job "SYSTEM"."IMPDP_8_042913_1" stopped due to fatal error at 21:39:29                        <<< HERE >>>

The alert.log shows the following errors reported by the datapump worker process(es):

Errors in file /oracle/product/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_dw0a_637.trc:
ORA-00448: normal completion of background process
ORA-01403: no data found

The trace file for the worker process shows many waits for 'XDB SGA initialization' until the worker processes start to report errors and the job terminates:

*** 2013-04-29 21:25:19.059
WAIT #18446744071443121504: nam='XDB SGA initialization' ela= 5000033 p1=0 p2=0 p3=0 obj#=-1 tim=5877132519796

*** 2013-04-29 21:25:21.169
WAIT #18446744071443121504: nam='XDB SGA initialization' ela= 2108890 p1=0 p2=0 p3=0 obj#=-1 tim=5877134628931

*** 2013-04-29 21:25:21.169
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
ORA-00448: normal completion of background process
ORA-01403: no data found


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.