Expdp encountered a ORA-39126 Error

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.