环境 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,建议以下方式解决:

Export Is Giving Errors Exp-00008 ORA-4068 ORA-4063 on SYS.LT_EXPORT_PKG [ID 298107.1]

		修改时间 14-MAY-2009 类型 PROBLEM 状态 PUBLISHED

In this Document
  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"

Symptoms

Export 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

Cause

WORKSPACE , XDB schemas have invalid objects.

Solution

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