##########################
## Error
##########################
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [AUDIT:"PUBLIC"."PUBLIC"]
ORA-01403: no data found
### Full Error
Processing object type DATABASE_EXPORT/AUDIT
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [AUDIT:"PUBLIC"."PUBLIC"]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6409
----- PL/SQL Call Stack -----
object line object
handle number name
c00000004724a490 15370 package body SYS.KUPW$WORKER
c00000004724a490 6436 package body SYS.KUPW$WORKER
c00000004724a490 12590 package body SYS.KUPW$WORKER
c00000004724a490 3397 package body SYS.KUPW$WORKER
c00000004724a490 7064 package body SYS.KUPW$WORKER
c00000004724a490 1340 package body SYS.KUPW$WORKER
c000000047235f18 2 anonymous block
Job "SYS"."db1_FULL" stopped due to fatal error at 16:16:31
##########################
# Error Occurred
##########################
Error occured while importing a database dumpfile from 11.2 version to 10.2 version.
##########################
## Command Executed
##########################
Full Database Import
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Reason for Failure
#########################################
The source database version is 11.2.0.4 and the target database version is 10.2.0.5.
While searching found that these may be because of the some internal bugs. Also we dont require the auditing information on this.
=====================================================================================================================
##########################
## Solution
##########################
As audit information is not required, i've excluded audit during import and it worked good.
$ more db1_full.par
JOB_NAME=db1_FULL
directory=MIG_DIR
dumpfile=expdp_db1_full_16Mar2016.dmp
logfile=impdp_db1_to_db1_16Mar2016.log
parallel=4
FULL=Y
exclude=audit
$
=====================================================================================================================
After excluding audit, the import worked good.
=====================================================================================================================
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
No comments:
Post a Comment