Oracle expdp 报错: ORA-39125 ORA-4063 on View SYS.KU$_CLUSTER_VIEW 解决方法
来源:互联网 发布:当女程序员遇到问题时 编辑:程序博客网 时间:2024/06/11 17:29
用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
- Oracle expdp 报错: ORA-39125 ORA-4063 on View SYS.KU$_CLUSTER_VIEW 解决方法
- Oracle 报错:ORA-00313、ORA-00312、ORA-27047 解决方法
- oracle11g expdp报错 ORA-06512: at "SYS.UTL_FILE", line 536
- oracle11g expdp报错 ORA-06512: at "SYS.UTL_FILE", line 536
- ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP报错问题处理
- expdp 导出报错 ORA-39006: ORA-39065: ORA-04063: ORA-06508: ORA-39097: ORA-01403: ORA-39097:
- expdp报错:ora-39127“WMSYS”
- expdp导出报错ORA-39002、ORA-39070解决办法
- expdp导出报错ORA-31693&ORA-39826
- expdp query导出报错 ORA-29913 ORA-01722
- expdp导出报错ORA-39002、ORA-39070解决办法
- ORACLE11G RAC expdp报错ORA-39002 ORA-39070 ORA-29283 ORA-06512
- ORACLE 11gR2 导入AWR 报错 ORA-20115 ORA-39126 ORA-25153 解决方法
- ORACLE 报错ORA-00439、ORA-01078、LRM-00109、ORA-38760的解决方法
- Oracle expdp 时遭遇ORA-39125 ORA-04063
- ORA-09817,ORA-01075报错解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- poj2485
- 什么是倒排索引?
- js简单计算器
- DNN翻译:添加、管理页面
- Java并发学习笔记(1) 线程与进程
- Oracle expdp 报错: ORA-39125 ORA-4063 on View SYS.KU$_CLUSTER_VIEW 解决方法
- 关于重装MySql出错解决方法
- google分页效果
- mysql 删除分区表
- BitmapFactory.decodeFile
- 自写计算器
- position-fixed在jsp里面不支持的解决。。。
- 开发一个在Razor mvc下的插件(model/view)
- Java并发学习笔记(2)在java中实现多线程的启动