点击(此处)折叠或打开
- C:\\Documents and Settings\\Administrator>expdp \'/ as sysdba\' directory=dump_dir
- full=y dumpfile=fullexp.dmp logfile=fullexp.log parallel=2
-
- Export: Release 10.2.0.1.0 - Production on 星期一, 22 12月, 2014 10:08:15
-
- Copyright (c) 2003, 2005, Oracle. All rights reserved.
-
- 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
- With the Partitioning, OLAP and Data Mining options
- 启动 \"SYS\".\"SYS_EXPORT_FULL_01\": \'/******** AS SYSDBA\' directory=dump_dir full=
- y dumpfile=fullexp.dmp logfile=fullexp.log parallel=2
- 正在使用 BLOCKS 方法进行估计...
- 处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
- 使用 BLOCKS 方法的总估计: 1.128 GB
- 处理对象类型 DATABASE_EXPORT/TABLESPACE
- . . 导出了 \"UNILAB\".\"C_INSPECTIONPLAN_ITEM\" 229.3 MB 753169 行
- 处理对象类型 DATABASE_EXPORT/SYS_USER/USER
- 处理对象类型 DATABASE_EXPORT/SCHEMA/USER
- 处理对象类型 DATABASE_EXPORT/ROLE
- 处理对象类型 DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
- 处理对象类型 DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
- 处理对象类型 DATABASE_EXPORT/SCHEMA/ROLE_GRANT
- 处理对象类型 DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
- 处理对象类型 DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
- 处理对象类型 DATABASE_EXPORT/RESOURCE_COST
- 处理对象类型 DATABASE_EXPORT/SCHEMA/DB_LINK
- 处理对象类型 DATABASE_EXPORT/TRUSTED_DB_LINK
- 处理对象类型 DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
- 处理对象类型 DATABASE_EXPORT/DIRECTORY/DIRECTORY
- 处理对象类型 DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
- 处理对象类型 DATABASE_EXPORT/CONTEXT
- 处理对象类型 DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
- 处理对象类型 DATABASE_EXPORT/SCHEMA/SYNONYM
- 处理对象类型 DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
- 处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
-
- 处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
- 处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GRANT
- 处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTE
- M
- 处理对象类型 DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
- ORA-39125: 在 KUPW$WORKER.UNLOAD_METADATA 中 Worker 发生意外的致命错误 (在调用 D
- BMS_METADATA.FETCH_XML_CLOB [PROCACT_SCHEMA:\"ANONYMOUS\"] 时)
- ORA-04063: view \"SYS.KU$_CLUSTER_VIEW\" 有错误
-
- ORA-06512: 在 \"SYS.DBMS_SYS_ERROR\", line 105
- ORA-06512: 在 \"SYS.KUPW$WORKER\", line 6241
-
- ----- PL/SQL Call Stack -----
- object line object
- handle number name
- 63DA6AE8 14916 package body SYS.KUPW$WORKER
- 63DA6AE8 6300 package body SYS.KUPW$WORKER
- 63DA6AE8 2340 package body SYS.KUPW$WORKER
- 63DA6AE8 6861 package body SYS.KUPW$WORKER
- 63DA6AE8 1262 package body SYS.KUPW$WORKER
- 63E4B674 2 anonymous block
-
- 作业 \"SYS\".\"SYS_EXPORT_FULL_01\" 因致命错误于 10:09:04 停止
-
-
- C:\\Documents and Settings\\Administrator>
-
导致这个现象的原因是因为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 D:\\oracle\\product\\10.2.0\\db_1\\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> select comp_id, comp_name, version, status from dba_registry;
-
- COMP_ID COMP_NAME VERSION STATUS
- ------------ ------------------------------ ------------ -----------
- CATALOG Oracle Database Catalog Views 10.2.0.1.0 VALID
- CATPROC Oracle Database Packages and T 10.2.0.1.0 VALID
- ypes
-
- JAVAVM JServer JAVA Virtual Machine 10.2.0.1.0 VALID
-
- 已选择3行。
-
- SQL> shutdown immediate
- SQL> startup
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30060321/viewspace-1376022/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30060321/viewspace-1376022/