oracle升级步骤

下载并安装oracle9.2.0.1

http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip

http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip

http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip

下载升级到oracle9.2.0.3的patch

http://download.oracle.com/otn/nt/oracle9i/9203/9203WIN2K3.zip

oracle9.2.0.1 --&gtoracle9.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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/70612/viewspace-1023387/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/70612/viewspace-1023387/