[Oracle]expdp导出报错ORA-39014 ORA-39029 ORA-04063 ORA-06508

1、使用expdp导出命令

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "ZEVEN"."SYS_EXPORT_SCHEMA_01":  zeven/********
dumpfile=zeven.dmpdirectory=exp_data_dir cluster=n 
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04063: package body "SYS.KUPW$WORKER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPW$WORKER"
ORA-06512: at line 2
Job "ZEVEN"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Tue Sep 3 14:29:49 2019 elapsed 0 00:00:30

2、查看SYS.KUPW$WORKE包的状态

15:19:08 SYS@ oibs11> select owner,object_name,object_type,status from dba_objects where status <> 'VALID' order by object_name;

OWNER							     OBJECT_NAME													            OBJECT_TYPE			     STATUS
------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------- --------------
.....
SYS							     KUPW$WORKER													            PACKAGE BODY			     INVALID
......
10 rows selected.

3、根据mos提示执行下面脚本

15:15:33 SYS@ oibs11> @?/rdbms/admin/prvtbpw.plb;
Warning: Package Body created with compilation errors.
Elapsed: 00:00:00.72
15:16:05 SYS@ oibs11> show errors;
Errors for PACKAGE BODY KUPW$WORKER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
22308/5  PL/SQL: SQL Statement ignored
22308/34 PL/SQL: ORA-00942: table or view does not exist

提示报错，表或者视图不存在，执行下面两个脚本

@?/rdbms/admin/catdpb.sql
@?/rdbms/admin/utlrp.sql

执行正常，再次查看包的状态,包恢复正常

15:35:14 SYS@ boston> select owner,object_name,object_type,status from dba_objects where status = 'VALID' and object_name = 'KUPW$WORKER';

OWNER			       OBJECT_NAME															OBJECT_TYPE	    STATUS
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------- -------
SYS			       KUPW$WORKER															PACKAGE 	    VALID
SYS			       KUPW$WORKER															PACKAGE BODY	    VALID

4、再次执行导出服务，恢复正常

[oracle@dax-mysql-slave tmp]$ expdp te/te12345678  dumpfile=zeven.dmp directory=exp_data_dir cluster=n logfile=expdp_zeven.log
Export: Release 11.2.0.4.0 - Production on Tue Sep 3 15:10:46 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "TE"."SYS_EXPORT_SCHEMA_01":  te/******** dumpfile=zeven.dmp directory=exp_data_dir cluster=n logfile=expdp_zeven.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
. . exported "TE"."TEST1"                                    0 KB       0 rows
Master table "TE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TE.SYS_EXPORT_SCHEMA_01 is:
  /tmp/backup/zeven.dmp
Job "TE"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Sep 3 15:11:06 2019 elapsed 0 00:00:19