oracle11.2扩容,升级Oracle RAC 11.2.0.3.0到 11.2.0.3.9-CSDN博客

本文详细记录了Oracle RAC 11.2.0.3版本的补丁安装过程，包括补丁下载、权限设置、补丁应用到Grid和Oracle软件，以及数据库补丁的安装步骤，涉及OPatch工具的使用和补丁应用的日志查看。

摘要由CSDN通过智能技术生成

重装了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的步骤。