1.什麼是PSU

PSU(Patch Set Update)簡單講就是多個補丁的集合,它減輕了小版本週期長而帶來的不能及時更新的影響，解決了多個個別補丁衝突和相互影響的問題,同時減輕DBA安裝補丁的負擔,減少補丁安裝次數。

PSU特點

(1)每個PSU(Patch Set Update)修改5位版本號的第5位，如11.2.0.2現在的PSU為11.2.0.2.9,既然是補丁集，那麼每個PSU就包含多個補丁，它作為一個整體進行了嚴格測試，解決各補丁的衝突問題。

(2)PSU定期釋出，PSU不僅包括對功能、效能修復的一般補丁，也包括安全補丁,由於PSU包括同期釋出的CPU(Critical Patch Updates)，只要安裝PSU即可，如同PSR和CPU一樣，

(3)PSU是累積型的，即只要安裝最新的PSU就自動包括以前所有PSU的內容,如安裝11.2.0.2.9就包含了11.2.0.2.1至11.2.0.2.8

Oracle推薦的PSU的版本見[ID 756671.1]

Oracle Recommended Patches -- Oracle Database [ID 756671.1]

以下為本次打11.2.0.2.9的操作日誌

2.先停掉資料庫和監聽

[oracle3@svr7-168 patch]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 15-APR-2013 10:59:08

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=svr7-168)(PORT=1522)))

The command completed successfully

[oracle3@svr7-168 patch]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 15 10:59:16 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

3.下載並解壓PSU

[oracle3@svr7-168 patch]$ unzip p14727315_112020_Linux-x86-64_112029.zip

[oracle3@svr7-168 patch]$ cd 14727315

4.檢查衝突

[oracle3@svr7-168 14727315]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

PREREQ session

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/oracle3/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /opt/software/oracle3/product/11.2.0/oui

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-00-53AM.log

Patch history file: /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

OPatch failed to locate Central Inventory.

Possible causes are:

The Central Inventory is corrupted

The oraInst.loc file specified is not valid.

Prereq "checkConflictAgainstOHWithDetail" is not executed.

The details are:

Exception occured : OPatch failed to locate Central Inventory.

Possible causes are:

The Central Inventory is corrupted

The oraInst.loc file specified is not valid.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Conflicts/Supersets for each patch are:

OPatch succeeded.

5. 如果Inventory不正常或損壞,重建Inventory

根據上面操作日誌顯示,Inventory不正常或損壞,我們再重建Inventory再進行相關的操作

這是一個效能測試環境，可能軟體是從其它機器上面複製過來的，造成了Inventory的損壞或丟失，沒關係，我們重建一下就可以了

(1)檢視Inventory

[oracle3@svr7-168 14727315]$ opatch lsinventory

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/software/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /opt/software/oracle3/product/11.2.0/oui

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-22-21AM.log

Patch history file: /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

List of Homes on this system:

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

Possible causes are:

Oracle Home dir. path does not exist in Central Inventory

Oracle Home is a symbolic link

Oracle Home inventory is corrupted

LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

(2)重建Inventory

修改oraInst.loc為指定的目錄

[oracle3@svr7-168 redo]$ vi /etc/oraInst.loc

inventory_loc=/opt/software/oracle3/oraInventory

inst_group=dba

下面為11g的建立方式

[oracle3@svr7-168 14727315]$ cd /opt/software/oracle3/product/11.2.0/oui/bin/

[oracle3@svr7-168 bin]$ ./attachHome.sh

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /opt/software/oracle3/oraInventory

'AttachHome' was successful.

[oracle3@svr7-168 bin]$

10G和之前版本請使用下面方式重建inventory

下面用實際目錄替換$ORACLE_HOME

cd $ORACLE_HOME/oui/bin

./runInstaller -silent -attachHome ORACLE_HOME="$ORACLE_HOME" ORACLE_HOME_NAME="Ora10gHome"

(3)再次顯示，發現已經正常

[oracle3@svr7-168 14727315]$ opatch lsinventory

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/software/oracle3/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /opt/software/oracle3/product/11.2.0/oui

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-30-01AM.log

Patch history file: /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2013-04-15_11-30-01AM.txt

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

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.2.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

