今天下午在家, 把自己本本上 oracle 9.2.0.1 for winxp 升级到了 oracle 9.2.0.8 简单记录了一下操作步骤

首先下载补丁包

ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip

To upgrade Oracle databases from a previous release directly to Oracle9i release 2 (9.2.0.8) follow the instructions in OracleMetalink note 214887.1, Upgrading Directly to a 9.2.0 Patch Set.

1: Required Postinstallation Tasks

Complete the following tasks after installing the patch set software:

Check Tablespace Sizes and Set Parameter Values
1.1.1 Check SYSTEM Tablespace Size

If JServer is part of the installation ensure that there is at least 10 MB of free space allocated to the SYSTEM tablespace.

1.1.3 Set the SHARED_POOL_SIZE and JAVA_POOL_SIZE Initialization Parameters

If the system is using a server parameter file:

If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB:
```
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile; 
```
If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB:
```
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile; 
```

1.1.4 lsnrctl stop,

停止oracle数据库服务

net stop oracleservicetest

shutdown immediate;

2: Upgrade the Database

2.1 安装oracle 9.2.0.8 补丁包软件点setup.exe就可以了注意选择和oracle

_home路径一致,安装完成后,进行下一步数据库升级

2.2 sqlplus "/as sysdba"

         SQL> STARTUP MIGRATE
         SQL> SPOOL patch.log
         SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
         SQL> SPOOL OFF

2.3 Review the patch.log file for errors and inspect the list of components that is displayed at the end of catpatch.sql script

2.4 This list provides the version and status of each SERVER component in the database.

2.5 If necessary, rerun the catpatch.sql script. after correcting any problems.

2.6 Restart the database:

             SQL> SHUTDOWN
             SQL> STARTUP

2.7 Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql

2.8 If you are using the Oracle Recovery Manager catalog, enter the following command:

C:\> rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

升级成功后,用exp测试进行导出后发现以下错误:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
解决方法:
在这种情况下，是因为OLAP被设置为ON但是却没有安装OLAP的原因。我们可以通过以SYS用户登录后，执行@?/olap/admin/olap.sql ;来创建OLAP
创建完成后,再exp 看log就正常了

oracle 9.2.0.1 升级到oracle 9.2.0.8方法

1: Required Postinstallation Tasks