Oracle Patch冲突检测的问题

Maclean Liu(刘相兵

vmware是linux ， 下载的补丁是aix的， 能在linux上检查aix上的补丁有冲突？

Maclean Liu(刘相兵

How to find whether the one-off Patches will conflict or not?

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
Goal
You want to apply 'n' one-off Patches on top of your existing Oracle Home in which some one-off Patches are already installed and you want to know whether or not the Patches you have already applied will conflict with the Patches to be applied.
Solution
It is difficult to predict whether or not the Patches will conflict without actually applying them, but we can use the OPatch tool to check the same without actually applying the Patches to the Oracle Home.

To check whether there will be a conflict among the patches which needs to be applied and / or to check the patches which are to be installed will conflict or not with the already installed patches you can use the following queries in OPatch.

Make sure that the latest opatch version is being used as per  Note 374092.1

After confirming that you have the latest version of OPatch, proceed to download all the patches that you intend to install and unzip them into the same directory, lets say for example, all the patches which you need to install should be unzipped to $ORACLE_HOME/patches directory.

Run the following command to check whether there are any conflicts among the patches to be applied.

This will Check if there are any conflicts among the patches to be applied,
by giving out the detailed information about the conflicts/supersets.

$ opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir <path to base dir where all the patches to be applied are kept>

In this case the command

$ opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir $ORACLE_HOME/patches

Run the following command to check whether there are any conflicts between the patches to be
applied and the patches already applied in the Oracle Home.

$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <path to base dir where all the patches to be applied are kept>

This checks if there are any conflicts between the patches to be applied and the patches in the
Oracle Home, by giving out the detailed information about the conflicts/supersets.

NOTE: The -skip_duplicate and -skip_subset options cannot be used with "opatch prereq" and
"opatch prereq" will automatically show all subsets and duplicates as "superset", so those can be ignored, and only the prereq output that shows "conflict" needs to be addressed.
Known Issues
Issue 1:

INFO:Unable to create Patch Object.
Exception occured : PatchObject constructor: Input file "/dba/downloads/patch_candidates/6646853/etc/config/actions" or "/dba/downloads/patch_candidates/6646853/etc/config/inventory" does not exist.

While running the opatch checkconflict commands for CPU patches for 10.2.0.3 and above move README.html and patchmd.xml files out of the patch directory. (remove any other single files like cpu_root.sh in the phBaseDir directory) and then execute the command, otherwise you will see errors like the ones above.

Issue 2:

While checking for potential conflict with the 'opatch prereq' command, the following error may occur.

Exception occured : PatchObject constructor: Input file "/refresh/32bit/app/oracle/product/10.2.0.3/patches/6081547/etc/config/actions" or "/refresh/32bit/app/oracle/product/10.2.0.3/patches/6081547/etc/config/inventory" does not exist.

Please refer to the following Metalink document

Note 788181.1 - opatch prereq CheckConflict fails with Exception occured : PatchObject constructor:Input file does not exist

Maclean Liu(刘相兵

CheckConflictAmongPatchesWithDetail  应当是基于oracle patch本身的，所以我觉得是可以跨平台 检测补丁冲突性的。

但是这需要具体测试，测试后 会回复本帖。

Maclean Liu(刘相兵

FROM ORACLE ALLSTARS GROUP  JACK SHEN :

[oracle10g@oel OPatch]$ ./opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir /u02/app/oracle/product/10.2.0/db_1/patches/
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u02/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /u02/app/oracle/product/10.2.0/db_1/oui
Log file location : /u02/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-04-11_20-01-42PM.log

Patch history file: /u02/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictamongpatcheswithdetail"

ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAmongPatchesWithDetail" failed.

Summary of Conflict Analysis:

Patches that can be applied now without any conflicts are :
11724962, 8974352

Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
9952245

Conflicts/Supersets for each patch are:

Patch : 8974352

        Bug Superset of 9952245
        Super set bugs are:
        9952245, 9879181, 9610672, 9872299, 9577921, 8308495, 9103966, 8996060,6899183, 9261837, 8487143, 9646836

Patch : 9952245

        Bug SubSet of 8974352
        Subset bugs are:
        9952245, 9879181, 9610672, 9872299, 9577921, 8308495, 9103966, 8996060,6899183, 9261837, 8487143, 9646836

OPatch succeeded.

不过，奇怪的是：
Patches that can be applied now without any conflicts are :
11724962, 8974352


然后又说有冲突

明白了
看这句就可以了：
Patches that can be applied now without any conflicts are :
11724962, 8974352

Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
9952245