一次expdp/impdp是出现错误
- $ expdp system/***** dumpfile=<filename.dmp> nologfile=y compression=all schemas=<schema_name>
- Export: Release 11.2.0.2.0 - Production on Tue Mar 6 13:45:10 2012
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
- With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
- Data Mining and Real Application Testing options
- ORA-39006: internal error
- ORA-39065: unexpected master process exception in DISPATCH
- ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errors
- ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA_UTIL"
- ORA-39097: Data Pump job encountered unexpected error -6508
经过查询发现，数据库的两个组件invalid和一些对象失效，具体如下
- Some objects invalid cause export failure, customer need to validate these components and SYS objects.
- The following are collecting informations :
- SQL> select comp_name, status, version
- 2 from dba_registry;
- COMP_NAME STATUS VERSION
- ---------------------------------------- -------------------- ------------------------------------------------------------
- Oracle Text VALID 11.2.0.2.0
- Oracle Workspace Manager VALID 11.2.0.2.0
- Oracle Database Catalog Views INVALID 11.2.0.2.0 <<<<<<<<<<<<<<<<<<<<<<<<<<
- Oracle Database Packages and Types INVALID 11.2.0.2.0 <<<<<<<<<<<<<<<<<<<<<<<<<<
- Oracle Real Application Clusters VALID 11.2.0.2.0
- SQL> select owner, object_name, object_type, status
- 2 from dba_objects
- 3 where status <> 'VALID';
- OWNER OBJECT_NAME OBJECT_TYPE STATUS
- ------------------ -------------------------------------------------- -------------------- --------------------
- SYS ALL_XML_SCHEMAS VIEW INVALID
- SYS ALL_XML_SCHEMAS2 VIEW INVALID
- SYS KU$_XMLSCHEMA_VIEW VIEW INVALID
- SYS KU$_EXP_XMLSCHEMA_VIEW VIEW INVALID
- SYS KU$_XMLSCHEMA_ELMT_VIEW VIEW INVALID
- SYS KU$_OPQTYPE_VIEW VIEW INVALID
- SYS KU$_TABLE_XMLSCHEMA_VIEW VIEW INVALID
- SYS KU$_COLUMN_VIEW VIEW INVALID
- SYS KU$_PCOLUMN_VIEW VIEW INVALID
- SYS KU$_NT_PARENT_VIEW VIEW INVALID
- SYS KU$_FHTABLE_VIEW VIEW INVALID
- SYS KU$_10_2_FHTABLE_VIEW VIEW INVALID
- SYS KU$_10_1_FHTABLE_VIEW VIEW INVALID
- SYS KU$_PFHTABLE_VIEW VIEW INVALID
- SYS KU$_10_1_PFHTABLE_VIEW VIEW INVALID
- SYS KU$_ACPTABLE_VIEW VIEW INVALID
- SYS KU$_IOTABLE_VIEW VIEW INVALID
- SYS KU$_10_1_IOTABLE_VIEW VIEW INVALID
- SYS KU$_PIOTABLE_VIEW VIEW INVALID
- SYS KU$_10_1_PIOTABLE_VIEW VIEW INVALID
- SYS KU$_XMLSCHEMA_TYPES_VIEW VIEW INVALID
- SYS KU$_TTS_TYPES_VIEW VIEW INVALID
- SYS KU$_VIEW_VIEW VIEW INVALID
- SYS KU$_M_VIEW_FH_VIEW VIEW INVALID
- SYS KU$_M_VIEW_PFH_VIEW VIEW INVALID
- SYS KU$_M_VIEW_IOT_VIEW VIEW INVALID
- SYS KU$_M_VIEW_PIOT_VIEW VIEW INVALID
- SYS KU$_M_VIEW_LOG_FH_VIEW VIEW INVALID
- SYS KU$_M_VIEW_LOG_PFH_VIEW VIEW INVALID
- SYS KU$_CLUSTER_VIEW VIEW INVALID
- SYS DBMS_METADATA PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
- SYS DBMS_METADATA_INT PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
- SYS DBMS_METADATA_UTIL PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
处理办法如下：
please perform the following scripts during system idle time to recompile invalid objects.
- Note: before running the script, take full backup and validate the backups.
- SQL> connect / sysdba
- SQL> spool catalog.log
- SQL> @?/rdbms/admin/catalog
- SQL> spool off
- SQL> spool catproc.log
- SQL> @?/rdbms/admin/catproc
- SQL> spool off
- SQL> spool utlrp.log
- SQL> @?/rdbms/admin/utlrp
- SQL> spool off
- When you finished, perform the following SQL to check for invalid objects.
- SQL> select owner,object_name,object_type,status from dba_objects where status = 'INVALID';
本文转自 hsbxxl 51CTO博客，原文链接：http://blog.51cto.com/hsbxxl/861056，如需转载请自行联系原作者