exp导出报错,请求老刘指点

刷到报废

老刘,
你好,我遇到个难题,能力有限,搞不定了.
********************************************************************************
①,环境是solaris的HA环境,DB为oracle 9i.

23:25:08 SQL> select * from v$version;
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE    9.2.0.1.0       Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
********************************************************************************
②,我做了几次exp的全库导出.
尝试了SYS和SYSTEM,报错是一样的.
exp system/manager@TEST file='/CINMS.dmp' log='CINMS.log' full=y
********************************************************************************
③,报错信息如下
. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063:  has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 87
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 138
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
********************************************************************************
④,查看这个包/体的状态如下
  1* select owner,object_name,object_type,status from dba_objects where object_name = 'DBMS_AQADM_SYS'
OWNER      OBJECT_NAME          OBJECT_TYPE                          STATUS
---------- -------------------- ------------------------------------ --------------
SYS        DBMS_AQADM_SYS       PACKAGE                              VALID
SYS        DBMS_AQADM_SYS       PACKAGE BODY                         INVALID
********************************************************************************
⑤,尝试重建这个包体的时候报错如下
23:30:57 SQL> ALTER PACKAGE DBMS_AQADM_SYS COMPILE BODY;
Warning: Package Body altered with compilation errors.
********************************************************************************
⑥然后,重点来了,我想看看这个库里面有多少失效对象
select owner,object_name,object_type,status from dba_objects where status ='INVALID';
发现有68个失效对象,有存储过程,JAVA CLASS,触发器,包,包体等等.
来自业务用户和SYS用户的.
之前我按照lunar说的@utlrp.sql了,但是这68个是无法编译的,期间还有个ORA-600报错,我看了下trace,
能力有限,我只看懂了一句话...

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [26599], [1], [148], [], [], [], [], []
Current SQL statement for this session:
ALTER JAVA CLASS "CINMSDT"."GB2Alpha" COMPILE

********************************************************************************

Trace文件有5M多,我上传附件失败了.如果需要的话,再上传可以不.

剩下的就是老刘帮忙分析了,希望老刘言无不尽....

Maclean Liu(刘相兵

世界上有一种技术叫压缩

用9.2.0.1 是不幸的

ShineCQY

刘大的意思是 加上参数 compress = N ？

Stone

如果单从故障分析的角度看可以参考下这篇文章：
“http://space.itpub.net/9252210/viewspace-695102” ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors

另外Oracle有篇文档可以参考下：
Data Pump Job Fails With ORA-31626 ORA-31637 ORA-39080 ORA-04063 And ORA-06508 [ID 563701.1]

还有 :)
http://www.dbasupport.com/forums/showthread.php?32884-URGENT-!-Exp-ORACLE-error-4068-encountered-in-oracle-9i

Good luck

iimax

刘大的意思是把附件压缩上传吧  不看日志怎么分析