Expdp encountered a ORA-39126 Error
Problem description:
The Oracle database is RAC of 11.2.0.4 and expdp is performed on one of the nodes. the following error is returned:
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW $ WORKER. FETCH_XML_OBJECTS []
The ORA-00904: invalid identifier
ORA-06512: at "SYS. DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS. KUPW $ WORKER", line 9710
----- PL/SQL Call Stack -----
Object line object
Handle number name
0x0000ec64fb0 21979 package body SYS. KUPW $ WORKER
0x0000ec64fb0 9742 package body SYS. KUPW $ WORKER
0x0000ec64fb0 11838 package body SYS. KUPW $ WORKER
0x0000ec64fb0 14674 package body SYS. KUPW $ WORKER
0x0000ec64fb0 2734 package body SYS. KUPW $ WORKER
0x0000ec64fb0 10422 package body SYS. KUPW $ WORKER
0x0000ec64fb0 1824 package body SYS. KUPW $ WORKER
0x10373876f8 2 anonymous block
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW $ WORKER. FETCH_XML_OBJECTS []
The ORA-00904: invalid identifier
ORA-06512: at "SYS. DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS. KUPW $ WORKER", line 9710
----- PL/SQL Call Stack -----
Object line object
Handle number name
0x0000ec64fb0 21979 package body SYS. KUPW $ WORKER
0x0000ec64fb0 9742 package body SYS. KUPW $ WORKER
0x0000ec64fb0 11838 package body SYS. KUPW $ WORKER
0x0000ec64fb0 14674 package body SYS. KUPW $ WORKER
0x0000ec64fb0 2734 package body SYS. KUPW $ WORKER
0x0000ec64fb0 10422 package body SYS. KUPW $ WORKER
0x0000ec64fb0 1824 package body SYS. KUPW $ WORKER
0x10373876f8 2 anonymous block
Solution:
Grant execute on DBMS_METADATA to public;
If you export data again after execution, no error is returned.
---------------------------- Lili split line ----------------------------
Oracle Import and Export expdp IMPDP details
Solution to Oracle 10g expdp export error ORA-4031
Oracle 10gr2 rac expdp error UDE-00008 ORA-31626
Use of expdp/impdp to back up databases in Oracle
Oracle backup recovery (expdp/impdp)