ORA-39126 And ORA-1403 While Importing (IMPDP) Password History (Doc ID 2062970.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Mar-2017***

Symptoms

Exporting a 12c database with version=11.2.0.4 and importing it into 11gR2 is failing when loading the password history due to:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PASSWORD_HISTORY:"ABAKHMUTSKY"]
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----
  object line object
  handle number name
0xe9ef3e72c0 27116 package body SYS.KUPW$WORKER
0xe9ef3e72c0 11286 package body SYS.KUPW$WORKER
0xe9ef3e72c0 21860 package body SYS.KUPW$WORKER
0xe9ef3e72c0 4516 package body SYS.KUPW$WORKER
0xe9ef3e72c0 5533 package body SYS.KUPW$WORKER
0xe9ef3e72c0 12119 package body SYS.KUPW$WORKER
0xe9ef3e72c0 2081 package body SYS.KUPW$WORKER
0xea74a77a30 2 anonymous block

l_valid: -3 - Not Loading OID with type TYPE
l_valid: -3 - Not Loading OID with type INC_TYPE
l_valid: -3 - Not Loading REVOKE_FROM with type ROLE
l_valid: -3 - Not Loading DBA with type JOB
l_valid : 1 - Loading SOURCE_VERSION with type NULL
Job "ABAKHMUTSKY"."SYS_SQL_FILE_FULL_03" stopped due to fatal error at Fri Jun 5 10:00:48 2015 elapsed 0 00:00:02

ERROR
-----------------------
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PASSWORD_HISTORY:"ABAKHMUTSKY"]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259




Changes

 none

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