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!!

Recent Posts

Start typing and press Enter to search