检查补丁是否是rolling patch

    rolling patch在oracle RAC环境中经常被用到，因为这种打补丁的方式可以把对业务的影响降低到最小程度。要使用rolling patch方式打补丁，首先我们的先知道该补丁是否支持使用rolling patch方式。

   查看patch是否支持rolling patch如下几种方式：

1.在相应patch的readme

   一般在readme里面会指出该patch是否支持rolling patch，如下是11.2.0.3 的PUS11补丁里面关于补丁rolling patch的描述(可以使用rolling patch)

Oracle Grid Infrastructure Patch Set Update 11.2.0.3.11 (Includes Database PSU 11.2.0.3.11) - 18706488   Released: July 15, 2014 In this document Oracle Database Home refers to Enterprise Edition or Standard Edition Database software. GI refers to Grid Infrastructure and PSU refers to Patch Set Update. <span style="color:#ff0000;">The GI PSU patch includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion.</span>

 

2.使用相应的opatch 命令查询

  注意不同版本和不同平台的查询命令有所不同，如下为列举了一些平台和版本下的查询方式：

As database user execute the following:
    - 9i or 10gR1: opatch query -is_rolling
    - 10gR2: opatch query -all  [unzipped patch location] | grep rolling
    - 10gR2 on Windows: opatch query -all [unzipped patch location] | findstr rolling
    - Later 10gR2 or 11g: opatch query -is_rolling_patch [unzipped patch location]
The command may not work if unzipped patch location has more than one patch sub-directory, example output while checking CPU patches:

##如果我们所指定的unzipped patch location目录中还包含有子patch目录，那么查询命令可能会报下面的错误

Failed to load the patch object.  Possible causes are:  The specified path is not an interim Patch shiphome  Meta-data files are missing from the patch area  Patch location = /home/oracle/stage/8836308  Details = Input metadata files are missing.Patch Location "/home/oracle/stage/8836308" doesn't point to a valid patch area.OPatch failed with error code 75

 

  如psu11的database patch目录18522512下有很多子patch目录

<a target=_blank href="mailto:grid@****1:/home/grid$">grid@<span style="color:#000000;">****</span>1:/home/grid$</a> cd /data01/opatch/18522512/grid@****1:/data01/opatch/18522512$ ls -latotal 80drwxrwxr-x   13 grid     oinstall       8192 Jun 12 17:38 .drwxr-xr-x    4 grid     oinstall       8192 Oct 13 17:27 ..drwxr-xr-x    4 grid     oinstall         96 Jun 12 17:37 13343438drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 13696216drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 13923374drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 14275605drwxrwxr-x    5 grid     oinstall         96 Jun 12 17:37 14727310drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 16056266drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 16619892drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 16902043drwxrwxr-x    5 grid     oinstall         96 Jun 12 17:37 17540582drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 18031683drwxrwxr-x    4 grid     oinstall         96 Jun 12 17:37 18522512-rw-r--r--    1 grid     oinstall         29 Jun 12 17:37 README.html-rw-r--r--    1 grid     oinstall         21 Jun 12 17:37 README.txt-rw-r--r--    1 grid     oinstall       2872 Jun 12 17:38 patchmd.xml

  如果我们执行查询命令即报如下错误：

<a target=_blank href="mailto:grid@****1:/data01/opatch/18522512$">grid@<span style="color:#000000;">****</span>1:/data01/opatch/18522512$</a> opatch query -is_rolling_patch /data01/opatch/18522512Oracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /apps/oracle/11.2.0.3/gridCentral Inventory : /apps/oracle/oraInventory   from           : /apps/oracle/11.2.0.3/grid/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /apps/oracle/11.2.0.3/grid/cfgtoollogs/opatch/opatch2014-10-22_15-36-33PM_1.logFailed to load the patch object.  Possible causes are:  The specified path is not an interim Patch shiphome  Meta-data files are missing from the patch area  Patch location = /data01/opatch/18522512  Details = Input metadata files are missing.Patch Location "/data01/opatch/18522512" doesn't point to a valid patch area.OPatch failed with error code 75

   如果我们指定到18522512目录下的具体子目录，命令能够正常执行：

<a target=_blank href="mailto:grid@****1:/data01/opatch/18522512$">grid@****1:/data01/opatch/18522512$</a> opatch query -is_rolling_patch /data01/opatch/18522512/13343438/Oracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /apps/oracle/11.2.0.3/gridCentral Inventory : /apps/oracle/oraInventory   from           : /apps/oracle/11.2.0.3/grid/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /apps/oracle/11.2.0.3/grid/cfgtoollogs/opatch/opatch2014-10-22_15-38-34PM_1.log-------------------------------------------------------------------------------- Patch is a rolling patch: trueOPatch succeeded.

##详情请参考 "Rolling Patch - OPatch Support for RAC (Doc ID 244241.1)"

3.直接查看补丁包中的inventory文件
inventory文件具体位置：
<patchid>/etc/config/inventory

打开inventory文件，查找 <online_rac_installable>，如果为true，则支持rolling patch，如下红色行

<oneoff_inventory>      <opack_version version="11.2.0.3.0"/>      <patch_description>Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)</patch_description>      <patch_id number="17592127"/>      <unique_patch_id>17508149</unique_patch_id>      <minimum_opatch_version>11.2.0.3.5</minimum_opatch_version>      <cannot_autorollback>false</cannot_autorollback>      <date_of_patch year="2014" month="Jan" day="8" time="23:02:20 hrs" zone="PST8PDT"/>      <base_bugs>          <bug number="17592127" description="GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.9 (GI COMPONENTS)"/>  ......(中间部分略过)  <instance_shutdown>true</instance_shutdown>      <instance_shutdown_message></instance_shutdown_message>     <span style="color:#ff0000;"><span style="color:#ff0000;"> <online_rac_installable>true</online_rac_installable>  </span></span>    <run_as_root>false</run_as_root>  ......(后面略过)