My Oracle Support Banner

Datapump Import Worker Process Fails with ORA-00448 ORA-01403 (Doc ID 1550769.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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/<PASSWORD> TRACE=480300 METRICS=Y parfile=<FILE_NAME>.par logfile=<FILE_NAME>.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"."<TABLE_NAME1>"                                 114.2 GB 318742408 rows
. . imported "SCOTT"."<TABLE_NAME2>"                                 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_BASE>/diag/rdbms/<sid>/<dbname>/<FILE_NAME>.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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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