最近由于一个项目上的Windows Rac数据库上出现TNS-12531错误，通过查找确认为Bug问题，具体错误如下链接：
http://blog.csdn.net/jyjxs/article/details/9351899
做了一些修改后，还是无法解决该问题，所以决定打补丁，之前写了一个关于Windows上oracle打补丁的实验过程：
http://blog.csdn.net/jyjxs/article/details/9354275
但这次要在RAC上打补丁，还是遇到了一些问题，具体过程如下。
| 名称 | 信息 |
| 系统 | Windows 2008 Enterprise Server |
| 数据库 | 11.2.0.3.0 RAC （x64） |
| 补丁 | patch bandle 26 |
| 补丁号 | 17363850 |
| OPatch utility | 6880880 |
由于本次采用的是 rolling upgrade，所以不需要将整个业务中断，目前我先从第二个节点上进行补丁更新。
一、前期准备的设置，配置相关系统便令并查看相关补丁信息：
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>set PATH=%path%;D:\app\Administrator\product\11.2.0\dbhome_1\perl\bin
C:\Users\Administrator>d:
D:\>set PATH=%path%;d:\app\Administrator\product\11.2.0\dbhome_1\OPatch
D:\>opatch lsinv
Oracle 中间补丁程序安装程序版本 11.2.0.3.5
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : d:\app\ADMINI~1\product\112~1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : d:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgtoollogs\opatch\
opatch2013-12-05_18-07-03下午_1.log
Lsinventory Output file location : d:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgt
oollogs\opatch\lsinv\lsinventory2013-12-05_18-07-03下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
包含多个节点的 RAC 系统
Local node = oradb2
Remote node = oradb1
--------------------------------------------------------------------------------
OPatch succeeded.
二、关闭数据库，在Windows 服务中关闭oracle的后台进程，或者采用命令的方式关闭：
net stop OracleService<SID>net stop OracleDBConsole<SID>net stop OracleJobScheduler<SID>net stop "Oracle <SID> VSS Writer Service"net stop OracleREMExecServicenet stop "Oracle Object Service"net stop ocfs (required only for OCFS installation)net stop OraFenceServicenet stop msdtcnet stop OracleMTSRecoveryService
保留后台的OHASD服务：
先为Grid_home打补丁，设置家目录如下：
D:\17363850>set ORACLE_HOME=D:\app\11.2.0\grid
关闭高可用，解锁oralce相关文件
D:\17363850>%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\rootcrs.pl -unlock
三、更换OPatch utility release 11.2.0.1.9 or later
下载Opatch utility 补丁（6880880），然后更换相关文件即可
利用如下命令查看
%ORACLE_HOME%/OPatch/opatch lsinventory
四、Grid_Home本地化补丁更新
D:\17363850>set ORACLE_HOME=D:\app\11.2.0\grid
D:\17363850>%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\rootcrs.pl -unlock
D:\17363850>opatch apply -local
Oracle 中间补丁程序安装程序版本 11.2.0.3.5
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : D:\app\11.2.0\grid
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : D:\app\11.2.0\grid\cfgtoollogs\opatch\17363850_Dec_05_2013_1
8_16_25\apply2013-12-05_18-16-25下午_1.log
Applying interim patch '17363850' to OH 'D:\app\11.2.0\grid'
Verifying environment and performing prerequisite checks...
Patch 17363850: Optional component(s) missing : [ oracle.precomp.common, 11.2.0.
3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.ntoledb.odp_net_2, 11.2.0
.3.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.3.0 ] , [ oracle.rdbms.oci, 11.2.0.3.0 ]
, [ oracle.ntoramts, 11.2.0.3.0 ] , [ oracle.rdbms.ic, 11.2.0.3.0 ] , [ oracle.
ntoledb, 11.2.0.3.0 ] , [ oracle.ctx, 11.2.0.3.0 ] , [ oracle.odbc.ic, 11.2.0.3.
0 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.agent, 10.2.0.4
.3 ] , [ oracle.rdbms.dv, 11.2.0.3.0 ] , [ oracle.rdbms.hsodbc, 11.2.0.3.0 ] , [
oracle.oraolap.api, 11.2.0.3.0 ] , [ oracle.oraolap, 11.2.0.3.0 ] , [ oracle.sy
sman.oms.core, 10.2.0.4.4 ] , [ oracle.rdbms.tg4db2, 11.2.0.3.0 ] , [ oracle.rdb
ms.tg4ifmx, 11.2.0.3.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.3.0 ] , [ oracle.rdbms
.tg4tera, 11.2.0.3.0 ] , [ oracle.rdbms.scheduler, 11.2.0.3.0 ] , [ oracle.ovm,
11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.marvel,
11.2.0.3.0 ] , [ oracle.xdk, 11.2.0.3.0 ] , [ oracle.idm.oid, 11.2.0.3.0 ] , [ o
racle.owb.rsf, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]
All checks passed.
提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager
并启动它。如果您使用 My Oracle
Support 电子邮件地址/用户名, 操作将更简单。
有关详细信息, 请访问 http://www.oracle.com/support/policies.html。
电子邮件地址/用户名:
尚未提供电子邮件地址以接收有关安全问题的通知。
是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知: Y
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = 'D:\app\11.2.0\grid')
本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
正在为组件 oracle.rdbms, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.plsql, 11.2.0.3.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.3.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rsf.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.common.cvu, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.swd.oui, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.common, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.cvu, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.db, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.crs, 11.2.0.3.0 打补丁...
正在为组件 oracle.usm, 11.2.0.3.0 打补丁...
正在为组件 oracle.usm.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.network.listener, 11.2.0.3.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.ons, 11.2.0.3.0 打补丁...
正在为组件 oracle.install.deinstalltool, 11.2.0.3.0 打补丁...
正在为组件 oracle.sdo.locator, 11.2.0.3.0 打补丁...
正在为组件 oracle.ordim.server, 11.2.0.3.0 打补丁...
正在为组件 oracle.ldap.owm, 11.2.0.3.0 打补丁...
正在为组件 oracle.dbjava.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.cfs, 11.2.0.3.0 打补丁...
Verifying the update...
Patch 17363850 successfully applied
Log file location: D:\app\11.2.0\grid\cfgtoollogs\opatch\17363850_Dec_05_2013_18_16_25\apply2013-12-05_18-16-25下午_1.log
OPatch succeeded.
五、检查Grid_Home补丁结果
C:\Users\Administrator>set ORACLE_HOME=D:\app\11.2.0\grid
C:\Users\Administrator>opatch lsinv
Oracle 中间补丁程序安装程序版本 11.2.0.3.5
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : D:\app\11.2.0\grid
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : D:\app\11.2.0\grid\cfgtoollogs\opatch\opatch2013-12-05_18-32
-45下午_1.log
Lsinventory Output file location : D:\app\11.2.0\grid\cfgtoollogs\opatch\lsinv\l
sinventory2013-12-05_18-32-45下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Grid Infrastructure 11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (1) :
Patch 17363850 : applied on Thu Dec 05 18:18:48 CST 2013
Unique Patch ID: 16948929.1
Patch description: "ORACLE 11G 11.2.0.3 PATCH 26 BUG FOR WINDOWS (64-BIT AMD64
AND INTEL EM64)"
Created on 03 Nov 2013, 00:06:51 hrs PST8PDT
Bugs fixed:
17363850, 12911115, 16605180, 10136473, 13863932, 9876287, 16761566
17346671, 14580303, 17393915, 12738119, 16516883, 17284817, 13413837
16992090, 13853126, 16505333, 16992075, 16101465, 16929165, 16347904
16396856, 13401605, 17468141, 17421340, 13787307, 16187992, 17050888
16710753, 16785708, 13829838, 16470836, 14534823, 14572561, 14176459
16864048, 17397545, 17068448, 13073688, 12989056, 17363845, 17332800
14666138, 16744704, 12784406, 14695377, 14523004, 14351566, 14191508
14188650, 14128555, 14003090, 13843646, 13725395, 13605839, 13483354
13092220, 13072654, 13060271, 12899768, 12821418, 12815057, 12755231
12748538, 12747437, 12744759, 9547706, 9397635, 16710363, 16710324
16344758, 16362358, 16212405, 12796518, 16372203, 17247404, 16836877
16735171, 16684285, 16613232, 16560359, 16170117, 16022372, 15907617
15874565, 14628188, 14525998, 13251609, 13088512, 12903592, 17327041
16444144, 16976121, 16043574, 15947246, 17230530, 14186999, 12861117
16228982, 16819180, 14222244, 16346645, 14400110, 13375884, 14311859
14015403, 13741583, 13443313, 13429702, 16196536, 17036973, 13871316
16921832, 16702016, 16394467, 13387392, 16555614, 13146182, 16821341
11732585, 13254316, 12657924, 12723359, 14143632, 13841623, 14069386
16675990, 16464478, 14525210, 14802958, 17311728, 16568450, 14163397
16547309, 17331386, 17163634, 16809786, 13070166, 17000486, 16931919
12646137, 17025419, 13014707, 9648430, 14010183, 16689009, 12708641
14534809, 13593744, 14095143, 14248496, 15826962, 16554552, 13540118
13960105, 16584663, 14632583, 14791477, 11689699, 16172269, 13910565
16702217, 13616796, 13569887, 12917896, 13371104, 13989379, 17204390
13073625, 16803775, 16694777, 14467061, 16530565, 14571027, 14512189
14053457, 13857111, 13855490, 13814739, 13724193, 13493847, 12925089
12912137, 12755116, 12395918, 7509451, 12940637, 16747736, 14302813
14273397, 14459552, 16703112, 16306019, 16014985, 15905421, 13561750
13791364, 13015379, 6690853 , 16382448, 13774324, 16279401, 16279211
16555186, 16436434, 16077216, 15978267, 15934834, 15920201, 15911134
15856610, 14639430, 13936066, 13912274, 15998768, 13899736, 14010695
16803769, 13639436, 14153464, 11866181, 16571785, 16777700, 10255235
16092378, 16594543, 12621588, 16221484, 16356444, 13492916, 13774313
13651346, 12977562, 13794550, 13569591, 14653968, 14393728, 14692460
15947884, 13499412, 15866631, 15867962, 11769185, 16519867, 16195231
14123213, 13625770, 13880758, 15889476, 13583663, 16774393, 12957306
16223585, 12621554, 12325243, 16002686, 13555551, 13789869, 13529386
13599731, 13446912, 16590638, 16245251, 12596686, 16198581, 14781609
16694441, 14000767, 16596183, 16339328, 16220192, 9864697, 16465101
16578706, 16656151, 14383007, 10131881, 14146298, 14222403, 14182835
16458105, 14107333, 16061956, 14657740, 13454409, 13809288, 13596581
13850256, 12951696, 16023490, 16455998, 9073910, 16212012, 16301888
16009158, 14489591, 13376140, 15857552, 14223541, 14781524, 16235055
16178854, 14355991, 12731763, 14309223, 14158012, 16219072, 16345834
16368108, 16382353, 10242202, 11715084, 13098318, 13496884, 13680405
13812031, 13914613, 14472647, 16175381, 16231699, 16299830, 15880538
16368002, 16268983, 12770551, 16100861, 15883525, 16270093, 14240074
13931044, 9185970, 14340896, 15936160, 16032010, 16206122, 15967792
16026049, 15956068, 15873502, 14589685, 13834436, 16059292, 13481404
14630325, 16042670, 13035320, 16272008, 14147762, 12974860, 12780510
12824731, 13924311, 14710852, 13559697, 14220725, 14841812, 14841558
13596521, 13561951, 13838047, 13943175, 14268365, 14535011, 12704789
12870400, 13011182, 13256955, 13694885, 13745317, 13924910, 13955385
14048512, 14085018, 14212634, 14515980, 14748254, 14773530, 14800989
15917085, 14171552, 16210540, 16307750, 14761411, 14305980, 14496536
16345825, 16344871, 14828235, 14192178, 15951085, 13260060, 13619352
14694818, 14595273, 14318397, 16024441, 11868640, 14044105, 16267272
13527323, 14343501, 15909705, 15982926, 9797851, 12328803, 13650979
11902008, 14675388, 14723910, 14095982, 13489024, 12616197, 16007191
12977043, 16048375, 14588085, 15985756, 14331264, 13362020, 9335975
14127231, 14626717, 16459633, 16318255, 16167942, 15841373, 14252187
13877007, 14249514, 13891981, 12637294, 14511876, 14309075, 13736413
12862170, 13901201, 12819999, 16019955, 15996520, 14775679, 13902963
15924589, 14525739, 14744263, 12838063, 15910002, 14751895, 14107475
13262857, 14641969, 15938047, 15982436, 13924173, 16042648, 13337530
14810890, 13605675, 7335665, 12686027, 16011871, 13729351, 13923995
12813641, 12985237, 14600776, 14565062, 13066936, 14510516, 14192781
14164191, 14505752, 15834269, 13559463, 14702500, 12345305, 14467027
14807785, 14590564, 13849733, 13916549, 14755945, 15869211, 13365021
13972394, 14193629, 14808639, 14189694, 13848402, 14226599, 13621258
13827380, 14762511, 14064573, 13777449, 15848120, 14546673, 14546638
14546575, 14469008, 14263073, 14263036, 14258925, 14205448, 14023636
14035825, 13685544, 14040433, 13593999, 13026410, 12964067, 12873183
12857027, 12345082, 14589750, 14668670, 13791678, 13769577, 13658087
14230270, 13890080, 13810393, 13551402, 14644185, 13686047, 12583611
14488943, 14176879, 13727644, 13517951, 13361350, 14373728, 13602883
13580513, 10219624, 14645769, 14007968, 14827344, 9153183, 15853081
14138130, 14168099, 14810093, 13845120, 14277586, 14271305, 13879428
13938166, 12558569, 10260842, 14569263, 14100232, 13912373, 13653178
14242977, 14102704, 14001941, 13993634, 13634583, 14828076, 13645875
14398795, 13879553, 12940620, 14663556, 12327035, 14207902, 12557401
14653598, 14587310, 14224606, 14577426, 14386985, 13783957, 12656350
11836374, 14485163, 14624988, 14582487, 14332938, 14166276, 14479390
14372670, 14038163, 13535104, 13744724, 14245087, 14305767, 14731193
14313519, 14500723, 12928700, 12571916, 14245825, 13642044, 9706792
13693929, 13903046, 14581922, 14142884, 14393900, 9778542, 13115786
13427062, 14164849, 13399711, 11686700, 14175146, 14499293, 13615767
14625969, 14513934, 14320472, 14613223, 13040943, 12812148, 14360965
13911821, 14140535, 14204172, 13949042, 14367567, 9949330, 14467202
14323857, 13834065, 13632653, 14110275, 13549808, 14196818, 13819727
9751365, 10029609, 11846912, 12646510, 12766337, 12826115, 12860701
12865360, 12973529, 13031176, 13040909, 13061085, 13066239, 13071375
13111783, 13114306, 13345188, 13376866, 13393115, 13406688, 13408107
13433178, 13459147, 13531801, 13553502, 13603792, 13608532, 13622539
13622968, 13738130, 13961338, 14054189, 13851432, 14063422, 13973307
14119388, 14282903, 14517263, 13716797, 14465787, 14613900, 14304758
14251904, 14214257, 14153867, 14009845, 13889047, 13888719, 13820621
13697828, 12663376, 11675721, 12889329, 13410987, 13965075, 13869978
13843080, 13825231, 13582411, 13550689, 13023609, 13000491, 10418841
10317921, 13523527, 13498267, 14096743, 13947200, 14259185, 14280458
14276345, 14543814, 13804294, 13718279, 13612575, 13430938, 13384182
13377816, 13250244, 12794305, 12693626, 12352406, 12879628, 13534412
13524698, 13743987, 14207317, 13918644, 14198511, 14088346, 12791981
13011409, 13038684, 12865902, 12768840, 14076523, 13632809, 14458246
13359289, 12794025, 9952132, 13780816, 12950694, 14162791, 13093358
14255600, 13936424, 14301592, 14050233, 13528725, 14500052, 10146616
14409183, 14324057, 14313389, 5918695, 12430142, 13399435, 13913630
13732226, 10084752, 13591624, 14237793, 14013094, 10229475, 13078786
14052474, 13637058, 12646746, 13000553, 14254795, 14215010, 13922729
13942694, 12898637, 14309390, 13958038, 10214323, 13710236, 14115858
14240544, 14158332, 13073613, 11074304, 13868705, 12723295, 13853654
14074606, 13784384, 14386810, 14223718, 14018752, 13258936, 13723052
12898020, 10625145, 14052871, 13076238, 13992002, 13242070, 12955701
12693573, 14026888, 13984965, 13366199, 13843286, 13616375, 12839247
8547978, 13714926, 13023854, 13910420, 11837095, 12842909, 12959852
13632140, 13780035, 13860201, 13711083, 13628002, 13397104, 12358083
13743357, 13945708, 10384051, 13591484, 13051250, 13727853, 12959627
14095820, 5144934, 13657605, 13582702, 12966665, 13463131, 13773133
12918738, 13099577, 13690409, 13645917, 11708510, 14042380, 13627489
13652437, 12733042, 13907462, 13608299, 13624984, 9095696, 12794090
9706532, 13469158, 13947480, 13555112, 13399236, 12910565, 13790109
12552578, 13896848, 13737746, 13080778, 13458016, 13873885, 12312133
12731940, 12672969, 13355095, 13981051, 13467683, 13457582, 13370330
13340388, 12976376, 12797420, 12658411, 10133521, 9761357, 13827394
13729832, 13851978, 13559770, 13592937, 13592919, 13478856, 13559540
13641696, 13729808, 13632530, 14100237, 11071989, 13786142, 13839641
13041324, 13857364, 13853089, 13806545, 13726162, 13657366, 13617861
13604057, 13483672, 12959140, 12914722, 12910033, 12771830, 13776758
13339443, 12680491, 10114953, 12966774, 13965211, 12424121, 13478060
13786778, 13579992, 13705338, 13603613, 13476583, 12745662, 9190186
13530646, 13520452, 9019231, 13610777, 12905053, 10263668, 13550185
13385346, 13448206, 12772404, 13911711, 11072246, 13104881, 13863326
12889054, 13775960, 13777823, 13464002, 11824898, 13535622, 13916709
12880299, 12918338, 12529945, 13811209, 14058362, 13724808, 13885389
13649031, 13350245, 13553883, 13388104, 13635347, 13404129, 13031118
12530140, 13023541, 13767921, 13787482, 13641076, 13807411, 13724992
12965899, 13791443, 12879027, 13584130, 13495307, 12594032, 13709220
13247965, 13243072, 13683125, 13652493, 12957127, 10215977, 13014128
13040331, 12857222, 12977501, 12664456, 12405931, 13525554, 13492863
13573521, 13873471, 13366268, 13352423, 13460353, 12709476, 13652088
13886023, 13942723, 12919564, 12894807, 12829021, 12612118, 11063191
13503598, 13482688, 13354082, 13484963, 13395403, 13542159, 12983611
13718476, 12846562, 9659614, 13326736, 11846902, 11665727, 13257247
13588248, 13544396, 13566938, 13615517, 13425727, 13037709, 12730342
12349553, 13502441, 13258062, 13251796, 13247273, 12659561, 12639013
12594616, 11772838, 13570057, 12403721, 12585543, 12784549, 12834800
12975771, 13040171, 13058950, 13063120, 13077335, 13365700, 13382280
13384397, 13440516, 13454210, 13457537, 13477790, 13496250, 13501787
13505390, 13506110, 13524899, 13572659, 13594712, 13617627, 13326289
13555974, 13035360, 13420224, 13419660, 13036331, 13332439, 13420174
12583826, 13358781, 11883969, 13524237, 12867713, 13328193, 13516727
11865420, 13502183, 13259364, 13371153, 12998795, 13413168, 12897902
13044108, 12971242, 12834027, 12620823, 13420516, 12849377, 12975811
12646784, 12829429, 12538907, 12950823, 12848480, 12823838, 13366202
13002015, 12834777, 13001901, 13017428, 13082238, 12965049, 11840910
12656535, 12617123, 13073340, 12925041, 12938841, 13023632, 13066371
12942119, 11877623, 12810890, 12995950, 12765467, 12934171, 13070939
12535346, 12985184, 13103913, 12765868, 12622441, 12876314, 12820045
13038806, 13090686, 12923168, 13362079, 12591252, 12718090, 12873909
10350832, 12795861, 13039908, 12976590, 13017584, 12627504, 13263435
12847466, 12797765, 12758736, 12878750, 12861463, 13024624, 12764337
12662040, 13068077, 12914824, 13074261, 12668341, 12597906, 12932852
13045518, 12897651, 12960925, 12728585, 13019958, 12902661, 12886827
12913474, 3522216, 12678920, 12885323, 13334158, 12947871, 12896850
13001955, 12784559, 12827166, 9703627, 12772345, 12905058, 13345868
10357727, 12827493, 13004894, 12780983, 12842804, 13146719, 12655301
12960302, 13085732, 12979199, 12638117, 13357509, 12401111, 12857064
8631856, 13035804, 13355963, 12845115, 12695029, 12990582, 12971775
12867511, 12917230, 12582664, 12849688, 12950644, 12588744, 13011520
12899169, 12823042
包含多个节点的 RAC 系统
Local node = oradb2
Remote node = oradb1
--------------------------------------------------------------------------------
OPatch succeeded.
六、更新Oracle_Home的补丁
的
set ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1
D:\17363850>opatch apply -local
Oracle 中间补丁程序安装程序版本 11.2.0.3.5
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : D:\app\Administrator\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opatch\17363850_Dec_05_2013_19_57_05\apply2013-12-05_19-57-05下午_1.log
Applying interim patch '17363850' to OH 'D:\app\Administrator\product\11.2.0\dbh
ome_1'
Verifying environment and performing prerequisite checks...
Patch 17363850: Optional component(s) missing : [ oracle.precomp.lang, 11.2.0.3.
0 ] , [ oracle.rdbms.tg4msql, 11.2.0.3.0 ] , [ oracle.rdbms.ic, 11.2.0.3.0 ] , [
oracle.has.cvu, 11.2.0.3.0 ] , [ oracle.has.crs, 11.2.0.3.0 ] , [ oracle.usm, 1
1.2.0.3.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.3.0 ] , [ oracle.rdbms.tg4ifmx, 11.2
.0.3.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.3.0 ] , [ oracle.rdbms.tg4tera, 11.2.0
.3.0 ] , [ oracle.rdbms.scheduler, 11.2.0.3.0 ] , [ oracle.has.cfs, 11.2.0.3.0 ]
, [ oracle.idm.oid, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]
All checks passed.
提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager
并启动它。如果您使用 My Oracle
Support 电子邮件地址/用户名, 操作将更简单。
有关详细信息, 请访问 http://www.oracle.com/support/policies.html。
电子邮件地址/用户名:
尚未提供电子邮件地址以接收有关安全问题的通知。
是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知: Y
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = 'D:\app\Administrator\product\11.2.0\dbhome_1')
本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
正在为组件 oracle.rdbms, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.plsql, 11.2.0.3.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.3.0 打补丁...
正在为组件 oracle.ntoledb.odp_net_2, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.3.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.rsf.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.oci, 11.2.0.3.0 打补丁...
正在为组件 oracle.ntoramts, 11.2.0.3.0 打补丁...
正在为组件 oracle.ntoledb, 11.2.0.3.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.3.0 打补丁...
正在为组件 oracle.odbc.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.common.cvu, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.rsf, 11.2.0.3.0 打补丁...
正在为组件 oracle.swd.oui, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.common, 11.2.0.3.0 打补丁...
正在为组件 oracle.has.db, 11.2.0.3.0 打补丁...
正在为组件 oracle.usm.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.3.0 打补丁...
正在为组件 oracle.network.listener, 11.2.0.3.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.3 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.dv, 11.2.0.3.0 打补丁...
正在为组件 oracle.rdbms.hsodbc, 11.2.0.3.0 打补丁...
正在为组件 oracle.ons, 11.2.0.3.0 打补丁...
正在为组件 oracle.install.deinstalltool, 11.2.0.3.0 打补丁...
正在为组件 oracle.oraolap.api, 11.2.0.3.0 打补丁...
正在为组件 oracle.oraolap, 11.2.0.3.0 打补丁...
正在为组件 oracle.sdo.locator, 11.2.0.3.0 打补丁...
正在为组件 oracle.ordim.server, 11.2.0.3.0 打补丁...
正在为组件 oracle.sysman.oms.core, 10.2.0.4.4 打补丁...
正在为组件 oracle.ldap.owm, 11.2.0.3.0 打补丁...
正在为组件 oracle.dbjava.ic, 11.2.0.3.0 打补丁...
正在为组件 oracle.ovm, 11.2.0.3.0 打补丁...
正在为组件 oracle.sysman.repository.core, 10.2.0.4.4 打补丁...
正在为组件 oracle.marvel, 11.2.0.3.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.3.0 打补丁...
正在为组件 oracle.xdk, 11.2.0.3.0 打补丁...
正在为组件 oracle.owb.rsf, 11.2.0.3.0 打补丁...
Verifying the update...
Patch 17363850 successfully applied
Log file location: D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opat
ch\17363850_Dec_05_2013_19_57_05\apply2013-12-05_19-57-05下午_1.log
OPatch succeeded.
七、检查Oracle_Home的补丁成果
D:\17363850>opatch lsinv
Oracle 中间补丁程序安装程序版本 11.2.0.3.5
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : D:\app\Administrator\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2013-12-05_20-37-43下午_1.log
Lsinventory Output file location : D:\app\Administrator\product\11.2.0\dbhome_1\
cfgtoollogs\opatch\lsinv\lsinventory2013-12-05_20-37-43下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (1) :
Patch 17363850 : applied on Thu Dec 05 20:24:46 CST 2013
Unique Patch ID: 16948929.1
Patch description: "ORACLE 11G 11.2.0.3 PATCH 26 BUG FOR WINDOWS (64-BIT AMD64
AND INTEL EM64)"
Created on 03 Nov 2013, 00:06:51 hrs PST8PDT
Bugs fixed:
17363850, 12911115, 16605180, 10136473, 13863932, 9876287, 16761566
17346671, 14580303, 17393915, 12738119, 16516883, 17284817, 13413837
16992090, 13853126, 16505333, 16992075, 16101465, 16929165, 16347904
16396856, 13401605, 17468141, 17421340, 13787307, 16187992, 17050888
16710753, 16785708, 13829838, 16470836, 14534823, 14572561, 14176459
16864048, 17397545, 17068448, 13073688, 12989056, 17363845, 17332800
14666138, 16744704, 12784406, 14695377, 14523004, 14351566, 14191508
14188650, 14128555, 14003090, 13843646, 13725395, 13605839, 13483354
13092220, 13072654, 13060271, 12899768, 12821418, 12815057, 12755231
12748538, 12747437, 12744759, 9547706, 9397635, 16710363, 16710324
16344758, 16362358, 16212405, 12796518, 16372203, 17247404, 16836877
16735171, 16684285, 16613232, 16560359, 16170117, 16022372, 15907617
15874565, 14628188, 14525998, 13251609, 13088512, 12903592, 17327041
16444144, 16976121, 16043574, 15947246, 17230530, 14186999, 12861117
16228982, 16819180, 14222244, 16346645, 14400110, 13375884, 14311859
14015403, 13741583, 13443313, 13429702, 16196536, 17036973, 13871316
16921832, 16702016, 16394467, 13387392, 16555614, 13146182, 16821341
11732585, 13254316, 12657924, 12723359, 14143632, 13841623, 14069386
16675990, 16464478, 14525210, 14802958, 17311728, 16568450, 14163397
16547309, 17331386, 17163634, 16809786, 13070166, 17000486, 16931919
12646137, 17025419, 13014707, 9648430, 14010183, 16689009, 12708641
14534809, 13593744, 14095143, 14248496, 15826962, 16554552, 13540118
13960105, 16584663, 14632583, 14791477, 11689699, 16172269, 13910565
16702217, 13616796, 13569887, 12917896, 13371104, 13989379, 17204390
13073625, 16803775, 16694777, 14467061, 16530565, 14571027, 14512189
14053457, 13857111, 13855490, 13814739, 13724193, 13493847, 12925089
12912137, 12755116, 12395918, 7509451, 12940637, 16747736, 14302813
14273397, 14459552, 16703112, 16306019, 16014985, 15905421, 13561750
13791364, 13015379, 6690853 , 16382448, 13774324, 16279401, 16279211
16555186, 16436434, 16077216, 15978267, 15934834, 15920201, 15911134
15856610, 14639430, 13936066, 13912274, 15998768, 13899736, 14010695
16803769, 13639436, 14153464, 11866181, 16571785, 16777700, 10255235
16092378, 16594543, 12621588, 16221484, 16356444, 13492916, 13774313
13651346, 12977562, 13794550, 13569591, 14653968, 14393728, 14692460
15947884, 13499412, 15866631, 15867962, 11769185, 16519867, 16195231
14123213, 13625770, 13880758, 15889476, 13583663, 16774393, 12957306
16223585, 12621554, 12325243, 16002686, 13555551, 13789869, 13529386
13599731, 13446912, 16590638, 16245251, 12596686, 16198581, 14781609
16694441, 14000767, 16596183, 16339328, 16220192, 9864697, 16465101
16578706, 16656151, 14383007, 10131881, 14146298, 14222403, 14182835
16458105, 14107333, 16061956, 14657740, 13454409, 13809288, 13596581
13850256, 12951696, 16023490, 16455998, 9073910, 16212012, 16301888
16009158, 14489591, 13376140, 15857552, 14223541, 14781524, 16235055
16178854, 14355991, 12731763, 14309223, 14158012, 16219072, 16345834
16368108, 16382353, 10242202, 11715084, 13098318, 13496884, 13680405
13812031, 13914613, 14472647, 16175381, 16231699, 16299830, 15880538
16368002, 16268983, 12770551, 16100861, 15883525, 16270093, 14240074
13931044, 9185970, 14340896, 15936160, 16032010, 16206122, 15967792
16026049, 15956068, 15873502, 14589685, 13834436, 16059292, 13481404
14630325, 16042670, 13035320, 16272008, 14147762, 12974860, 12780510
12824731, 13924311, 14710852, 13559697, 14220725, 14841812, 14841558
13596521, 13561951, 13838047, 13943175, 14268365, 14535011, 12704789
12870400, 13011182, 13256955, 13694885, 13745317, 13924910, 13955385
14048512, 14085018, 14212634, 14515980, 14748254, 14773530, 14800989
15917085, 14171552, 16210540, 16307750, 14761411, 14305980, 14496536
16345825, 16344871, 14828235, 14192178, 15951085, 13260060, 13619352
14694818, 14595273, 14318397, 16024441, 11868640, 14044105, 16267272
13527323, 14343501, 15909705, 15982926, 9797851, 12328803, 13650979
11902008, 14675388, 14723910, 14095982, 13489024, 12616197, 16007191
12977043, 16048375, 14588085, 15985756, 14331264, 13362020, 9335975
14127231, 14626717, 16459633, 16318255, 16167942, 15841373, 14252187
13877007, 14249514, 13891981, 12637294, 14511876, 14309075, 13736413
12862170, 13901201, 12819999, 16019955, 15996520, 14775679, 13902963
15924589, 14525739, 14744263, 12838063, 15910002, 14751895, 14107475
13262857, 14641969, 15938047, 15982436, 13924173, 16042648, 13337530
14810890, 13605675, 7335665, 12686027, 16011871, 13729351, 13923995
12813641, 12985237, 14600776, 14565062, 13066936, 14510516, 14192781
14164191, 14505752, 15834269, 13559463, 14702500, 12345305, 14467027
14807785, 14590564, 13849733, 13916549, 14755945, 15869211, 13365021
13972394, 14193629, 14808639, 14189694, 13848402, 14226599, 13621258
13827380, 14762511, 14064573, 13777449, 15848120, 14546673, 14546638
14546575, 14469008, 14263073, 14263036, 14258925, 14205448, 14023636
14035825, 13685544, 14040433, 13593999, 13026410, 12964067, 12873183
12857027, 12345082, 14589750, 14668670, 13791678, 13769577, 13658087
14230270, 13890080, 13810393, 13551402, 14644185, 13686047, 12583611
14488943, 14176879, 13727644, 13517951, 13361350, 14373728, 13602883
13580513, 10219624, 14645769, 14007968, 14827344, 9153183, 15853081
14138130, 14168099, 14810093, 13845120, 14277586, 14271305, 13879428
13938166, 12558569, 10260842, 14569263, 14100232, 13912373, 13653178
14242977, 14102704, 14001941, 13993634, 13634583, 14828076, 13645875
14398795, 13879553, 12940620, 14663556, 12327035, 14207902, 12557401
14653598, 14587310, 14224606, 14577426, 14386985, 13783957, 12656350
11836374, 14485163, 14624988, 14582487, 14332938, 14166276, 14479390
14372670, 14038163, 13535104, 13744724, 14245087, 14305767, 14731193
14313519, 14500723, 12928700, 12571916, 14245825, 13642044, 9706792
13693929, 13903046, 14581922, 14142884, 14393900, 9778542, 13115786
13427062, 14164849, 13399711, 11686700, 14175146, 14499293, 13615767
14625969, 14513934, 14320472, 14613223, 13040943, 12812148, 14360965
13911821, 14140535, 14204172, 13949042, 14367567, 9949330, 14467202
14323857, 13834065, 13632653, 14110275, 13549808, 14196818, 13819727
9751365, 10029609, 11846912, 12646510, 12766337, 12826115, 12860701
12865360, 12973529, 13031176, 13040909, 13061085, 13066239, 13071375
13111783, 13114306, 13345188, 13376866, 13393115, 13406688, 13408107
13433178, 13459147, 13531801, 13553502, 13603792, 13608532, 13622539
13622968, 13738130, 13961338, 14054189, 13851432, 14063422, 13973307
14119388, 14282903, 14517263, 13716797, 14465787, 14613900, 14304758
14251904, 14214257, 14153867, 14009845, 13889047, 13888719, 13820621
13697828, 12663376, 11675721, 12889329, 13410987, 13965075, 13869978
13843080, 13825231, 13582411, 13550689, 13023609, 13000491, 10418841
10317921, 13523527, 13498267, 14096743, 13947200, 14259185, 14280458
14276345, 14543814, 13804294, 13718279, 13612575, 13430938, 13384182
13377816, 13250244, 12794305, 12693626, 12352406, 12879628, 13534412
13524698, 13743987, 14207317, 13918644, 14198511, 14088346, 12791981
13011409, 13038684, 12865902, 12768840, 14076523, 13632809, 14458246
13359289, 12794025, 9952132, 13780816, 12950694, 14162791, 13093358
14255600, 13936424, 14301592, 14050233, 13528725, 14500052, 10146616
14409183, 14324057, 14313389, 5918695, 12430142, 13399435, 13913630
13732226, 10084752, 13591624, 14237793, 14013094, 10229475, 13078786
14052474, 13637058, 12646746, 13000553, 14254795, 14215010, 13922729
13942694, 12898637, 14309390, 13958038, 10214323, 13710236, 14115858
14240544, 14158332, 13073613, 11074304, 13868705, 12723295, 13853654
14074606, 13784384, 14386810, 14223718, 14018752, 13258936, 13723052
12898020, 10625145, 14052871, 13076238, 13992002, 13242070, 12955701
12693573, 14026888, 13984965, 13366199, 13843286, 13616375, 12839247
8547978, 13714926, 13023854, 13910420, 11837095, 12842909, 12959852
13632140, 13780035, 13860201, 13711083, 13628002, 13397104, 12358083
13743357, 13945708, 10384051, 13591484, 13051250, 13727853, 12959627
14095820, 5144934, 13657605, 13582702, 12966665, 13463131, 13773133
12918738, 13099577, 13690409, 13645917, 11708510, 14042380, 13627489
13652437, 12733042, 13907462, 13608299, 13624984, 9095696, 12794090
9706532, 13469158, 13947480, 13555112, 13399236, 12910565, 13790109
12552578, 13896848, 13737746, 13080778, 13458016, 13873885, 12312133
12731940, 12672969, 13355095, 13981051, 13467683, 13457582, 13370330
13340388, 12976376, 12797420, 12658411, 10133521, 9761357, 13827394
13729832, 13851978, 13559770, 13592937, 13592919, 13478856, 13559540
13641696, 13729808, 13632530, 14100237, 11071989, 13786142, 13839641
13041324, 13857364, 13853089, 13806545, 13726162, 13657366, 13617861
13604057, 13483672, 12959140, 12914722, 12910033, 12771830, 13776758
13339443, 12680491, 10114953, 12966774, 13965211, 12424121, 13478060
13786778, 13579992, 13705338, 13603613, 13476583, 12745662, 9190186
13530646, 13520452, 9019231, 13610777, 12905053, 10263668, 13550185
13385346, 13448206, 12772404, 13911711, 11072246, 13104881, 13863326
12889054, 13775960, 13777823, 13464002, 11824898, 13535622, 13916709
12880299, 12918338, 12529945, 13811209, 14058362, 13724808, 13885389
13649031, 13350245, 13553883, 13388104, 13635347, 13404129, 13031118
12530140, 13023541, 13767921, 13787482, 13641076, 13807411, 13724992
12965899, 13791443, 12879027, 13584130, 13495307, 12594032, 13709220
13247965, 13243072, 13683125, 13652493, 12957127, 10215977, 13014128
13040331, 12857222, 12977501, 12664456, 12405931, 13525554, 13492863
13573521, 13873471, 13366268, 13352423, 13460353, 12709476, 13652088
13886023, 13942723, 12919564, 12894807, 12829021, 12612118, 11063191
13503598, 13482688, 13354082, 13484963, 13395403, 13542159, 12983611
13718476, 12846562, 9659614, 13326736, 11846902, 11665727, 13257247
13588248, 13544396, 13566938, 13615517, 13425727, 13037709, 12730342
12349553, 13502441, 13258062, 13251796, 13247273, 12659561, 12639013
12594616, 11772838, 13570057, 12403721, 12585543, 12784549, 12834800
12975771, 13040171, 13058950, 13063120, 13077335, 13365700, 13382280
13384397, 13440516, 13454210, 13457537, 13477790, 13496250, 13501787
13505390, 13506110, 13524899, 13572659, 13594712, 13617627, 13326289
13555974, 13035360, 13420224, 13419660, 13036331, 13332439, 13420174
12583826, 13358781, 11883969, 13524237, 12867713, 13328193, 13516727
11865420, 13502183, 13259364, 13371153, 12998795, 13413168, 12897902
13044108, 12971242, 12834027, 12620823, 13420516, 12849377, 12975811
12646784, 12829429, 12538907, 12950823, 12848480, 12823838, 13366202
13002015, 12834777, 13001901, 13017428, 13082238, 12965049, 11840910
12656535, 12617123, 13073340, 12925041, 12938841, 13023632, 13066371
12942119, 11877623, 12810890, 12995950, 12765467, 12934171, 13070939
12535346, 12985184, 13103913, 12765868, 12622441, 12876314, 12820045
13038806, 13090686, 12923168, 13362079, 12591252, 12718090, 12873909
10350832, 12795861, 13039908, 12976590, 13017584, 12627504, 13263435
12847466, 12797765, 12758736, 12878750, 12861463, 13024624, 12764337
12662040, 13068077, 12914824, 13074261, 12668341, 12597906, 12932852
13045518, 12897651, 12960925, 12728585, 13019958, 12902661, 12886827
12913474, 3522216, 12678920, 12885323, 13334158, 12947871, 12896850
13001955, 12784559, 12827166, 9703627, 12772345, 12905058, 13345868
10357727, 12827493, 13004894, 12780983, 12842804, 13146719, 12655301
12960302, 13085732, 12979199, 12638117, 13357509, 12401111, 12857064
8631856, 13035804, 13355963, 12845115, 12695029, 12990582, 12971775
12867511, 12917230, 12582664, 12849688, 12950644, 12588744, 13011520
12899169, 12823042
包含多个节点的 RAC 系统
Local node = oradb1
Remote node = oradb2
--------------------------------------------------------------------------------
OPatch succeeded.
八、更换 Oracle Fence driver
利用补丁文件下D:\17363850\files\cfs的OraFencedrv.sys更换C:\Windows\System32\drivers目录下的orafenceservice.sys的文件。
然后将OraFencedrv.sys改名为orafenceservice.sys
启动节点，然后在另一个节点上做同样的事情。自此Windows RAC 下的Bundle Patch Update完毕。经过一个星期后，没有发现bug再现。
实验过程中基本没有遇见过多的问题，主要就是windows本事是个让人挠头的系统，我已经解锁了文件，但个别文件总是被系统占用，通过一些办法总算解决，教训是以后拒绝在Windows上装RAC。
178
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
