oracle 9.2.0.1数据库升级到oracle 9.2.0.8方法

首先下载补丁包
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
To upgrade Oracle databases from a previous release directly to Oracle9[i]i release 2 (9.2.0.8) follow the instructions in Oracle[i]Metalink note 214887.1, [i]Upgrading Directly to a 9.2.0 Patch Set.
1: Required Postinstallation Tasks Complete the following tasks after installing the patch set software:
[list]
[color=#663300]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:
[list=a]
[*]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=[i]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=[i]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> @[i]ORACLE_BASE\[i]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.
[list=1]
[*]SQL> @[i]ORACLE_BASE\[i]ORACLE_HOME\rdbms\admin\utlrp.sql
2.8 If you are using the Oracle Recovery Manager catalog, enter the following command:
[list=1]
[*]C:\> rman catalog username/password@aliasRMAN> 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就正常了