ORA-39126 And ORA-1403 While Importing (IMPDP) Password History
(Doc ID 2062970.1)
Last updated on NOVEMBER 04, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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:"<NAME>"]
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 "<SCHEMA_NAME>"."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:"<NAME>"]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
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 "<SCHEMA_NAME>"."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:"<NAME>"]
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
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 |