6.再次驗證並apply

(1)驗證衝突,日誌顯示opatch版本太低

[oracle3@svr7-168 14727315]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./

[oracle3@svr7-168 14727315]$ opatch apply

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/software/oracle3/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /opt/software/oracle3/product/11.2.0/oui

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-30-40AM.log

Patch history file: /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

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/oracle3/patch/14727315

Details = PatchObject constructor: Input file "/home/oracle3/patch/14727315/etc/config/actions" or "/home/oracle3/patch/14727315/etc/config/inventory" does not exist.

ApplySession failed: PatchObject constructor: Input file "/home/oracle3/patch/14727315/etc/config/actions" or "/home/oracle3/patch/14727315/etc/config/inventory" does not exist.

System intact, OPatch will not attempt to restore the system

OPatch failed with error code 73

[oracle3@svr7-168 14727315]$

(2)metalink上面下載最新的Opatch,見patch p6880880,選擇相關的版本並下載,

下載後解壓至$ORACLE_HOME中

[oracle3@svr7-168 patch]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle3@svr7-168 patch]$ mv OPatch/ $ORACLE_HOME/

7.再次應用PSU

apply前最好檢查一下衝突,檢查衝突的日誌沒有複製下來

[oracle3@svr7-168 14727315]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./

[oracle3@svr7-168 14727315]$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/software/oracle3/oraInventory

from : /opt/software/oracle3/product/11.2.0/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.2.0

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-57-33AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 13696224 13923804 14275621 14727315

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/opt/software/oracle3/product/11.2.0')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying sub-patch '13696224' to OH '/opt/software/oracle3/product/11.2.0'

ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.2.0...

Patching component oracle.rdbms, 11.2.0.2.0...

Patching component oracle.sysman.console.db, 11.2.0.2.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.3...

Patching component oracle.ldap.rsf, 11.2.0.2.0...

Patching component oracle.rdbms.dv, 11.2.0.2.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...

Patching component oracle.sysman.plugin.db.main.repository, 11.2.0.2.0...

Patching component oracle.rdbms.rman, 11.2.0.2.0...

Patching component oracle.sdo.locator, 11.2.0.2.0...

Patching component oracle.network.rsf, 11.2.0.2.0...

Patching component oracle.precomp.common, 11.2.0.2.0...

Verifying the update...

Applying sub-patch '13923804' to OH '/opt/software/oracle3/product/11.2.0'

Patching component oracle.rdbms.rsf, 11.2.0.2.0...

Patching component oracle.rdbms, 11.2.0.2.0...

Patching component oracle.sysman.console.db, 11.2.0.2.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...

Patching component oracle.rdbms.rman, 11.2.0.2.0...

Patching component oracle.network.rsf, 11.2.0.2.0...

Patching component oracle.network.listener, 11.2.0.2.0...

Verifying the update...

Applying sub-patch '14275621' to OH '/opt/software/oracle3/product/11.2.0'

Patching component oracle.rdbms.rsf, 11.2.0.2.0...

Patching component oracle.rdbms, 11.2.0.2.0...

Patching component oracle.network.client, 11.2.0.2.0...

Patching component oracle.network.rsf, 11.2.0.2.0...

Patching component oracle.precomp.common, 11.2.0.2.0...

Patching component oracle.rdbms.rman, 11.2.0.2.0...

Patching component oracle.rdbms.deconfig, 11.2.0.2.0...

Patching component oracle.rdbms.util, 11.2.0.2.0...

Patching component oracle.dbjava.jdbc, 11.2.0.2.0...

Patching component oracle.dbjava.ic, 11.2.0.2.0...

Verifying the update...

Applying sub-patch '14727315' to OH '/opt/software/oracle3/product/11.2.0'

ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.2.0...

Patching component oracle.rdbms, 11.2.0.2.0...

Patching component oracle.rdbms.rman, 11.2.0.2.0...

Patching component oracle.rdbms.rsf, 11.2.0.2.0...

Patching component oracle.rdbms.util, 11.2.0.2.0...

Patching component oracle.sdo.locator, 11.2.0.2.0...

Patching component oracle.sysman.console.db, 11.2.0.2.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.3...

Verifying the update...

