Introduction:
I get to work in export and import of particular schema, but ended up with some fatal error.
While EXPDP the schema (EXPDP fails with ORA-39126 Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS) was failed with below error
Error:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-04063: view “SYS.KU$_CLUSTER_VIEW” has errors ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 105
0x14b757ad0 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x14b757ad0 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x14b757ad0 14693 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x14b757ad0 3689 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x14b757ad0 13063 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x14b757ad0 2311 package body SYS.KUPW$WORKER.MAIN
0x954a9820 2 anonymous block DBMS_METADATA.SET_FILTER
Solution:
To fix this error, we need to recompile the export utility in oracle database. Below are the steps.
For Oracle version 12c and higher:
Step: 1. To rebuild the Data Pump packages with the following steps.
Under the ORACLE_HOME, execute:
cd rdbms/admin
— Run the dpload.sql in the CDB with all of the PDBs open
From a SQL*Plus session, connect as sysdba and run dpload.sql:
Sqlplus / as sysdba
SQL>@dpload.sql
on the affected database.
Note: If Data Pump catalog is not valid in a PDB, same step should be executed to validate the DP catalog on a pluggable database.
$ sqlplus / as sysdba
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 DEV2 READ WRITE NO
SQL> alter session set container=DEV2;
SQL>@dpload.sql
Step:2 We need recompile invalid objects
SQL> @utlrp.sql
Note : EXPDP fails with ORA-39126 Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS (Doc ID 2656308.1)
Conclusion:
I hope this blog would have helped to resolve the above issue in case if you encountered the same…
Happy Debugging!!