WMSYS & EXP

从9207export一个用户的所有对象时报错.
===========================================
F:\>%oracle_home%\bin\exp userid=system owner=MRPC_TL_USER buffer=81920 file=F:\
expfile\MRPC_TL_USER.dmp log=F:\expfile\MRPC_TL_USER.log

Export: Release 9.2.0.7.0 - Production on Thu Feb 5 10:37:36 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
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_i
nfo_exp
. exporting foreign function library names for user MRPC_TL_USER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MRPC_TL_USER
About to export MRPC_TL_USER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MRPC_TL_USER's tables via Conventional Path ...
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
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_i
nfo_exp
. exporting statistics
Export terminated successfully with warnings.
==========================================
从log中是在运行到SYS.LT_EXPORT_PKG出错了,手动编译了系统的所有无效对EXP仍报相的的ERROR.
检查发现LT_EXPORT_PKG是属于WMSYS的一个对象.查询DBA_USERS并不存在WMSYS,手动运行
$ORACLE_HOME/rdbms/admin/owmctab.plb
从新创建WMSYS用户,至此问题解决.
另外,从DBA_REGISTRY中看到这系统估计是安装还是升级中出现过错误并且忽略了,有些组件还是无
效的.还好这个库压力不大,不然要出事故了.
SQL> select comp_id,version,status from dba_registry;

COMP_ID                        VERSION                        STATUS
------------------------------ ------------------------------ -----------
CATALOG                        9.2.0.7.0                      VALID
CATPROC                        9.2.0.7.0                      INVALID
JAVAVM                         9.2.0.7.0                      VALID
XML                            9.2.0.9.0                      VALID
CATJAVA                        9.2.0.7.0                      VALID
ORDIM                          9.2.0.7.0                      VALID
CONTEXT                        9.2.0.7.0                      VALID
APS                            9.2.0.7.0                      UPGRADED
XOQ                            9.2.0.7.0                      UPGRADED

9 rows selected.

SQL>