11.2.0.3打11.2.0.3.9 PSU

首先升级本机OPatch
[code]csyz:/i3data1/oracle/app/oracle/product/11.2.0/db>./OPatch/opatch version
Invoking OPatch 11.2.0.1.7

OPatch Version: 11.2.0.1.7

OPatch succeeded.
csyz:/i3data1/oracle/app/oracle/product/11.2.0/db>./OPatch/opatch lsinventory
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.


Oracle Home : /i3data1/oracle/app/oracle/product/11.2.0/db
Central Inventory : /home/oracle/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2014-02-28_10-40-34AM.log

Lsinventory Output file location : /i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2014-02-28_10-40-34AM.txt

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

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


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.


csyz:/i3data1/oracle/app/oracle/product/11.2.0/db>mv OPatch OPatch_bak
csyz:/i3data1/oracle/app/oracle/product/11.2.0/db>unzip p6880880_112000_AIX64-5L.zip[/code]
生成响应文件
[code]grid@i3fwq:/precise/grid$pwd
/precise/oracle/app/grid/grid_11203/OPatch/ocm/bin
grid@i3fwq:/precise/grid$ls
emocmrsp
grid@i3fwq:/precise/grid$./emocmrsp
OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.[/code]
切换到root，使用auto方式打补丁
[code][csyz_root:/i3data1/oracle/app/oracle/product/11.2.0/db$./opatch auto /i3data1/grid/soft/psu_17735354 -ocmrf /i3data1/grid/soft/ocm.rsp -oh /i3data1/oracle/app/oracle/product/11.2.0/db
Executing /i3data1/oracle/app/grid/grid_11203/perl/bin/perl /i3data1/oracle/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /i3data1/grid/soft -patchn psu_17735354 -ocmrf /i3data1/grid/soft/ocm.rsp -oh /i3data1/oracle/app/oracle/product/11.2.0/db -paramfile /i3data1/oracle/app/grid/grid_11203/crs/install/crsconfig_params

This is the main log file: /i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2014-02-28_11-00-57.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2014-02-28_11-00-57.report.log

2014-02-28 11:00:57: Starting Oracle Restart Patch Setup
Using configuration parameter file: /i3data1/oracle/app/grid/grid_11203/crs/install/crsconfig_params

Stopping RAC /i3data1/oracle/app/oracle/product/11.2.0/db ...
Stopped RAC /i3data1/oracle/app/oracle/product/11.2.0/db successfully

patch /i3data1/grid/soft/psu_17735354/17592127/custom/server/17592127 apply successful for home /i3data1/oracle/app/oracle/product/11.2.0/db
patch /i3data1/grid/soft/psu_17735354/17540582 apply successful for home /i3data1/oracle/app/oracle/product/11.2.0/db

Starting RAC /i3data1/oracle/app/oracle/product/11.2.0/db ...
Started RAC /i3data1/oracle/app/oracle/product/11.2.0/db successfully

opatch auto succeeded.[/code]
查看当前补丁版本：
[code][csyz_oracle:/home/oracle$opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.


Oracle Home : /i3data1/oracle/app/oracle/product/11.2.0/db
Central Inventory : /home/oracle/app/oracle/oraInventory
from : /i3data1/oracle/app/oracle/product/11.2.0/db/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2014-02-28_11-14-28AM_1.log

Lsinventory Output file location : /i3data1/oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2014-02-28_11-14-28AM.txt

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

Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.


Interim patches (2) :

Patch 17540582 : applied on Fri Feb 28 11:10:27 GMT+08:00 2014
Unique Patch ID: 16985513
Patch description: "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Created on 7 Jan 2014, 04:32:31 hrs PST8PDT
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
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:
14469008, 14301592, 16710324, 13834065, 16703112, 13588248, 16344758
12748538, 13742435, 9659614, 13742434, 13916549, 17333199, 12585543
13742433, 17333197, 17333198, 13742438, 13561951, 13742437, 13742436
12905058, 13503598, 13343438, 14523004, 13080778, 12849688, 14467061
13103913, 13737746, 13742464, 13645917, 13036331, 12656535, 13624984
12678920, 12401111, 17082364, 16742095, 13377816, 13910420, 12913474
13860201, 14497307, 11063191, 13866822, 16306019, 14393728, 12391034
13582702, 12617123, 12923168, 14791477, 16175381, 12646784, 14409183
12583611, 14589750, 12794305, 10350832, 14480674, 14480675, 13680405
14480676, 14095982, 13645875, 13001379, 14351566, 14189694, 12797420
14751895, 13041324, 13385346, 14664355, 13981051, 15862018, 15862017
15862016, 14163397, 14205448, 15862019, 15841373, 15883525, 17343514
16619892, 12791981, 13725395, 14571027, 16844448, 13362079, 13384182
15862020, 15862021, 15862023, 15862022, 15862024, 14053457, 9858539
16761566, 13890080, 12780098, 16024441, 13780035, 14062797, 14052474
14062796, 14062795, 13534412, 14062794, 14062793, 16056266, 14062792
17230530, 17752121, 13550185, 14007968, 12880299, 13551402, 13059165
12612118, 16721594, 9706792, 17761775, 13524899, 12621588, 13657605
14110275, 9873405, 14727310, 13605839, 13043012, 13696216, 13493847
16902043, 13591624, 13065099, 13685544, 14207317, 14546673, 13499128
17088068, 14040433, 14198511, 16299830, 13440516, 14546575, 14207902
16338983, 12662040, 9547706, 16368108, 12718090, 17748834, 17748835
17748832, 13790109, 12959852, 17748833, 17748830, 17748831, 12780983
12912137, 17332800, 12950644, 16372203, 13810393, 13572659, 12731940
12772404, 9797851, 13464002, 14076523, 13358781, 13632809, 13649031
14263073, 10400244, 16279401, 13040943, 13527323, 13492735, 13015379
12395918, 14488943, 13843646, 13332439, 13718279, 6690853, 13616375
11715084, 14273397, 14644185, 13559697, 13448206, 14546638, 12976376
13070939, 11840910, 13723052, 13737888, 15987992, 13430938, 16212405
12865902, 12744759, 10263668, 13476583, 13484963, 15910002, 13554409
14088346, 12960925, 14038787, 12834027, 12764337, 16850197, 13772618
14390252, 14263036, 10133521, 16844086, 13561750, 12815057, 12894807
14841812, 16563678, 13773133, 12829021, 14841558, 17478415, 16344871
12582664, 13632717, 13098318, 12861463, 13913630, 16362358, 16864562
17540582, 13026410, 14188650, 16530565, 12747437, 13457582, 12873183
17333203, 14128555, 13099577, 17333200, 17333202, 14548763, 12693626
13907462, 13855490, 13338048, 12755116, 13489024, 13553883, 11877623
12964067, 14369664, 13250244, 15996344, 15905421, 12847466, 13791364
12797765, 14613900, 14755945, 13038684, 14023636, 13814739, 13035360
14343501, 17019974, 16450169, 13420224, 12857027, 13340388, 11868640
14121009, 12821418, 13972394, 16944698, 14512189, 13584130, 12998795
10242202, 13467683, 12588744, 12594032, 16794238, 16794239, 13787482
13257247, 14841409, 13366202, 13011409, 13326736, 16794243, 16794244
16794241, 16794242, 16794240, 13466801, 9397635, 12899768, 14063281
14063280, 13732226, 16019955, 13719081, 16038929, 8547978, 13642044
13496884, 14220725, 13958038, 9703627, 12940620, 13923995, 13945708
13354082, 14207163, 13579992, 16347904, 13944971, 12345082, 12784406
13060271, 14176879, 16314469, 16314468, 16314467, 16314466, 13502183
11071989, 15869211, 12571991, 13593999, 16294378, 13397104, 13916709
14637368, 13848402, 9761357, 16314470, 13042639, 13936424, 16710363
12898558, 12796518, 12535346, 12974860, 12971775, 14472647, 14398795
16014985, 13686047, 12312133, 13807411, 16382353, 14222403, 12917230
12983611, 13857111, 12938841, 13786142, 14127231, 11708510, 13699124
13705338, 14762511, 12755231, 13596521, 14003090, 12658411, 14262913
14230270, 13724193, 14695377, 16382448, 14035825, 17437634, 12919564
13483354, 13454210, 14258925, 13544396, 13903046, 13923374, 13063120
13370330, 16231699, 13427062, 9095696, 14275605, 14459552, 13911821
13914613, 15853081, 13528551, 13612575, 13072654, 12620823, 14668670
16694777, 14226599, 14138130, 13804294, 12925089, 7509451, 13369579
14383007, 13812031, 13035804, 13092220, 14191508, 13419660, 13399435
16462834, 10625145, 12845115, 13566938, 12748240, 12879027, 16279211, 14318397

Patch 17592127 : applied on Fri Feb 28 11:02:42 GMT+08:00 2014
Unique Patch ID: 17025627
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
Created on 8 Jan 2014, 23:02:20 hrs PST8PDT
Bugs fixed:
17592127, 17076717, 16619898, 16315641, 15876003, 14275572, 13919095
13696251, 13348650, 12659561, 16562733, 14305980, 14277586, 13729298
13987807, 14625969, 16629075, 13825231, 12794268, 13000491, 13498267
15934834, 11675721, 14082976, 12771830, 13906374, 14515980, 14085018
13943175, 14102704, 14171552, 12594616, 13879428, 12897902, 12726222
12829429, 13079948, 13991403, 13090686, 12995950, 13251796, 13582411
14651272, 12903592, 12990582, 13857364, 16747308, 15856610, 13082238
16446410, 12947871, 13256955, 13037709, 14535011, 12878750, 16560359
14048512, 11772838, 13058611, 13001955, 17272731, 13440962, 13727853
13425727, 12885323, 12870400, 16434983, 14212634, 14407395, 13332363
14761411, 13430626, 16346413, 14456069, 13811209, 12709476, 14168708
14096821, 14626717, 13460353, 16206997, 13694885, 12857064, 12899169
13111013, 12558569, 13323698, 16547309, 10260842, 16613232, 13085732
16555186, 14332688, 12928658, 10317921, 17172091, 16077216, 13869978
12914824, 13789135, 12730342, 12950823, 13355963, 13531373, 14268365
13776758, 12720728, 13620816, 14628188, 13023609, 15874565, 16578706
17405302, 16735171, 13024624, 13039908, 14525998, 14385860, 15911134
13036424, 13938166, 15907617, 13011520, 13569812, 12758736, 13001901
13077654, 13430715, 13550689, 13251609, 13806545, 13634583, 14271305
12538907, 13947200, 12996428, 13066371, 17043601, 13483672, 13936066
12897651, 13540563, 12896850, 13241779, 12728585, 12876314, 12925041
12650672, 12398492, 12848480, 13088512, 13652088, 14226134, 16307750
12917897, 12975811, 13653178, 17247404, 13371153, 14800989, 16684285
10114953, 14001941, 11836951, 14179376, 12965049, 14773530, 12765467
16821005, 12950415, 15998768, 13339443, 13965075, 16210540, 14307855
12784559, 14242977, 13955385, 12704789, 16206882, 13745317, 16909409
17305100, 15832129, 13074261, 12971251, 13993634, 13523527, 16876500
13719731, 13396284, 12639013, 12867511, 13989181, 12959140, 16836877
14748254, 13912274, 12829917, 12349553, 12849377, 12934171, 13843080
14496536, 13899736, 13924431, 12680491, 13334158, 15869775, 10418841
12832204, 13838047, 13002015, 14639430, 11822565, 15920201, 12791719



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

OPatch succeeded.[/code]