Oracle打完补丁出现无效组件,oracle 手动升级后组件状态为INVALID解决办法

After upgrade CATPROC and CATALOG comps are

INVALID

报错信息：

oracle 10.2.0.1升级到10.2.0.5

运行catupgrd.sql后

racle Database 10.2 Upgrade Status Utility

racle Database 10.2 Upgrade Status Utility           03-16-2011 09:39:53

.

Component                                              Status         Version  HH:MM:SS

Oracle Database Server                          VALID      10.2.0.5.0  00:07:47

JServer JAVA Virtual Machine                 VALID      10.2.0.5.0  00:02:19

Oracle XDK                                                 VALID      10.2.0.5.0  00:00:40

Oracle Database Java Packages         INVALID      10.2.0.5.0  00:00:54

Oracle Text                                                  VALID      10.2.0.5.0  00:00:33

Oracle XML Database                               VALID      10.2.0.5.0  00:01:35

Oracle Real Application Clusters           VALID      10.2.0.5.0  00:00:02

Oracle Workspace Manager                    VALID      10.2.0.5.0  00:00:04

Oracle

Data Mining                                    VALID      10.2.0.5.0  00:00:33

OLAP Analytic Workspace                        VALID      10.2.0.5.0  00:00:19

OLAP Catalog                                             VALID      10.2.0.5.0  00:00:56

Oracle OLAP API                                        VALID      10.2.0.5.0  00:01:45

Oracle interMedia                                      VALID      10.2.0.5.0  00:05:34

Oracle Expression Filter                           VALID      10.2.0.5.0  00:00:54

Spatial                                                          VALID      10.2.0.5.0  00:00:41

Oracle Rule Manager                                VALID      10.2.0.5.0  00:00:05

Oracle Enterprise Manager                      VALID      10.2.0.5.0  00:00:07

查了下metalink文档，有人碰到个这个，原来是FIXED_DATE这个参数设置不正确引起的，将FIXED_DATE设置为none,再次执行

升级脚本就可以了，oracle给出具体步骤为：

1.使用以下脚本验证那些无效对象对

数据库组件状态有影响

spool /oracle/admin/obj_list.out

set serverout