环境 AIX 5.2+oracle 9.2.0.5 单机
昨天对客户数据库做exp导出时,报以下错误:
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “SYS.LT_EXPORT_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp

通过查询metalink,建议以下方式解决:

[table=98%]
[td=4,1]Export Is Giving Errors Exp-00008 ORA-4068 ORA-4063 on SYS.LT_EXPORT_PKG [ID 298107.1][td=2,1]
[td=6,1]
[td=2,1,25%] [td=3,1,50%][i]修改时间 14-MAY-2009 [i]类型 PROBLEM [i]状态 PUBLISHED

In this Document
[size=-1] Symptoms
Cause
Solution
References

Applies to: Oracle Server – Enterprise Edition – Version: 9.2.0.5
This problem can occur on any platform.
“Checked for relevance on 14-May-2009”
SymptomsExport of 9.2.0.6 database fails with following errors:

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “SYS.LT_EXPORT_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.system_i

Verified the issue by the log file fullexp050206.log

CauseWORKSPACE , XDB schemas have invalid objects.

SolutionRun $ORACLE_HOME/rdbms/admin/owminst.plb as SYS to allow the LT_EXPORT_PKG to be validated.