重装了Oracle RAC 11.2.0.3,顺便打补丁到11.2.0.3.9,这里记下步骤。
1.将补丁上传到服务器上mkdir /patches chown -R grid:oinstall /patches chmod 775 /patches2.给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/emocmrsp3.给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的补丁打完之后,下面就是给数据库打补丁。
启动数据库
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
日志比较长,这里就不贴了。
: