DB and RAC(11.2.0.3 ) Patch Set Update(11.2.0.3.6 )
现在是2013年05月29日，Oracle最新的PSU为11.2.0.3.6,本次升级为RAC和DB分别进行升级，为日后的RAC+DG环境做准备。
系统:linux 5.7 x86_64
数据库版本：11.2.0.3.0
单机升级ORACLE
首先升级单机的DB到11.2.0.3.6：
下载11.2.0.3.6的补丁包，补丁编号为16056266。
1.1 检查补丁冲突
用oracle用户unzip补丁包到ORACLE_HOME目录下。
[oracle@bogon db_1]$ cd 16056266/
[oracle@localhost 16056266]$ ../OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11g/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11g/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-27_11-00-06AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
1.2 检查当前数据库补丁历史
SQL> select action,comments from registry$history;
ACTION
------------------------------
COMMENTS
--------------------------------------------------------------------------------
APPLY
Patchset 11.2.0.2.0
APPLY
Patchset 11.2.0.2.0
1.3 应用补丁进行升级
--升级前将数据库，监听及sqlplus都退出，否则在前置检查的时候会报错。
[oracle@bogon 16056266]$ ../OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11g/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11g/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266
Do you want to proceed? [y|n]
Y
--单机PSU可以不需要MOS账号
Composite patch 16056266 successfully applied.
UtilSession: N-Apply done.
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67215:
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'
/u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11g/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
--------------------------------------------------------------------------------
OUI-67008:OPatch Session completed with warnings.
Finishing UtilSession at Tue May 28 11:10:43 CST 2013
Log file location: /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
--虽然有告警，但依然安装成功
1.4 检查升级（PSU)后的版本
--查看当前补丁版本
[oracle@localhost OPatch]$ ./opatch lspatches
16056266;Database Patch Set Update : 11.2.0.3.6 (16056266)
--查看当前补丁详细信息
[oracle@localhost OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11g/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11g/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-33-02AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-05-28_11-33-02AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 16056266 : applied on Tue May 28 11:09:50 CST 2013
Unique Patch ID: 15962803
Patch description: "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Created on 12 Mar 2013, 02:14:47 hrs PST8PDT
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13566938, 13593999, 10350832, 14138130, 12919564, 13561951, 13624984
13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875
14472647, 12880299, 14664355, 14409183, 12998795, 14469008, 13719081
13492735, 13496884, 12857027, 14263036, 14263073, 13732226, 13742433
16368108, 16314469, 12905058, 13742434, 12849688, 12950644, 13742435
13464002, 13534412, 12879027, 13958038, 14613900, 12585543, 12535346
12588744, 11877623, 13786142, 12847466, 13649031, 13981051, 12582664
12797765, 14262913, 12923168, 13384182, 13612575, 13466801, 13484963
14207163, 11063191, 13772618, 13070939, 12797420, 13041324, 16314467
16314468, 12976376, 11708510, 13680405, 14589750, 13026410, 13742437
13737746, 14644185, 13742438, 13326736, 13596521, 13001379, 16344871
13099577, 9873405, 14275605, 13742436, 9858539, 14841812, 11715084
16231699, 14040433, 12662040, 9703627, 12617123, 12845115, 12764337
13354082, 14459552, 13397104, 13913630, 12964067, 12983611, 13550185
13810393, 12780983, 12583611, 14546575, 13476583, 15862016, 11840910
13903046, 15862017, 13572659, 16294378, 13718279, 14088346, 13657605
13448206, 16314466, 14480676, 13419660, 13632717, 14063281, 14110275
13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784
13616375, 14035825, 12861463, 12834027, 15862021, 13632809, 13377816
13036331, 14727310, 13685544, 15862018, 13499128, 16175381, 13584130
12829021, 15862019, 12794305, 14546673, 12791981, 13787482, 13503598
10133521, 12718090, 13399435, 14023636, 13860201, 12401111, 13257247
13362079, 14176879, 12917230, 13923374, 14220725, 14480675, 13524899
13559697, 9706792, 14480674, 13916709, 13098318, 13773133, 14076523
13340388, 13366202, 13528551, 12894807, 13454210, 13343438, 12748240
14205448, 13385346, 15853081, 14273397, 12971775, 13582702, 10242202
13035804, 13544396, 16382353, 8547978, 14226599, 14062795, 13035360
12693626, 13332439, 14038787, 14062796, 12913474, 14841409, 14390252
16314470, 13370330, 13059165, 14062797, 14062794, 12959852, 13358781
12345082, 12960925, 9659614, 13699124, 14546638, 13936424, 13338048
12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684
14062792, 13807411, 13250244, 12594032, 15862022, 9761357, 12612118
13742464, 14052474, 13911821, 13457582, 13527323, 15862020, 13910420
13502183, 12780098, 13705338, 13696216, 14841558, 10263668, 15862023
16056266, 15862024, 13554409, 13645917, 13103913, 13011409, 14063280
--------------------------------------------------------------------------------
OPatch succeeded.
./opatch lsinventory -detail --补丁详细信息查看
1.5 将升级信息载入数据库
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT