oracle升级步骤,oracle升级步骤

下载并安装oracle9.2.0.1

下载升级到oracle9.2.0.3的patch

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@]