Make failed to invoke "/usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/opt/software/oracle3/product/11.2.0"....'genclntsh: genclntsh: Could not locate /opt/software/oracle3/product/11.2.0/network/admin/shrept.lst

make: *** [client_sharedlib] Error 1

Make failed to invoke "/usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/opt/software/oracle3/product/11.2.0"....'genclntsh: genclntsh: Could not locate /opt/software/oracle3/product/11.2.0/network/admin/shrept.lst

make: *** [client_sharedlib] Error 1

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/opt/software/oracle3/product/11.2.0/precomp/lib/env_precomp.mk:2158: warning: ignoring old commands for target `pcscfg.cfg'

/opt/software/oracle3/product/11.2.0/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/opt/software/oracle3/product/11.2.0/precomp/lib/env_precomp.mk:2158: warning: ignoring old commands for target `pcscfg.cfg'

The following make actions have failed :

Re-link fails on target "client_sharedlib".

Do you want to proceed? [y|n]

y

User Responded with: Y

Composite patch 14727315 successfully applied.

OPatch Session completed with warnings.

Log file location: /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_11-57-33AM_1.log

OPatch completed with warnings.

上面補丁已經打成功，現在需要更新相關係統檢視

[oracle3@svr7-168 14727315]$ cd $ORACLE_HOME/rdbms/admin

sqlplus "/as sysdba"

SQL> startup

SQL> @catbundle.sql psu apply

SQL> quit

8.檢視相關的補丁和PSU情況

[oracle3@svr7-168 10220118]$ opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Oracle Home : /opt/software/oracle3/product/11.2.0

Central Inventory : /opt/software/oracle3/oraInventory

from : /opt/software/oracle3/product/11.2.0/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.2.0

Log file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/opatch2013-04-15_13-21-28PM_1.log

Lsinventory Output file location : /opt/software/oracle3/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2013-04-15_13-21-28PM.txt

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

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 10220118 : applied on Mon Apr 15 13:18:11 CST 2013

Unique Patch ID: 15991767

Created on 19 Feb 2013, 02:57:52 hrs PST8PDT

Bugs fixed:

10220118

This patch overlays patches:

14727315

This patch needs patches:

14727315

as prerequisites

Patch 14727315 : applied on Mon Apr 15 12:04:17 CST 2013

Unique Patch ID: 15682618

Patch description: "Database Patch Set Update : 11.2.0.2.9 (14727315)"

Created on 3 Jan 2013, 02:38:30 hrs PST8PDT

Sub-patch 14275621; "Database Patch Set Update : 11.2.0.2.8 (14275621)"

Sub-patch 13923804; "Database Patch Set Update : 11.2.0.2.7 (13923804)"

Sub-patch 13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"

Bugs fixed:

13080778, 10114837, 10373381, 14461358, 10035737, 12737666, 11065646

13769501, 12639234, 12586495, 10630870, 12880299, 9715581, 10218814

9860769, 10332111, 15896431, 14263036, 10367188, 12830339, 14263073

9651350, 12586489, 11683713, 14107388, 10097711, 12950644, 10113990

12370722, 12586491, 12899768, 15896427, 9414040, 14613900, 9373370

11724916, 13769503, 9578670, 10285022, 10399808, 11877623, 10248523

12586493, 9972680, 10092858, 12546006, 12797765, 12586487, 13769509

11830777, 10055063, 10648873, 10419984, 10077191, 11063191, 10220033

11858315, 11061775, 9478199, 12649442, 12326708, 11708510, 10127360

11734067, 10396041, 10190642, 13737746, 10396874, 10233732, 10209232

12595561, 9956835, 11666137, 10061015, 9672816, 11695416, 9744252

10620808, 9858539, 11694127, 11894889, 9382956, 10204358, 12713993

10080579, 12764337, 11738259, 10084145, 10363186, 12670165, 10324294

14107384, 10158493, 10155605, 10013177, 13343424, 11686968, 10013431

14546575, 12586496, 11674485, 13476583, 9877980, 10126822, 10284570

10329146, 10326338, 15896429, 11064851, 11063821, 12655433, 10314582

10051315, 12326246, 10332589, 13467683, 10368698, 12586486, 9724970

