数据库版本从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
重新查看数据字典的版本 得到如上的结果 说明升级成功