如何解决Oracle补丁冲突

最近实施11gR2的ADG,为了解决备库RAC的应用节点异常宕掉后,不自动选用另一个节点作为应用节点这个问题,根据 1613719.1文档要求,在11.2.0.4版本上需要打两个补丁,并设置_adg_instance_recovery这个隐含参数为true。

  • Bug fix for 18331944.
  • Bug fix for 19516448.
  • 下载好对应PSU版本的这两个补丁,发现打补丁时,这两个补丁冲突,情况如下:

    $ORACLE_HOME/OPatch/opatch apply 
    Oracle Interim Patch Installer version 11.2.0.3.12
    Copyright (c) 2018, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home      : /oracle/app/oracle/product/11.2.0/db
    Central Inventory : /oracle/app/oraInventory
      from          : /oracle/app/oracle/product/11.2.0/db/oraInst.loc
    OPatch version    : 11.2.0.3.12
    OUI version      : 11.2.0.4.0
    Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/19516448_Jan_29_2018_19_04_48/apply2018-01-29_19-04-48PM_1.log
    
    Verifying environment and performing prerequisite checks...
    
    Conflicts/Supersets for each patch are:
    
    Patch : 19516448
    
            Conflict with 18331944
            Conflict details:
            /oracle/app/oracle/product/11.2.0/db/lib/libserver11.a:kcb.o
            /oracle/app/oracle/product/11.2.0/db/lib/libserver11.a:krd.o
            /oracle/app/oracle/product/11.2.0/db/lib/libserver11.a:kcbz.o
    
    
    Following patches have conflicts: [  18331944  19516448 ]
    Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.
    
    UtilSession failed: Inter-conflict checking failed in apply incoming patches
    Log file location: /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/19516448_Jan_29_2018_19_04_48/apply2018-01-29_19-04-48PM_1.log
    
    OPatch failed with error code 73
    

    那如何解决这两个问题呢,根据1299688.1这篇文档,找到的解决办法。在MOS上先搜索18331944这个补丁

    选择对应的PSU版本,然后”使用OPatch进行分析”

    然后添加补丁程序

    选择对应的PSU版本,然后“使用OPatch进行分析”

    确认这两个补丁在列表里,然后“分析冲突”

    然后“请求补丁程序”

    然后在下载补丁程序里,就得到了这两个冲突补丁的合并补丁,安装这个补丁即可

    打完补丁后的情况

    $ $ORACLE_BASE/OPatch/opatch lsinventory
    -bash: /oracle/app/oracle/OPatch/opatch: No such file or directory
    [oracle@cpctdb11 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
    Oracle Interim Patch Installer version 11.2.0.3.12
    Copyright (c) 2018, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home      : /oracle/app/oracle/product/11.2.0/db
    Central Inventory : /oracle/app/oraInventory
      from          : /oracle/app/oracle/product/11.2.0/db/oraInst.loc
    OPatch version    : 11.2.0.3.12
    OUI version      : 11.2.0.4.0
    Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-31_08-26-58AM_1.log
    
    Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-31_08-26-58AM.txt
    
    --------------------------------------------------------------------------------
    Local Machine Information::
    Hostname: cpctdb11
    ARU platform id: 226
    ARU platform description:: Linux x86-64
    
    Installed Top-level Products (1): 
    
    Oracle Database 11g                                                  11.2.0.4.0
    There are 1 products installed in this Oracle Home.
    
    
    Interim patches (3) :
    
    Patch  27293201    : applied on Mon Jan 29 19:39:07 CST 2018
    Unique Patch ID:  21813166
      Created on 23 Dec 2017, 13:34:37 hrs PST8PDT
      Bugs fixed:
        19516448, 18331944
      This patch overlays patches:
        26925576
      This patch needs patches:
        26925576
      as prerequisites
    

    关于紫砂壶

    感悟技术人生
    此条目发表在故障处理分类目录,贴了标签。将固定链接加入收藏夹。