首页 > 数据库 > Oracle > expdp 报错 ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errors

expdp 报错 ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errors

原创 Oracle 作者:pxbibm 时间:2018-06-11 17:32:35 0 删除 编辑
Export: Release - Production on Fri Jun 1 18:18:57 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user CEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1587
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.


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       Oracle Workspace Manager                 VALID       Oracle Database Catalog Views            INVALID     <<<<<<<<<<<<<<<<<<<<<<<<<< Oracle Database Packages and Types       INVALID      <<<<<<<<<<<<<<<<<<<<<<<<<< Oracle Real Application Clusters         VALID           SQL> select owner, object_name, object_type, status 2  from dba_objects 3  where status <> 'VALID';   OWNER              OBJECT_NAME                                        OBJECT_TYPE          STATUS ------------------ -------------------------------------------------- -------------------- -------------------- 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';


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

  • 博文量
  • 访问量