oracle 10.2.0.4 rac 升级到oracle 10.2.0.5 rac步骤

环境 aix 6.1 + emc cx500 +oracle 10gR2
oracle 10.2.0.5 for aix 版本到今天为止已经推出一周。
今天有时间在公司做了 oracle 10.2.0.4 rac 升级到 oracle 10.2.0.5 rac 的 实验,操作步骤与oracle 10.2.0.1
升级到oracle 10.2.0.4一样,以下为oracle 10.2.0.4 rac 升级到oracle 10.2.0.5 rac 实验步骤:

1.先升级cluster到10.2.0.5
slibclean
运行runInstaller,选择CRS_HOME ,软件安装完成后,每个节点运行以下脚本
cd /crs/app/oracle/product/crs_1/bin
./crsctl stop crs
cd /crs/app/oracle/product/crs_1/install
./root102.sh

2.安装ORACLE代码到10.2.0.5
slibclean
运行runInstaller,选择ORACLE_HOME ,软件安装完成后,每个节点运行以下脚本
cd /oracle/app/oracle/product/10.2.0/clusterdb
./root.sh

2.升级数据库数据字典到oracle 10.2.0.5
[list=1]

[*]SQL> STARTUP NOMOUNT

[*]Set the [font=新宋体][size=1]CLUSTER_DATABASE initialization parameter to [size=1][font=新宋体]FALSE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;

[*]Shut down the database:

[*]SQL> SHUTDOWN

[list=1]

SQL> STARTUP UPGRADE[list=1]
[list=1]
SQL> SPOOL patch.log[list=1]
[list=1]
SQL> @?/rdbms/admin/catupgrd.sql[list=1]
[list=1]
SQL> SPOOL OFF [list=1]
[list=1]
SQL>@?/rdbms/admin/utlrp.sql [list=1]
[list=1]
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; [list=1]
[list=1]
SQL> SHUTDOWN IMMEDIATE [list=1]
[list=1]
SQL> STARTUP[list=1]
[list=1]
srvctl start database -d [i]db_name[list=1]
[list=1]
srvctl start service -d [i]db_name -s [i]service_name 升级成功我们验证下结果:

SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production5 rows selected.SQL> select comp_id,comp_name,version,status,modified from dba_registry;COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS MODIFIED
------------------------------ ---------------------- -----------------------
OWM
Oracle Workspace Manager
10.2.0.5.0 VALID 10-JUN-2010 13:05:24CATALOG
Oracle Database Catalog Views
10.2.0.5.0 VALID 10-JUN-2010 13:04:12CATPROC
Oracle Database Packages and Types
10.2.0.5.0 VALID 10-JUN-2010 13:04:12RAC
Oracle Real Application Clusters
10.2.0.5.0 VALID 10-JUN-2010 13:04:14
4 rows selected.