Oracle PSU （Patch Set Update）- 10g補丁列表及如何檢視補丁

 

對於全新安裝的資料庫，安裝較新的PSU補丁集及CPU補丁都是必要的。

例如 10.2.0.4.x Database PSU 有如下發布，其中最新的是10.2.0.4.5

Patch	PSU Version
	10.2.0.4.5
	10.2.0.4.4
	10.2.0.4.3
	10.2.0.4.2
	10.2.0.4.1

10.2.0.4.5 之前的PSU是累積補丁：

Patch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch. PSU 10.2.0.4.4 includes all fixes previously included in PSU 10.2.0.4.3 。

而10.2.0.4.5 要基於之前的10.2.0.4.4 基礎上來應用：

Patch Set Update PSU 10.2.0.4.5 is an overlay PSU whose base PSU is 10.2.0.4.4. This patch can only be applied in an Oracle home for which PSU 10.2.0.4.4 has already been installed.

安裝這些PSU要確保你的OPatch是足夠新的版本：

You must use the OPatch 10.2 version 10.2.0.4.8 or later to apply this patch. Oracle recommends that you use the latest released OPatch 10.2, which is available for download from My Oracle Support patch by selecting the 10.2.0.0.0 release.   

 

轉載自       

 

 

如何檢視補丁

----------------------------

 

ccptdb$opatch lsinventory
Invoking OPatch 11.2.0.1.3

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

Oracle Home       : /u01/product/oracle
Central Inventory : /u01/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.3
OUI version       : 11.2.0.1.0
OUI location      : /u01/product/oracle/oui
Log file location : /u01/product/oracle/cfgtoollogs/opatch/opatch2010-12-24_08-18-22AM.log

Patch history file: /u01/product/oracle/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/product/oracle/cfgtoollogs/opatch/lsinv/lsinventory2010-12-24_08-18-22AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  9352237      : applied on Fri Dec 24 08:09:58 CST 2010
Unique Patch ID:  12250325
   Created on 25 Mar 2010, 00:05:17 hrs PST8PDT
   Bugs fixed:
     8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
     8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
     7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
     9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
     8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
     8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
     8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
     8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
     8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
     9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
     8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
     8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736

Patch  8730312      : applied on Fri Dec 24 08:01:57 CST 2010
Unique Patch ID:  12177426
   Created on 7 Feb 2010, 06:41:26 hrs PST8PDT
   Bugs fixed:
     8730312

 

--------------------------------------------------------------------------------

OPatch succeeded.
ccptdb$