下载并安装oracle9.2.0.1
下载升级到oracle9.2.0.3的patch
oracle9.2.0.1 -->oracle9.2.0.3 整个升级过程大约持续一个小时
阅读patch readme文档,按照文档进行patch升级,大体步骤如下
停止所有的application,sqlplus等
停止所有相关的oracle service,listener
运行universal install,选择下载的patch,运行安装程序
启动所有oracle服务
shutdown immediate;
startup migrate;
spool e:patch.log
@E:oracleora92rdbms/admin/catpatch.sql
spool off
shutdown
startup
@E:oracleora92rdbms/admin/utlrp.sql
rman catalog upgrade catalog;
upgrade catalog;
--验证升级
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.3.0 - Production
NLSRTL Version 9.2.0.3.0 - Production
--升级成功。
总结:oracle升级大体完成的主要是对dictionary,dbms package,编译升级造成的invalide object,rman catalog等的升级,还有就是对bug的修复。
[@more@]