13769507, 11815753, 9905049, 10053725, 12834027, 10229886, 9869287

9735237, 9896536, 12846268, 9912965, 12794305, 10022980, 14546673

13503598, 11695285, 12595730, 13399435, 13343244, 14023636, 12371955

12633340, 13257247, 10039731, 11674898, 13769505, 9824435, 6892311

11841309, 10031806, 12894807, 11076894, 10170431, 12748240, 9965655

12323180, 12531263, 10219583, 12417369, 12419331, 9539440, 10622001

14107385, 10227288, 11867127, 10258337, 11814891, 10228393, 10621169

9847634, 8547978, 15896435, 10159846, 10142857, 10187168, 10269503

10395345, 12596444, 9564886, 10373013, 11785938, 10213073, 11827088

10302581, 12569482, 10278372, 14546638, 9795214, 12397410, 9707965

9443361, 10210507, 10126094, 10073683, 10172453, 11811073, 10230571

12419321, 12656535, 10312847, 9943960, 10052141, 12408350, 13250244

9903826, 12409916, 11056082, 10026601, 12420002, 8685446, 8223165

9401552, 12780098, 10094823, 11716621, 12589039, 14390377, 10228151

10623249, 10356513, 12345717, 11057263, 11856395, 11775474, 11670161

15896433, 11924400, 14841437, 10094201, 10378005, 10115630, 9835264

10422126, 10021111, 14258925, 11818335, 10281887, 11707302, 10140809

10317487, 12586488, 10322959, 9727147, 10151017, 13386082, 11706168

10245086, 14469008, 10205230, 10158965, 11937253, 11733179, 9829397

10278773, 14107387, 11882425, 10419629, 12586494, 12337012, 12848798

10388660, 9788588, 10239480, 6523037, 10417716, 9842573, 12879027

11883472, 12586492, 10200404, 10232083, 12685431, 9881076, 14275621

10157402, 9709292, 11830778, 14461357, 10207092, 12586490, 11800170

9683047, 12391602, 14262913, 10417216, 10635701, 9869401, 10157249

10131867, 13632725, 9970255, 14683459, 13468884, 15896428, 11830776

10633840, 12976376, 11695333, 10200390, 10142909, 13326736, 10237773

12366627, 7312717, 10019218, 11664046, 9233544, 12569737, 14107389

13001379, 13099577, 10222719, 9873405, 11834448, 9819805, 11872103

10165083, 13769502, 10193846, 10285394, 11715084, 12827726, 9375300

14040433, 11723722, 10264696, 10264680, 13769508, 11842991, 12845115

14473913, 9436324, 10358019, 10089333, 14741727, 14038791, 13550185

10175192, 8672862, 10207551, 9956713, 12639177, 11853815, 14461356

10180307, 10048701, 12828071, 10079168, 12423475, 13923804, 9771278

10356782, 14127510, 13769506, 10229719, 12340939, 9966609, 11651810

14035825, 9078442, 10137324, 13769504, 10219576, 12378147, 10217802

10142788, 10129643, 12400751, 12539000, 11724984, 9735282, 10040921

9591812, 9906422, 9746210, 12917230, 9770451, 10021022, 12846269

10110863, 12579349, 11067567, 10411618, 11699057, 10425676, 13916709

12635537, 14076523, 11707699, 9895207, 11890804, 10299224, 10018789

14205448, 9926929, 11800854, 11866952, 14467061, 10384285, 10636231

11069199, 11689702, 14624146, 10427260, 10324526, 13696224, 12543639

11690639, 9285259, 10284838, 10082277, 9952554, 9470768, 15896430

11785390, 10310299, 10412247, 12313857, 12431716, 14107386, 10102506

10238786, 10132870, 10247152, 9953542, 14727315, 9572787, 15896434

11800959, 13769510, 10052956, 12374212, 10040531, 15896432, 9681133

10190172, 11878443, 10040035, 12620422, 10171273, 11893621, 10249791

11788856, 11664719, 9748749, 13554409, 11889177

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

OPatch succeeded.

9.啟動監聽

[oracle3@svr7-168 10220118]$ lsnrctl start

PSU簡介和11.2.0.2.9 PSU補丁操作日誌

相關文章