oracle 9201升级到9207

数据库版本从9201升级到9207 

平台为windows XP

首先要将oralce的所有服务全部停止掉

然后用patch安装。

安装完毕之后启动数据库

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\lijun>cd ..

C:\Documents and Settings>cd ..

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on 星期二 6月 22 09:14:39 2010

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

SQL> conn /as sysdba
已连接。
SQL> desc dba_registry;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------

 COMP_ID                                   NOT NULL VARCHAR2(30)
 COMP_NAME                                          VARCHAR2(255)
 VERSION                                            VARCHAR2(30)
 STATUS                                             VARCHAR2(11)
 MODIFIED                                           VARCHAR2(20)
 CONTROL                                   NOT NULL VARCHAR2(30)
 SCHEMA                                    NOT NULL VARCHAR2(30)
 PROCEDURE                                          VARCHAR2(61)
 STARTUP                                            VARCHAR2(8)
 PARENT_ID                                          VARCHAR2(30)

SQL> select comp_name, version, status from dba_registry;

COMP_NAME
--------------------------------------------------------------------------------

VERSION                        STATUS
------------------------------ -----------
Oracle9i Catalog Views
9.2.0.1.0                      VALID

Oracle9i Packages and Types
9.2.0.1.0                      VALID

Oracle Workspace Manager
9.2.0.1.0                      VALID


COMP_NAME
--------------------------------------------------------------------------------

VERSION                        STATUS
------------------------------ -----------
JServer JAVA Virtual Machine
9.2.0.1.0                      VALID

Oracle XDK for Java
9.2.0.2.0                      VALID

Oracle9i Java Packages
9.2.0.1.0                      VALID


COMP_NAME
--------------------------------------------------------------------------------

VERSION                        STATUS
------------------------------ -----------
Oracle interMedia
9.2.0.1.0                      LOADED

Spatial
9.2.0.1.0                      LOADED

Oracle Text
9.2.0.1.0                      VALID


COMP_NAME
--------------------------------------------------------------------------------

VERSION                        STATUS
------------------------------ -----------
Oracle XML Database
9.2.0.1.0                      VALID

Oracle Ultra Search
9.2.0.1.0                      VALID

Oracle Data Mining
9.2.0.1.0                      LOADED


COMP_NAME
--------------------------------------------------------------------------------

VERSION                        STATUS
------------------------------ -----------
OLAP Analytic Workspace
9.2.0.1.0                      LOADED

Oracle OLAP API
9.2.0.1.0                      LOADED

OLAP Catalog
9.2.0.1.0                      INVALID


已选择15行。

SQL> col comp_name for a30
SQL> /

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle9i Catalog Views         9.2.0.1.0                      VALID
Oracle9i Packages and Types    9.2.0.1.0                      VALID
Oracle Workspace Manager       9.2.0.1.0                      VALID
JServer JAVA Virtual Machine   9.2.0.1.0                      VALID
Oracle XDK for Java            9.2.0.2.0                      VALID
Oracle9i Java Packages         9.2.0.1.0                      VALID
Oracle interMedia              9.2.0.1.0                      LOADED
Spatial                        9.2.0.1.0                      LOADED
Oracle Text                    9.2.0.1.0                      VALID
Oracle XML Database            9.2.0.1.0                      VALID
Oracle Ultra Search            9.2.0.1.0                      VALID

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle Data Mining             9.2.0.1.0                      LOADED
OLAP Analytic Workspace        9.2.0.1.0                      LOADED
Oracle OLAP API                9.2.0.1.0                      LOADED
OLAP Catalog                   9.2.0.1.0                      INVALID

已选择15行。

查看数据字典的版本  发现还是9201  需要升级数据字典

Startup migrate 
执行rdbms\admin下面的catpatch.sql脚本升级数据字典
脚本执行完毕之后，查看日志看有没有错误信息
SQL> select comp_name, version,status from dba_registry;

COMP_NAME                           VERSION                        STATUS
----------------------------------- ------------------------------ ----------
Oracle9i Catalog Views              9.2.0.7.0                      VALID
Oracle9i Packages and Types         9.2.0.7.0                      VALID
Oracle Workspace Manager            9.2.0.1.0                      VALID
JServer JAVA Virtual Machine        9.2.0.7.0                      VALID
Oracle XDK for Java                 9.2.0.9.0                      VALID
Oracle9i Java Packages              9.2.0.7.0                      VALID
Oracle interMedia                   9.2.0.7.0                      VALID
Spatial                             9.2.0.7.0                      VALID
Oracle Text                         9.2.0.7.0                      VALID
Oracle XML Database                 9.2.0.7.0                      VALID
Oracle Ultra Search                 9.2.0.7.0                      INVALID

COMP_NAME                           VERSION                        STATUS
----------------------------------- ------------------------------ ----------
Oracle Data Mining                  9.2.0.7.0                      VALID
OLAP Analytic Workspace             9.2.0.7.0                      UPGRADED
Oracle OLAP API                     9.2.0.7.0                      UPGRADED
OLAP Catalog                        9.2.0.7.0                      VALID

重新查看数据字典的版本 得到如上的结果 说明升级成功