升级Oracle RAC 11.2.0.3.0到 11.2.0.3.9

重装了Oracle RAC 11.2.0.3，顺便打补丁到11.2.0.3.9，这里记下步骤。

1.将补丁上传到服务器上

mkdir /patches
chown -R grid:oinstall /patches
chmod 775  /patches

2.给OPath打补丁

用root用户执行下面的命令

cd /patches
cp p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0.3/grid/
cd /u01/app/11.2.0.3/grid/
mv OPatch OPatch1
unzip p6880880_112000_Linux-x86-64.zip
chown -R grid:oinstall OPatch

cd /patches
cp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0.3/dbhome_1
cd /u01/app/oracle/product/11.2.0.3/dbhome_1
mv OPatch OPatch1
unzip p6880880_112000_Linux-x86-64.zip
chown -R oracle:oinstall OPatch

用grid和oracle分别执行下面的命令生成响应文件

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp

3.给grid软件打补丁

将opatch加到PATH里

export PATH=$PATH:/u01/app/11.2.0.3/grid/OPatch

用root用户给grid打补丁

[root@db01 ~]# opatch auto /patches/ -ocmrf /home/grid/ocm.rsp  -oh /u01/app/11.2.0.3/grid/
Executing /u01/app/11.2.0.3/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch11203.pl -patchdir / -patchn patches -ocmrf /home/grid/ocm.rsp -oh /u01/app/11.2.0.3/grid/ -paramfile /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_14-44-08.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_14-44-08.report.log

2015-03-02 14:44:08: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully

patch //patches/17592127  apply successful for home  /u01/app/11.2.0.3/grid 
patch //patches/17540582  apply successful for home  /u01/app/11.2.0.3/grid 

Starting CRS...
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

4.给oracle软件打补丁

同样用root执行下面的命令。

[root@db01 ~]# opatch auto /patches/ -ocmrf /home/grid/ocm.rsp  -oh /u01/app/oracle/product/11.2.0.3/dbhome_1/
Executing /u01/app/11.2.0.3/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch11203.pl -patchdir / -patchn patches -ocmrf /home/grid/ocm.rsp -oh /u01/app/oracle/product/11.2.0.3/dbhome_1/ -paramfile /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_15-49-09.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_15-49-09.report.log

2015-03-02 15:49:09: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfully

patch //patches/17592127/custom/server/17592127  apply failed  for home  /u01/app/oracle/product/11.2.0.3/dbhome_1

Starting RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...
Started RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfully

opatch auto succeeded.

到这一步节点1的补丁已经打完了，在节点2上同样执行1-4的步骤。
节点2的补丁打完之后，下面就是给数据库打补丁。

5.给数据库打补丁

启动数据库
srvctl start database -d pord

用oracle用户登录数据库，执行下面的脚本

[oracle@db01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期一 3月 2 16:11:13 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @?/rdbms/admin/catbundle.sql psu apply

日志比较长，这里就不贴了。