今天下午在家, 把自己本本上 oracle 9.2.0.1 for winxp 升级到了 oracle 9.2.0.8 简单记录了一下操作步骤
首先下载补丁包
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:
1.1.1Check 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.3Set 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.3Review 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.sql2.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就正常了