Oracle expdp 報錯: ORA-39125 ORA-4063 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了。

 

 

相關的連結：

ORA-39125 ORA-4063 on ViewSYS.KU$_CLUSTER_VIEW When Doing a DataPump Export [ID 742018.1]

 

exp/imp 與expdp/impdp 對比 及使用中的一些最佳化事項

http://blog.csdn.net/tianlesoftware/article/details/6093973

 

Oracleexpdp/impdp 使用樣本

http://blog.csdn.net/tianlesoftware/article/details/6260138

 

Oracle 10gData Pump Expdp/Impdp 詳解

http://blog.csdn.net/tianlesoftware/article/details/4674224

 

Oracle 動態效能檢視

http://blog.csdn.net/tianlesoftware/article/details/5863191

 

OracleCompile 編譯 無效對象

http://blog.csdn.net/tianlesoftware/article/details/4843600

Oracle8i/9i/10g/11g 組件（Components） 說明

http://blog.csdn.net/tianlesoftware/article/details/5937382

 

 

 

 

-------------------------------------------------------------------------------------------------------

著作權，文章允許轉載，但必須以連結方式註明源地址，否則追究法律責任!

Skype:            tianlesoftware

Email:             tianlesoftware@gmail.com

Blog:   http://www.tianlesoftware.com

Weibo:            http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

 

 

-------加群需要在備忘說明Oracle資料表空間和資料檔案的關係，否則拒絕申請----

DBA1 群：62697716(滿);   DBA2 群：62697977(滿)  DBA3 群：62697850(滿)  

DBA 超級群：63306533(滿);  DBA4 群：83829929   DBA5群： 142216823

DBA6 群：158654907    DBA7 群：172855474   DBA總群：104207940