升级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 /patcheschown -R grid:oinstall /patcheschmod 775/patches

2.给OPath打补丁

用root用户执行下面的命令

cd /patchescp p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0.3/grid/cd /u01/app/11.2.0.3/grid/mv OPatch OPatch1unzip p6880880_112000_Linux-x86-64.zipchown -R grid:oinstall OPatchcd /patchescp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0.3/dbhome_1cd /u01/app/oracle/product/11.2.0.3/dbhome_1mv OPatch OPatch1unzip p6880880_112000_Linux-x86-64.zipchown -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_paramsThis is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_14-44-08.logThis 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.log2015-03-02 14:44:08: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch //patches/17592127apply successful for home/u01/app/11.2.0.3/grid patch //patches/17540582apply 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_paramsThis is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_15-49-09.logThis 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.log2015-03-02 15:49:09: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...Stopped RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfullypatch //patches/17592127/custom/server/17592127apply failedfor home/u01/app/oracle/product/11.2.0.3/dbhome_1Starting RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...Started RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfullyopatch auto succeeded.

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

5.给数据库打补丁

启动数据库
srvctl start database -d pord用oracle用户登录数据库，执行下面的脚本

[oracle@db01 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on 星期一 3月 2 16:11:13 2015Copyright （c） 1982, 2011, Oracle.All rights reserved.连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> @？/rdbms/admin/catbundle.sql psu apply

日志比较长，这里就不贴了。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址