Oracle expdp时遭遇ORA-39125 ORA-04063解决

数据库在使用DataPump导出时碰到了ORA-39125与ORA-04063。完整的ORA-39125提示是Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [OBJECT_GRANT:"GX_ADMIN"]，在使用包DBMS_METADATA.FETCH_XML_CLOB时碰到错误。下面是对这个错误的解决过程。

1、产生ORA-39125与ORA-04063

oracle@linux-ejad:~> export ORACLE_SID=SZ4701

oracle@linux-ejad:~> expdp \'\/ as sysdba \' directory=db_dump_dir dumpfile=sz4701.dmp logfile=exp_4701.log schemas=gx_admin

Export: Release 10.2.0.3.0 - 64bit Production on Tuesday, 05 November, 2013 13:49:23

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production

Starting "SYS"."SYS_EXPORT_SCHEMA_01": '/******** AS SYSDBA' directory=db_dump_dir dumpfile=sz4701.dmp logfile=exp_4701.log

schemas=gx_admin

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 447.8 MB

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/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB

[OBJECT_GRANT:"GX_ADMIN"]

ORA-04063: view "SYS.KU$_CLUSTER_VIEW" has errors

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 6234

----- PL/SQL Call Stack -----

object line object

handle number name

0x7605bab0 14916 package body SYS.KUPW$WORKER

0x7605bab0 6293 package body SYS.KUPW$WORKER

0x7605bab0 2339 package body SYS.KUPW$WORKER

0x7605bab0 6854 package body SYS.KUPW$WORKER

0x7605bab0 1259 package body SYS.KUPW$WORKER

0x835e2470 2 anonymous block

Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 13:49:37

2、分析错误

oracle@linux-ejad:~> oerr ora 39125

39125, 00000, "Worker unexpected fatal error in %s while calling %s [%s]"

// *Cause: An unhandled exception was detected internally within the worker

// process for the Data Pump job while calling the specified external

// routine. This is an internal error. Additional information may be

// supplied.

// *Action: If problem persists, contact Oracle Customer Support.

--第一个ORA告诉我们是一个内部错误，联系Oracle Support

oracle@linux-ejad:~> oerr ora 04063

04063, 00000, "%s has errors"

// *Cause: Attempt to execute a stored procedure or use a view that has

// errors. For stored procedures, the problem could be syntax errors

// or references to other, non-existent procedures. For views,

// the problem could be a reference in the view's defining query to