10.2.0.4upgrade

近日一套新系统即将上线,把开发环境的数据库和生产环境弄成同步,于是今天早上来打补丁(开发是10.2.0.1,生产是10.2.0.4),打补丁过程很正常,完成后却遇到点新问题,查阅资料得知原因如下,开发环境是先建了数据库实例再打的补丁,而生产环境是安装了数据库就打的补丁,然后再建的实例,于是区别就在这个顺序上,启动开发数据库总是只能到mount,不能到OPEN,只能startup upgrade才能OPEN,原因是有个自带的脚本要执行,/oracle/product/10.2.0.1/rdbms/admin/catupgrd.sql ,执行该脚本用时00:21:05,执行后一切正常，如果可以的话，执行一下这个脚本utlrp.sql。



alert_md.log:ORA-01092 signalled during: ALTER DATABASE OPEN...


cd /oracle/product/10.2.0.1/rdbms/admin

SQL> @catupgrd.sql


SQL> @utlu102s.sql
.
Oracle Database 10.2 Upgrade Status Utility           04-08-2009 10:48:22
.
Component                                Status         Version  HH:MM:SS
Oracle Database Server                    VALID      10.2.0.4.0  00:07:24
JServer JAVA Virtual Machine              VALID      10.2.0.4.0  00:02:18
Oracle XDK                                VALID      10.2.0.4.0  00:00:25
Oracle Database Java Packages             VALID      10.2.0.4.0  00:00:11
Oracle Text                               VALID      10.2.0.4.0  00:00:16
Oracle XML Database                       VALID      10.2.0.4.0  00:01:24
Oracle Workspace Manager                  VALID      10.2.0.4.3  00:00:42
Oracle Data Mining                        VALID      10.2.0.4.0  00:00:18
OLAP Analytic Workspace                   VALID      10.2.0.4.0  00:01:06
OLAP Catalog                              VALID      10.2.0.4.0  00:00:46
Oracle OLAP API                           VALID      10.2.0.4.0  00:00:31
Oracle interMedia                         VALID      10.2.0.4.0  00:02:23
Spatial                                   VALID      10.2.0.4.0  00:01:17
Oracle Expression Filter                  VALID      10.2.0.4.0  00:00:06
Oracle Enterprise Manager                 VALID      10.2.0.4.0  00:01:44
Oracle Rule Manager                       VALID      10.2.0.4.0  00:00:06
.
Total Upgrade Time: 00:21:05
SQL>