RAC 10.2.0.1 升级到 10.2.0.5

一、 准备：

Patch 包：p8202632_10205_LINUX.zip

节点数：3个节点

RAC1 RAC2 RAC3

当前节点状态

节点1：

[root@rac1 bin]# ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....B1.inst application ONLINE ONLINE rac1

ora....B2.inst application ONLINE ONLINE rac2

ora....B3.inst application ONLINE ONLINE rac3

ora.RACDB.db application ONLINE ONLINE rac1

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

ora....SM3.asm application ONLINE ONLINE rac3

ora....C3.lsnr application ONLINE ONLINE rac3

ora.rac3.gsd application ONLINE ONLINE rac3

ora.rac3.ons application ONLINE ONLINE rac3

ora.rac3.vip application ONLINE ONLINE rac3

查看当前数据库版本

SYS@RACDB1>select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

二、 集群软件升级

2.1 上传升级需要的 patch

[root@rac1 soft]# chown oracle:oinstall -R Disk1/

[root@rac1 soft]# ll

drwxr-xr-x 5 oracle oinstall 4096 Jul 23 2010 Disk1

2.2 切换到oracle用户下进行

[root@rac1 Disk1]# su - oracle

[oracle@rac1 ~]$ cd /soft/Disk1/

[oracle@rac1 Disk1]$ ls

install patch_note.htm response runInstaller stage

[oracle@rac1 Disk1]$ ll

total 184

drwxr-xr-x 4oracle oinstall 4096 Apr 20 2010 install

-rwxrwxr-x 1oracle oinstall 165290 Jul 23 2010patch_note.htm

drwxr-xr-x 2oracle oinstall 4096 Apr 20 2010 response

-rwxr-xr-x 1oracle oinstall 3927 Apr 20 2010 runInstaller

drwxr-xr-x 11 oracle oinstall 4096 Jul 19 2010 stage

2.3 用srvctl 工具关闭进程和资源

注：依次在每个节点上执行！！！

[oracle@rac1 Disk1]$ srvctl stop nodeapps -n rac1

[oracle@rac2 ]$ srvctl stop nodeapps -n rac2

[oracle@rac3 ]$ srvctl stop nodeapps -n rac3

[oracle@rac1 Disk1]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....B1.inst application OFFLINE OFFLINE

ora....B2.inst application OFFLINE OFFLINE

ora....B3.inst application OFFLINE OFFLINE

ora.RACDB.db application OFFLINE OFFLINE

ora....SM1.asm application OFFLINE OFFLINE

ora....C1.lsnr application OFFLINE OFFLINE

ora.rac1.gsd application OFFLINE OFFLINE

ora.rac1.ons application OFFLINE OFFLINE

ora.rac1.vip application OFFLINE OFFLINE

ora....SM2.asm application OFFLINE OFFLINE

ora....C2.lsnr application OFFLINE OFFLINE

ora.rac2.gsd application OFFLINE OFFLINE

ora.rac2.ons application OFFLINE OFFLINE

ora.rac2.vip application OFFLINE OFFLINE

ora....SM3.asm application OFFLINE OFFLINE

ora....C3.lsnr application OFFLINE OFFLINE

ora.rac3.gsd application OFFLINE OFFLINE

ora.rac3.ons application OFFLINE OFFLINE

ora.rac3.vip application OFFLINE OFFLINE

2.4 开始安装 patch

[root@rac1 Disk1]# xhost +

access control disabled, clients can connect fromany host

[root@rac1 Disk1]# su - oracle