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

Last updated on MAY 08, 2013

Applies to:

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

Symptoms

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

Import: Release 11.2.0.3.0 - 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 11.2.0.3.0 - 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
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
    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

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