19c pdb导出报错 ORA-39126: KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist

19c pdb导出报错

[oracle@rac19c1 ~]$ expdp system/oracle@pdb11g dumpfile=exp.dmp cluster=n directory=exp full=y;

Export: Release 19.0.0.0.0 - Production on Fri Jun 5 22:57:39 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_06":  system/********@pdb11g dumpfile=exp.dmp cluster=n directory=exp full=y 
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12620
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 9571
ORA-06512: at "SYS.DBMS_METADATA", line 2976
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5327
ORA-06512: at "SYS.DBMS_METADATA", line 9552
ORA-06512: at "SYS.KUPW$WORKER", line 15109

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x6d44fa38     33476  package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x6d44fa38     12641  package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x6d44fa38     15442  package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x6d44fa38      3907  package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x6d44fa38     13736  package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x6d44fa38      2429  package body SYS.KUPW$WORKER.MAIN
0x6d2f3b58         2  anonymous block

DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
KUPW: In FETCH_XML_OBJECTS
KUPW: End seqno is: 24
KUPF$FILE.OPEN_CONTEXT
KUPF$FILE.OPEN_CONTEXT
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_METADATA", line 9571
ORA-06512: at "SYS.DBMS_METADATA", line 2976
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5327
ORA-06512: at "SYS.DBMS_METADATA", line 9552

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12620
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 9571
ORA-06512: at "SYS.DBMS_METADATA", line 2976
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5327
ORA-06512: at "SYS.DBMS_METADATA", line 9552
ORA-06512: at "SYS.KUPW$WORKER", line 15109

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x6d44fa38     33476  package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x6d44fa38     12641  package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x6d44fa38     15442  package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x6d44fa38      3907  package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x6d44fa38     13736  package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x6d44fa38      2429  package body SYS.KUPW$WORKER.MAIN
0x6d2f3b58         2  anonymous block

DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
KUPW: In FETCH_XML_OBJECTS
KUPW: End seqno is: 24
KUPF$FILE.OPEN_CONTEXT
KUPF$FILE.OPEN_CONTEXT
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_METADATA", line 9571
ORA-06512: at "SYS.DBMS_METADATA", line 2976
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5327
ORA-06512: at "SYS.DBMS_METADATA", line 9552

Job "SYSTEM"."SYS_EXPORT_FULL_06" stopped due to fatal error at Fri Jun 5 22:58:39 2020 elapsed 0 00:00:55
 

查看MOS，原因为datapump损坏需要重建

12c开始执行dpload.sql重建data pump

启动所有pdb
SQL>  alter pluggable database all open instances=all;

Pluggable database altered.

执行dpload.sql

SQL>  @$ORACLE_HOME/rdbms/admin/dpload.sql

。。。
Package dropped.

dpload done

PL/SQL procedure successfully completed.

重建完成后执行导出成功。

参考文档：

EXPDP fails with ORA-39126 Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS (Doc ID 2656308.1)

How To Reload Datapump Utility EXPDP/IMPDP (Doc ID 430221.1)

附：重建datapump

     10.1

SQL> @$ORACLE_HOME/rdbms/admin/catdp.sql

SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql

    10.2

SQL> @$ORACLE_HOME/rdbms/admin/catdph.sql

SQL> @$ORACLE_HOME/rdbms/admin/prvtdtde.plb

SQL> @$ORACLE_HOME/rdbms/admin/catdpb.sql

SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

    11g

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

    12c及以后

开启所有pdb

SQL> @$ORACLE_HOME/rdbms/admin/dpload.sql