当然,这里只操作了1号节点,要确保RAC所有节点重复都进行了该操作。现在看到,已经更新为最新的11.2.0.3.5版本,符合本次补丁对Opatch工具的要求。
第二点:OCM(OracleConfiguration Manager)配置,在运行补丁的时候,需要配置OCM,方法很简单,在说明文档中有详细的记录,只需要在以grid用户执行$crs_home/OPatch/ocm/bin/emocmrsp根据提示进行配置,配置完成后会生成个ocm.rsp文件,后续会用到这个文件。
[grid@rac1patch]$ /u01/app/grid/OPatch/ocm/emocmrsp
5.3.3. 前提补丁安装
在确认安装条件满足后,就开始正式的准备p9655006补丁的安装,首先安装GI的补丁,安装的时候要求crs进程必须启动,因此这里我们只需要停止数据库实例,我们先打1号节点的补丁,因此先停止1号节点的实例,如下:
[grid@rac1 bin]$srvctl stop instance -d orcl -i orcl1
然后我们要以root用户,执行opatchauto执行补丁升级,后面要跟上补丁的解压目录和crs_home目录,如下,
[root@rac1bin]# opatch auto /home/grid/stage/patch -oh /u01/app/grid/(这里是CRS_HOME目录)
Executing/u01/app/grid/perl/bin/perl /u01/app/grid/OPatch/crs/patch11202.pl -patchdir/home/grid/stage -patchn patch -oh /u01/app/grid/ -paramfile/u01/app/grid/crs/install/crsconfig_params
Usingconfiguration parameter file: /u01/app/grid/crs/install/crsconfig_params
OPatch is bundled with OCM, Enter the absolute OCMresponse file path:
/home/grid/stage/patch/ocm.rsp(这里要求输入刚才生成的ocm.rsp文件)
Unableto determine if /u01/app/grid is shared oracle home
Enter'yes' if this is not a shared home or if the prerequiste actions are performedto patch this shared home (yes/no):yes
Successfullyunlock /u01/app/grid
patch/home/grid/stage/patch/9655006 applysuccessful for home /u01/app/grid
patch/home/grid/stage/patch/9654983 applysuccessful for home /u01/app/grid
最后我们可以看到提示,补丁成功安装,接下来同样的在节点2上进行补丁安装,方法相同,这里就不再描述,接下来用同样的方式给数据库database打补丁,同样的先在节点1上进行补丁安装,命令如下
[root@rac1bin]# opatch auto /home/grid/stage/patch/ -oh /u01/app/oracle/product/11.2.0/db_1/(这个是db_home目录)
xecuting/u01/app/grid/perl/bin/perl /u01/app/grid/OPatch/crs/patch11202.pl -patchdir/home/grid/stage -patchn patch -oh /u01/app/oracle/product/11.2.0/db_1/-paramfile /u01/app/grid/crs/install/crsconfig_params
INCis /home/grid/stage/patch/9655006/files/crs/install /u01/app/grid/crs/install/u01/app/grid/perl/lib/5.10.0/i686-linux-thread-multi/u01/app/grid/perl/lib/5.10.0/u01/app/grid/perl/lib/site_perl/5.10.0/i686-linux-thread-multi/u01/app/grid/perl/lib/site_perl/5.10.0 .
opatchauto log file location is /u01/app/grid/OPatch/crs/../../cfgtoollogs/opatchauto2013-11-05_11-57-18.log
2013-11-0511:57:18: Parsing the host name
2013-11-0511:57:18: Checking for super user privileges
2013-11-0511:57:18: User has super user privileges
DetectedOracle Clusterware install
Usingconfiguration parameter file: /u01/app/grid/crs/install/crsconfig_params
OPatch is bundled with OCM, Enter the absolute OCMresponse file path:
/home/grid/stage/patch/ocm.rsp
Unableto determine if /u01/app/oracle/product/11.2.0/db_1 is shared oracle home
Enter'yes' if this is not a shared home or if the prerequiste actions are performedto patch this shared home (yes/no):yes
Unableto determine if /u01/app/oracle/product/11.2.0/db_1 is shared oracle home
Enter'yes' if this is not a shared home or if the prerequiste actions are performedto patch this shared home (yes/no):yes
patch/home/grid/stage/patch/9655006/custom/server/9655006 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch/home/grid/stage/patch/9654983 applysuccessful for home /u01/app/oracle/product/11.2.0/db_1
我们可以通过opatch lsinventory命令检查补丁的安装情况,如下
[oracle@demo-rac1OPatch]$ ./opatch lsinventory
OracleInterim Patch Installer version 11.2.0.3.5
Copyright(c) 2013, Oracle Corporation. All rightsreserved.
OracleHome :/u01/app/oracle/product/11.2.0/db_1
CentralInventory : /u01/app/oraInventory
from :/u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatchversion : 11.2.0.3.5
OUIversion : 11.2.0.1.0
Logfile location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-11-05_12-04-17PM_1.log
LsinventoryOutput file location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-11-05_12-04-17PM.txt
--------------------------------------------------------------------------------
InstalledTop-level Products (1):