Oracle expdp 报错: ORA39125 ORA4063 on View SYS.KU$_CLUSTER

Oracle expdp 报错: ORA39125 ORA4063 on View SYS.KU$_CLUSTER_VIEW 解决方法

用expdp 导出数据库，报错，意外中断：

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB[PROCACT_SCHEMA:"GGS"]

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

c00000014c508d08 14916 package body SYS.KUPW$WORKER

c00000014c508d08 6293 package body SYS.KUPW$WORKER

c00000014c508d08 2339 package body SYS.KUPW$WORKER

c00000014c508d08 6854 package body SYS.KUPW$WORKER

c00000014c508d08 1259 package body SYS.KUPnW$WORKER

c000000211983d20 2 anonymous block

Job"SYS"."SYS_EXPORT_FULL_05" stopped due to fatal error at09:09:55

In this case theproblem is generated because the view SYS.KU$_CLUSTER_VIEW is invalid, inaddition to that the following components are invalids according with theoutput of dba_registry.

--导致这个现象的原因是因为SYS.KU$_CLUSTER_VIEW视图无效。

同时也可能存在一些组件的无效，可以使用如下SQL 查询：

col comp_id for a12;
col comp_name for a30;
col version for a12;
select comp_id, comp_name, version, status from dba_registry;

OWM Oracle WorkspaceManager              10.2.0.4.3 VALID
ORDIM OracleinterMedia                   10.2.0.4.0 INVALID
CATALOG Oracle Database Catalog Views      10.2.0.4.0INVALID
CATPROC Oracle Database Packages and Types 10.2.0.4.0 INVALID

解决方法：

cd $ORACLE_HOME/rdbms/admin
SQL> startup restrict
SQL> select count(*) from dba_objects where status='INVALID';
SQL> @catalog
SQL> @catproc
SQL> @utlrp <== To compile the invalid objects
SQL> select count(*) from dba_objects where status='INVALID';
col comp_id for a12
col comp_name for a30
col version for a12
select comp_id, comp_name, version, status from dba_registry;
SQL> shutdown immediate
SQL> startup

通过执行catalog.sql 脚本刷新视图，CATALOG.SQL 文件包含这些视图的定义以及公用同义词，运行CATALOG.SQL 可以创建这些视图及同义词。来解决视图失效的问题。

执行完毕验证无效对象和组件，如果正常就可以继续expdp了。

Oracle expdp 报错: ORA39125 ORA4063 on View SYS.KU$_CLUSTER_VIEW 解决方法

解决方法：

相关的链接：