本文详细记录了在Oracle数据库环境中安装补丁的过程，包括下载补丁、升级opatch、验证补丁版本和应用补丁等步骤，并通过日志文件展示了整个补丁安装流程。同时，文章还介绍了如何解决补丁冲突和回退问题。
收到邮件说要打一下这个psu的补丁，所以就找了一个11.2.0.3的database做了一下，下面是步骤：
Database 11.2.0.3.2 PSU Patch 13696216
1、download Patch 13696216
2、安装：
其实安装步骤在自许文件中都有，这里主要要说明的就是如何升级optch
[oracle@oracle11g-std 13696216]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory_new
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-02-39下午.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves.
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
13772618, 13696216, 13742464, 13632717
Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
13742438, 13742437, 13742436, 13742435, 13742434, 13742433
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
13772618, 13742464, 13742438, 13742437, 13742436, 13742435, 13742434, 13742433, 13632717
Conflicts/Supersets for each patch are:
Patch : 13696216
Bug Conflict with 13772618
Conflicting bugs are:
13772618, 12748240, 12780098
Bug Conflict with 13742464
Conflicting bugs are:
13742464, 13503598, 13554409
Bug Superset of 13742438
Super set bugs are:
13742438
Bug Superset of 13742437
Super set bugs are:
13742437
Bug Superset of 13742436
Super set bugs are:
13742436
Bug Superset of 13742435
Super set bugs are:
13742435
Bug Superset of 13742434
Super set bugs are:
13742434
Bug Superset of 13742433
Super set bugs are:
13742433
Bug Conflict with 13632717
Conflicting bugs are:
13632717
OPatch succeeded.
[oracle@oracle11g-std 13696216]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
参数错误... For the composite patch you have specified, the number of entries in the composite.xml does not equal the number of inventory.xml's. This could mean you are trying to apply the active constituent alone. Please supply the top-level directory of the composite patch, not one of its subdirectories, for opatch apply. If you still get this error after applying the top-level directory the composite patch may be improperly packaged.
Please check the arguments and try again.
OPatch failed with error code 135
[oracle@oracle11g-std 13696216]$ cd ..
[oracle@oracle11g-std 13696216]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory_new
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-03-24下午.log
Verifying environment and performing prerequisite checks...
UtilSession 失败:
Patch 13696216 requires OPatch version 11.2.0.3.0.
The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
Log file location: /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-03-24下午.log
从错误提示知道是当前的opatch的版本太低，需要对opatch进行升级
OPatch - Where Can I Find the Latest Version of OPatch? [Video] [ID 224346.1]---可以查看这个文档来进行操作
截取一段：
For Oracle11g Release 2 (11.2.0.x),
select release "11.2.0.0.0" (description "OPatch 11.2") and download
p6880880_112000_platform.zip
As of 22-Mar-2012 the OPatch release is 11.2.0.3.0
然后就要去找这个补丁了
按照这个可以下到最新的opatch
升级opatch
备份原opatch
[oracle@oracle11g-std 11.2.0.3]$ tar -cvf OPatch.tar OPatch/
[oracle@oracle11g-std ~]$ unzip p6880880_112000_Linux-x86-64.zip
mv OPatch/ /home/oracle/app/product/11.2.0.3/
[oracle@oracle11 OPatch]$ ./opatch -help
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
确认版本是11.2.0.3.0
此时再打补丁13696216
[oracle@oracle11 13696216]$ opatch apply
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/product/11.2.0.3/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_22-27-23下午_1.log
Verifying environment and performing prerequisite checks...
Composite Patch 13696216 is a bug superset of 13772618,13742464,13742438,13742437,13742436,13742435,13742434,13742433,13632717 in OH.
在应用指定列表中的补丁程序时, 以下补丁程序将从 Oracle 主目录中回退:
13772618 13742464 13742438 13742437 13742436 13742435 13742434 13742433 13632717
是否继续? [y|n]
y
User Responded with: Y
OPatch continues with these patches: 13343438 13696216
是否继续? [y|n]
y
User Responded with: Y
All checks passed.
...........................................
SQL> startup
ORACLE instance started.
Total System Global Area 304807936 bytes
Fixed Size 2227864 bytes
Variable Size 209715560 bytes
Database Buffers 88080384 bytes
Redo Buffers 4784128 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
............................................................
到此psu就打完了，接下来就是验证安装的psu
[oracle@oracle11 ~]$ cd app/product/11.2.0.3/OPatch
[oracle@oracle11 OPatch]$ ./opatch lsinventory
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/product/11.2.0.3/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_23-31-36下午_1.log
Lsinventory Output file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2012-05-30_23-31-36下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (1) :
Patch 13696216 : applied on Wed May 30 22:39:07 CST 2012
Unique Patch ID: 14596729
Patch description: "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Created on 3 Apr 2012, 22:02:51 hrs PST8PDT
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13070939, 13035804, 10350832, 13632717, 13041324, 12919564, 13420224
13742437, 12861463, 12834027, 13742438, 13332439, 13036331, 13499128
12998795, 12829021, 13492735, 9873405, 13742436, 13503598, 12960925
12718090, 13742433, 12662040, 9703627, 12905058, 12938841, 13742434
12849688, 12950644, 13362079, 13742435, 12620823, 12917230, 12845115
12656535, 12764337, 13354082, 12588744, 11877623, 12612118, 12847466
13742464, 13528551, 12894807, 13343438, 12582664, 12780983, 12748240
12797765, 12780098, 13696216, 12923168, 13466801, 13772618, 11063191, 13554409
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oracle11 OPatch]$
Database 11.2.0.3.2 PSU Patch 13696216
1、download Patch 13696216
2、安装：
其实安装步骤在自许文件中都有，这里主要要说明的就是如何升级optch
[oracle@oracle11g-std 13696216]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory_new
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-02-39下午.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves.
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
13772618, 13696216, 13742464, 13632717
Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
13742438, 13742437, 13742436, 13742435, 13742434, 13742433
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
13772618, 13742464, 13742438, 13742437, 13742436, 13742435, 13742434, 13742433, 13632717
Conflicts/Supersets for each patch are:
Patch : 13696216
Bug Conflict with 13772618
Conflicting bugs are:
13772618, 12748240, 12780098
Bug Conflict with 13742464
Conflicting bugs are:
13742464, 13503598, 13554409
Bug Superset of 13742438
Super set bugs are:
13742438
Bug Superset of 13742437
Super set bugs are:
13742437
Bug Superset of 13742436
Super set bugs are:
13742436
Bug Superset of 13742435
Super set bugs are:
13742435
Bug Superset of 13742434
Super set bugs are:
13742434
Bug Superset of 13742433
Super set bugs are:
13742433
Bug Conflict with 13632717
Conflicting bugs are:
13632717
OPatch succeeded.
[oracle@oracle11g-std 13696216]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
参数错误... For the composite patch you have specified, the number of entries in the composite.xml does not equal the number of inventory.xml's. This could mean you are trying to apply the active constituent alone. Please supply the top-level directory of the composite patch, not one of its subdirectories, for opatch apply. If you still get this error after applying the top-level directory the composite patch may be improperly packaged.
Please check the arguments and try again.
OPatch failed with error code 135
[oracle@oracle11g-std 13696216]$ cd ..
[oracle@oracle11g-std 13696216]$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle 中间补丁程序安装程序版本 11.2.0.1.7
版权所有 (c) 2011, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory_new
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-03-24下午.log
Verifying environment and performing prerequisite checks...
UtilSession 失败:
Patch 13696216 requires OPatch version 11.2.0.3.0.
The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
Log file location: /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_19-03-24下午.log
从错误提示知道是当前的opatch的版本太低，需要对opatch进行升级
OPatch - Where Can I Find the Latest Version of OPatch? [Video] [ID 224346.1]---可以查看这个文档来进行操作
截取一段：
For Oracle11g Release 2 (11.2.0.x),
select release "11.2.0.0.0" (description "OPatch 11.2") and download
p6880880_112000_platform.zip
As of 22-Mar-2012 the OPatch release is 11.2.0.3.0
然后就要去找这个补丁了
按照这个可以下到最新的opatch
升级opatch
备份原opatch
[oracle@oracle11g-std 11.2.0.3]$ tar -cvf OPatch.tar OPatch/
[oracle@oracle11g-std ~]$ unzip p6880880_112000_Linux-x86-64.zip
mv OPatch/ /home/oracle/app/product/11.2.0.3/
[oracle@oracle11 OPatch]$ ./opatch -help
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
确认版本是11.2.0.3.0
此时再打补丁13696216
[oracle@oracle11 13696216]$ opatch apply
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/product/11.2.0.3/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_22-27-23下午_1.log
Verifying environment and performing prerequisite checks...
Composite Patch 13696216 is a bug superset of 13772618,13742464,13742438,13742437,13742436,13742435,13742434,13742433,13632717 in OH.
在应用指定列表中的补丁程序时, 以下补丁程序将从 Oracle 主目录中回退:
13772618 13742464 13742438 13742437 13742436 13742435 13742434 13742433 13632717
是否继续? [y|n]
y
User Responded with: Y
OPatch continues with these patches: 13343438 13696216
是否继续? [y|n]
y
User Responded with: Y
All checks passed.
...........................................
SQL> startup
ORACLE instance started.
Total System Global Area 304807936 bytes
Fixed Size 2227864 bytes
Variable Size 209715560 bytes
Database Buffers 88080384 bytes
Redo Buffers 4784128 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
............................................................
到此psu就打完了，接下来就是验证安装的psu
[oracle@oracle11 ~]$ cd app/product/11.2.0.3/OPatch
[oracle@oracle11 OPatch]$ ./opatch lsinventory
Oracle 中间补丁程序安装程序版本 11.2.0.3.0
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
Oracle Home : /home/oracle/app/product/11.2.0.3
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/product/11.2.0.3/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-05-30_23-31-36下午_1.log
Lsinventory Output file location : /home/oracle/app/product/11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2012-05-30_23-31-36下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (1) :
Patch 13696216 : applied on Wed May 30 22:39:07 CST 2012
Unique Patch ID: 14596729
Patch description: "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Created on 3 Apr 2012, 22:02:51 hrs PST8PDT
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13070939, 13035804, 10350832, 13632717, 13041324, 12919564, 13420224
13742437, 12861463, 12834027, 13742438, 13332439, 13036331, 13499128
12998795, 12829021, 13492735, 9873405, 13742436, 13503598, 12960925
12718090, 13742433, 12662040, 9703627, 12905058, 12938841, 13742434
12849688, 12950644, 13362079, 13742435, 12620823, 12917230, 12845115
12656535, 12764337, 13354082, 12588744, 11877623, 12612118, 12847466
13742464, 13528551, 12894807, 13343438, 12582664, 12780983, 12748240
12797765, 12780098, 13696216, 12923168, 13466801, 13772618, 11063191, 13554409
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oracle11 OPatch]$
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
