Apply 11.2.0.2.5 Failed ?
本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
本文链接地址: Apply 11.2.0.2.5 Failed ?
1 2 |
2012/1/18 oracle发布了11.2.0.2的最新psu 11.2.0.2.5,其中Grid Infrastructure 的补丁号为13343447,其实该补丁中已经包含了db的补丁13343438,如下: |
1 2 3 4 5 6 7 8 9 10 11 12 |
[ora11g@11gr2test install]$ ls -ltr total 242072 drwxrwxr-x 8 ora11g oinstall 4096 Oct 3 20:51 OPatch drwxr-xr-x 5 ora11g oinstall 4096 Oct 14 22:43 12827731 drwxrwxr-x 4 ora11g oinstall 4096 Oct 30 06:28 12827726 -rw-r--r-- 1 ora11g oinstall 21 Jan 15 22:47 README.txt -rw-r--r-- 1 ora11g oinstall 422 Jan 15 22:47 bundle.xml drwxr-xr-x 5 ora11g oinstall 4096 Jan 15 22:47 13343447 drwxr-xr-x 4 ora11g oinstall 4096 Jan 15 22:47 13343424 -rw-rw-r-- 1 ora11g oinstall 145475 Jan 16 05:47 README.html -rw-r--r-- 1 ora11g oinstall 247415079 Jan 19 05:03 p13343447_112020_LINUX.zip [ora11g@11gr2test install]$ |
1 2 3 |
我这里是oracle restart环境,何为restart呢?简单的说,oracle推出这个特性也有 取代传统的HA环境之意吧,个人猜测。11gR2中的restart 其实是10g的single instance HA 的升级版本,当然确实更强悍了,虽然有HA之意,但是仍然无法避免主机层面的故障。 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
如下是我的apply 步骤: 通常我们在apply psu或one-off patch之前都建议check下是否存在冲突的patch,如下: [ora11g@11gr2test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/ora11g/install/13343447 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /home/ora11g/product/11.2/db Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-12-52PM.log Invoking prereq "checkconflictagainstohwithdetail" ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves. Prereq "checkConflictAgainstOHWithDetail" failed. Summary of Conflict Analysis: Patches that can be applied now without any conflicts are : 13343447 Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list : 12827731 Following patches will be rolled back from Oracle Home on application of the patches in the given list : 12827731 Conflicts/Supersets for each patch are: Patch : 13343447 Bug Superset of 12827731 Super set bugs are: 12827731, 10157506, 10178670, 10425672, 12311357, 12419353, 9979706, 9959110, 10016083, 10015460, 10014392, 9918485, 10157622, 10089120, 10057296, 9971646, 10053985, 10040647, 9978765, 9864003, 10069541, 10110969, 10107380, 9915329, 10044622, 10029119, 9812970, 10083009, 9812956, 10048027, 10036193, 10008467, 10040109, 10015210, 10083789, 10033106, 10073372, 9876201, 10042143, 9963327, 9679401, 10062301, 10018215, 10075643, 10007185, 10071992, 10057680, 10038791, 10124517, 10048487, 10078086, 9926027, 10052721, 9944948, 10028235, 10146768, 10011084, 10027079, 10028343, 10045436, 9907089, 10073075, 10175855, 10072474, 10036834, 9975837, 10028637, 10029900, 9949676 OPatch succeeded. [ora11g@11gr2test OPatch]$ 下面开始安装11.2.0.2.5: |
1 2 3 4 5 6 7 8 9 10 11 |
1. Stop dbconsole /home/ora11g/product/11.2/db/bin/emctl stop dbconsole 2. Stop the CRS managed resources running from DB homes /home/ora11g/product/11.2/db/bin/srvctl stop home -o /home/ora11g/product/11.2/db -s /home/ora11g/1120205.log 执行结果: [ora11g@11gr2test ~]$ /home/ora11g/product/11.2/db/bin/srvctl stop home -o /home/ora11g/product/11.2/db -s /home/ora11g/1120205.log [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 9 10 11 |
3. Run the pre root script /home/ora11g/11.2/grid/crs/install/roothas.pl -unlock 执行结果: [root@11gr2test ~]# id uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel) context=root:system_r:unconfined_t:SystemLow-SystemHigh [root@11gr2test ~]# /home/ora11g/11.2/grid/crs/install/roothas.pl -unlock Using configuration parameter file: /home/ora11g/11.2/grid/crs/install/crsconfig_params Successfully unlock /home/ora11g/11.2/grid [root@11gr2test ~]# |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 |
4. Apply the CRS patch using As the GI home owner execute: /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/13343447 --执行结果: [root@11gr2test ~]# su - ora11g [ora11g@11gr2test ~]$ id uid=502(ora11g) gid=501(oinstall) groups=501(oinstall),502(dba) context=root:system_r:unconfined_t:SystemLow-SystemHigh [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/13343447 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/11.2/grid Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-23-27PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343447 Bug Superset of 12827731 Super set bugs are: 12827731, 10157506, 10178670, 10425672, 12311357, 12419353, 9959110, 10272615, 10314123, 10014392, 10089120, 10057296, 11692271, 9864003, 11775080, 9916145, 12695202, 10044622, 12767231, 12399977, 12421404, 12862012, 12340700, 10056713, 10637741, 9939306, 9795321, 9902536, 10007185, 10376847, 10038791, 11741224, 12823479, 11655840, 10048487, 10322157, 11768599, 10260251, 10052721, 10028235, 10027079, 12412303, 10357258, 11871469, 10045436, 10231906, 10622973, 9891341, 10072474, 10036834, 10029900, 9974223, 10161846, 10016083, 12597463, 9918485, 11781515, 10040647, 12651595, 12345151, 11925641, 10069541, 10029119, 10233159, 12332919, 9812956, 10036193, 10015210, 12424479, 12340501, 10621175, 11877079, 8906163, 10111010, 12366642, 11777648, 10115514, 10104377, 10057680, 10280665, 10078086, 9944948, 10146768, 10052529, 10011084, 10012319, 10073075, 10233811, 10299006, 12426375, 10248739, 10236074, 10128191, 11071429, 10019726, 9975837, 10253630, 12615394, 10420872, 9949676, 11936945, 11820787, 10637483, 12677816, 10157622, 11698552, 10385838, 10053985, 10229297, 10425674, 9812970, 11828633, 12359585, 11899801, 10083789, 9876201, 10073372, 9963327, 10428946, 11077756, 10375649, 9336825, 11682409, 10062301, 12767563, 12546712, 10018215, 10105195, 10419987, 10071992, 11807012, 10634513, 9926027, 10103954, 12743755, 12406573, 10028343, 11768055, 11866171, 10065216, 9907089, 9897335, 10190153, 11744313, 10175855, 12600343, 12422324, 10284828, 10028637, 10361177, 12800501, 9979706, 10324594, 10015460, 11818524, 9971646, 11782423, 11654726, 9978765, 10398810, 11904778, 10397652, 9915329, 10107380, 10110969, 10305361, 10331452, 10083009, 10631693, 10008467, 10048027, 10040109, 9944978, 10370797, 10033106, 12700217, 11840629, 10042143, 9978195, 10284693, 12639016, 10638381, 11839004, 9679401, 11663339, 10075643, 11834289, 9458055, 10205290, 10124517, 12680491, 11069614, 9593552, 10168006, 11846686, 9867867, 12645334, 10228079, 10015603, 10241696, 9942881, 10252497, 10283058, 12724761, 10157625, 10283167, 9906432, 10216878, 10045316, 10425675, 10061534, 11789566, 10283549, 12700050, 12732899, 10311856, 10150020, 12433819, 12421420, 12681864, 12378675, 10113899, 12614853, 12694821, 10069698, 9861790, 10087118, 10056808, 12433511, 10146744, 10326548, 10019796, 9975343, 9936659, 10244210, 10029794, 10266447, 10193581, 12318560, 11804097, 10070563, 11058691, 10268642, 12862020, 12747467, 10283596, 12594736, 12591990 Patches [ 12827731 ] will be rolled back. Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343447 Do you want to proceed? [y|n] y User Responded with: Y Prerequisite check "CheckSystemSpace" failed. The details are: <span style="color: #ff0000">Required amount of space(3084990246) is not available. </span>UtilSession failed: Prerequisite check "CheckSystemSpace" failed. Log file location: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-23-27PM.log OPatch failed with error code 73 [ora11g@11gr2test ~]$ [ora11g@11gr2test ~]$ [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/13343447 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/11.2/grid Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-29-04PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343447 Bug Superset of 12827731 Super set bugs are: 12827731, 10157506, 10178670, 10425672, 12311357, 12419353, 9959110, 10272615, 10314123, 10014392, 10089120, 10057296, 11692271, 9864003, 11775080, 9916145, 12695202, 10044622, 12767231, 12399977, 12421404, 12862012, 12340700, 10056713, 10637741, 9939306, 9795321, 9902536, 10007185, 10376847, 10038791, 11741224, 12823479, 11655840, 10048487, 10322157, 11768599, 10260251, 10052721, 10028235, 10027079, 12412303, 10357258, 11871469, 10045436, 10231906, 10622973, 9891341, 10072474, 10036834, 10029900, 9974223, 10161846, 10016083, 12597463, 9918485, 11781515, 10040647, 12651595, 12345151, 11925641, 10069541, 10029119, 10233159, 12332919, 9812956, 10036193, 10015210, 12424479, 12340501, 10621175, 11877079, 8906163, 10111010, 12366642, 11777648, 10115514, 10104377, 10057680, 10280665, 10078086, 9944948, 10146768, 10052529, 10011084, 10012319, 10073075, 10233811, 10299006, 12426375, 10248739, 10236074, 10128191, 11071429, 10019726, 9975837, 10253630, 12615394, 10420872, 9949676, 11936945, 11820787, 10637483, 12677816, 10157622, 11698552, 10385838, 10053985, 10229297, 10425674, 9812970, 11828633, 12359585, 11899801, 10083789, 9876201, 10073372, 9963327, 10428946, 11077756, 10375649, 9336825, 11682409, 10062301, 12767563, 12546712, 10018215, 10105195, 10419987, 10071992, 11807012, 10634513, 9926027, 10103954, 12743755, 12406573, 10028343, 11768055, 11866171, 10065216, 9907089, 9897335, 10190153, 11744313, 10175855, 12600343, 12422324, 10284828, 10028637, 10361177, 12800501, 9979706, 10324594, 10015460, 11818524, 9971646, 11782423, 11654726, 9978765, 10398810, 11904778, 10397652, 9915329, 10107380, 10110969, 10305361, 10331452, 10083009, 10631693, 10008467, 10048027, 10040109, 9944978, 10370797, 10033106, 12700217, 11840629, 10042143, 9978195, 10284693, 12639016, 10638381, 11839004, 9679401, 11663339, 10075643, 11834289, 9458055, 10205290, 10124517, 12680491, 11069614, 9593552, 10168006, 11846686, 9867867, 12645334, 10228079, 10015603, 10241696, 9942881, 10252497, 10283058, 12724761, 10157625, 10283167, 9906432, 10216878, 10045316, 10425675, 10061534, 11789566, 10283549, 12700050, 12732899, 10311856, 10150020, 12433819, 12421420, 12681864, 12378675, 10113899, 12614853, 12694821, 10069698, 9861790, 10087118, 10056808, 12433511, 10146744, 10326548, 10019796, 9975343, 9936659, 10244210, 10029794, 10266447, 10193581, 12318560, 11804097, 10070563, 11058691, 10268642, 12862020, 12747467, 10283596, 12594736, 12591990 <span style="color: #ff0000">Patches [ 12827731 ] will be rolled back. </span> Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343447 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/home/ora11g/11.2/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '13343447' to OH '/home/ora11g/11.2/grid' Rolling back interim patch '12827731' from OH '/home/ora11g/11.2/grid' Patching component oracle.crs, 11.2.0.2.0... Patching component oracle.usm, 11.2.0.2.0... RollbackSession removing interim patch '12827731' from inventory OPatch back to application of the patch '13343447' after auto-rollback. Patching component oracle.crs, 11.2.0.2.0... Copying file to "/home/ora11g/11.2/grid/crs/install/crsconfig_lib.pm" Copying file to "/home/ora11g/11.2/grid/crs/install/crspatch.pm" Copying file to "/home/ora11g/11.2/grid/crs/install/s_crsconfig_lib.pm" Patching component oracle.usm, 11.2.0.2.0... Patches 13343447 successfully applied. OPatch Session completed with warnings. Log file location: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-29-04PM.log OPatch completed with warnings. [ora11g@11gr2test ~]$ As the GI home owner execute: /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/13343424 --执行结果: [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/13343424 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/11.2/grid Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-39-35PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343424 Bug Superset of 12827726 Super set bugs are: 10158965, 10031806, 12635537, 9746210, 9744252, 9956713, 10356513, 10204358, 10378005, 10170431, 11853815, 10222719, 12639177, 9591812, 10127360, 9443361, 10035737, 10384285, 12846268, 9873405, 12846269, 11069199, 12670165, 10245086, 10159846, 10205230, 10052141, 10039731, 11818335, 12371955, 10040921, 12366627, 10077191, 11827088, 11785938, 10219576, 10258337, 11707699, 10264680, 10094823, 10209232, 11695333, 9881076, 10278372, 10281887, 10621169, 10048701, 9078442, 11057263, 10157249, 9735237, 10317487, 10219583, 10636231, 10310299, 11065646, 10055063, 10368698, 12340939, 10079168, 10233732, 8223165, 10264696, 10142909, 9953542, 10052956, 10080579, 11699057, 12620422, 10285022, 10329146, 10332589, 11666137, 10110863, 9869401, 12828071, 10019218, 10229719, 9539440, 10373381, 11724984, 10239480, 10411618, 11670161, 9724970, 10399808, 10113990, 10312847, 11893621, 10084145, 10367188, 11800170, 11695285, 10285394, 10157402, 9651350, 10299224, 10151017, 11724916, 10190642, 12586486, 9564886, 12586487, 10129643, 12586488, 12586489, 10018789, 10248523, 9715581, 9770451, 11889177, 10425676, 9683047, 10180307, 10126094, 10396041, 10132870, 10094201, 10193846, 11664046, 10324294, 9414040, 12586490, 9819805, 12586491, 9795214, 12586492, 12586493, 12586494, 10142788, 12586495, 11830776, 9905049, 11674898, 10419984, 12586496, 11830777, 6892311, 11830778, 10358019, 12431716, 10422126, 10200404, 11651810, 10102506, 11067567, 12827726, 11733179, 10229886, 10040531, 10155605, 10326338, 10356782, 10082277, 10051315, 10218814, 9788588, 10278773, 12326246, 10622001, 11707302, 10230571, 9966609, 12419321, 12546006, 10137324, 9771278, 10013431, 10228151, 10324526, 11894889, 10238786, 10217802, 10061015, 9572787, 10332111, 10227288, 10623249, 10073683, 12639234, 11664719, 9735282, 9748749, 10022980, 10237773, 11800854, 12419331, 11674485, 10097711, 10187168, 6523037, 10648873, 10053725, 8685446 <span style="color: #ff0000">Patches [ 12827726 ] will be rolled back. </span> Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343424 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/home/ora11g/11.2/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '13343424' to OH '/home/ora11g/11.2/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] , [ oracle.rdbms.dv, 11.2.0.2.0 ] , [ oracle.sysman.plugin.db.main.repository, 11.2.0.2.0 ] , [ oracle.network.cman, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found. Rolling back interim patch '12827726' from OH '/home/ora11g/11.2/grid' Patching component oracle.rdbms.rsf, 11.2.0.2.0... Patching component oracle.rdbms, 11.2.0.2.0... Patching component oracle.ldap.rsf, 11.2.0.2.0... Deleting "ssl_getconnectionrenegotiationoptions.o" from archive "/home/ora11g/11.2/grid/lib/libnnz11.a" Deleting "ssl_getrenegotiationoptions.o" from archive "/home/ora11g/11.2/grid/lib/libnnz11.a" Deleting "ssl_hshk_priv_dooptionsallowrenegotoation.o" from archive "/home/ora11g/11.2/grid/lib/libnnz11.a" Deleting "ssl_modifyrenegotiationoptions.o" from archive "/home/ora11g/11.2/grid/lib/libnnz11.a" Deleting "ssl_setrenegotiationoptions.o" from archive "/home/ora11g/11.2/grid/lib/libnnz11.a" Patching component oracle.rdbms.dbscripts, 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... RollbackSession removing interim patch '12827726' from inventory OPatch back to application of the patch '13343424' after auto-rollback. Patching component oracle.rdbms.rsf, 11.2.0.2.0... Patching component oracle.rdbms, 11.2.0.2.0... Copying file to "/home/ora11g/11.2/grid/psu/11.2.0.2.5/catpsu.sql" Copying file to "/home/ora11g/11.2/grid/psu/11.2.0.2.5/catpsu_rollback.sql" Copying file to "/home/ora11g/11.2/grid/cpu/scripts/patch_8837510.sql" Copying file to "/home/ora11g/11.2/grid/cpu/scripts/emdb_recomp_invalids.sql" Patching component oracle.ldap.rsf, 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.sdo.locator, 11.2.0.2.0... Patching component oracle.network.rsf, 11.2.0.2.0... Patches 13343424 successfully applied. OPatch Session completed with warnings. Log file location: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2012-01-19_19-39-35PM.log OPatch completed with warnings. [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 |
5. Run the pre script for DB component of the patch /home/ora11g/install/13343447/custom/server/13343447/custom/scripts/prepatch.sh -dbhome /home/ora11g/product/11.2/db --执行结果: [ora11g@11gr2test ~]$ /home/ora11g/install/13343447/custom/server/13343447/custom/scripts/prepatch.sh -dbhome /home/ora11g/product/11.2/db /home/ora11g/install/13343447/custom/server/13343447/custom/scripts/prepatch.sh completed successfully. [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 |
6. Apply the DB patch As the database home owner execute: /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/13343447/custom/server/13343447 /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/13343424 执行结果: [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/13343447/custom/server/13343447 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/product/11.2/db Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-43-42PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343447 Bug Superset of 12827731 Super set bugs are: 12827731, 10157506, 10178670, 10425672, 12311357, 12419353, 9979706, 9959110, 10016083, 10015460, 10014392, 9918485, 10157622, 10089120, 10057296, 9971646, 10053985, 10040647, 9978765, 9864003, 10069541, 10110969, 10107380, 9915329, 10044622, 10029119, 9812970, 10083009, 9812956, 10048027, 10036193, 10008467, 10040109, 10015210, 10083789, 10033106, 10073372, 9876201, 10042143, 9963327, 9679401, 10062301, 10018215, 10075643, 10007185, 10071992, 10057680, 10038791, 10124517, 10048487, 10078086, 9926027, 10052721, 9944948, 10028235, 10146768, 10011084, 10027079, 10028343, 10045436, 9907089, 10073075, 10175855, 10072474, 10036834, 9975837, 10028637, 10029900, 9949676 Patches [ 12827731 ] will be rolled back. Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343447 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/home/ora11g/product/11.2/db') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '13343447' to OH '/home/ora11g/product/11.2/db' Rolling back interim patch '12827731' from OH '/home/ora11g/product/11.2/db' Patching component oracle.rdbms, 11.2.0.2.0... RollbackSession removing interim patch '12827731' from inventory OPatch back to application of the patch '13343447' after auto-rollback. Patching component oracle.rdbms, 11.2.0.2.0... Patches 13343447 successfully applied. OPatch Session completed with warnings. Log file location: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-43-42PM.log OPatch completed with warnings. [ora11g@11gr2test ~]$ [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/13343424 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/product/11.2/db Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-46-26PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343424 Bug Superset of 12827726 Super set bugs are: 10158965, 10031806, 12635537, 9746210, 9744252, 9956713, 10356513, 10204358, 10378005, 10170431, 11853815, 10222719, 12639177, 9591812, 10127360, 9443361, 10035737, 10384285, 12846268, 9873405, 12846269, 11069199, 12670165, 10245086, 10159846, 10205230, 10052141, 10039731, 11818335, 12371955, 10040921, 12366627, 10077191, 11827088, 11785938, 10219576, 10258337, 11707699, 10264680, 10094823, 10209232, 11695333, 9881076, 10278372, 10281887, 10621169, 10048701, 9078442, 11057263, 10157249, 9735237, 10317487, 10219583, 10636231, 10310299, 11065646, 10055063, 10368698, 12340939, 10079168, 10233732, 8223165, 10264696, 10142909, 9953542, 10052956, 10080579, 11699057, 12620422, 10285022, 10329146, 10332589, 11666137, 10110863, 9869401, 12828071, 10019218, 10229719, 9539440, 10373381, 11724984, 10239480, 10411618, 11670161, 9724970, 10399808, 10113990, 10312847, 11893621, 10084145, 10367188, 11800170, 11695285, 10285394, 10157402, 9651350, 10299224, 10151017, 11724916, 10190642, 12586486, 9564886, 12586487, 10129643, 12586488, 12586489, 10018789, 10248523, 9715581, 9770451, 11889177, 10425676, 9683047, 10180307, 10126094, 10396041, 10132870, 10094201, 10193846, 11664046, 10324294, 9414040, 12586490, 9819805, 12586491, 9795214, 12586492, 12586493, 12586494, 10142788, 12586495, 11830776, 9905049, 11674898, 10419984, 12586496, 11830777, 6892311, 11830778, 10358019, 12431716, 10422126, 10200404, 11651810, 10102506, 11067567, 12827726, 11733179, 10229886, 10040531, 10155605, 10326338, 10356782, 10082277, 10051315, 10218814, 9788588, 10278773, 12326246, 10622001, 11707302, 10230571, 9966609, 12419321, 12546006, 10137324, 9771278, 10013431, 10228151, 10324526, 11894889, 10238786, 10217802, 10061015, 9572787, 10332111, 10227288, 10623249, 10073683, 12639234, 11664719, 9735282, 9748749, 10022980, 10237773, 11800854, 12419331, 11674485, 10097711, 10187168, 6523037, 10648873, 10053725, 8685446 Patches [ 12827726 ] will be rolled back. Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343424 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/home/ora11g/product/11.2/db') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... UtilSession failed: <span style="color: #ff0000">No space left on device </span>java.util.logging.ErrorManager: 2 java.io.IOException: No space left on device at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(FileOutputStream.java:260) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) at java.util.logging.FileHandler$MeteredStream.flush(FileHandler.java:143) at sun.nio.cs.StreamEncoder$CharsetSE.implFlush(StreamEncoder.java:410) at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:152) at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213) at java.util.logging.StreamHandler.flush(StreamHandler.java:225) at java.util.logging.FileHandler.publish(FileHandler.java:556) at java.util.logging.Logger.log(Logger.java:440) at java.util.logging.Logger.doLog(Logger.java:462) at java.util.logging.Logger.log(Logger.java:485) at oracle.opatch.OLogger.justlog(OLogger.java:878) at oracle.opatch.OLogger.printlnOnLog(OLogger.java:1441) at oracle.opatch.OLogger.printlnOnLog(OLogger.java:1391) at oracle.opatch.OLogger.printWarningListOnLog(OLogger.java:332) at oracle.opatch.OPatchSession.main(OPatchSession.java:2152) at oracle.opatch.OPatch.main(OPatch.java:651) Log file location: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-46-26PM.log OPatch failed with error code 73 清理.patch_storage以后: [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/13343424 Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /home/ora11g/product/11.2/db Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-56-17PM.log Verifying environment and performing prerequisite checks... Conflicts/Supersets for each patch are: Patch : 13343424 Bug Superset of 12827726 Super set bugs are: 10158965, 10031806, 12635537, 9746210, 9744252, 9956713, 10356513, 10204358, 10378005, 10170431, 11853815, 10222719, 12639177, 9591812, 10127360, 9443361, 10035737, 10384285, 12846268, 9873405, 12846269, 11069199, 12670165, 10245086, 10159846, 10205230, 10052141, 10039731, 11818335, 12371955, 10040921, 12366627, 10077191, 11827088, 11785938, 10219576, 10258337, 11707699, 10264680, 10094823, 10209232, 11695333, 9881076, 10278372, 10281887, 10621169, 10048701, 9078442, 11057263, 10157249, 9735237, 10317487, 10219583, 10636231, 10310299, 11065646, 10055063, 10368698, 12340939, 10079168, 10233732, 8223165, 10264696, 10142909, 9953542, 10052956, 10080579, 11699057, 12620422, 10285022, 10329146, 10332589, 11666137, 10110863, 9869401, 12828071, 10019218, 10229719, 9539440, 10373381, 11724984, 10239480, 10411618, 11670161, 9724970, 10399808, 10113990, 10312847, 11893621, 10084145, 10367188, 11800170, 11695285, 10285394, 10157402, 9651350, 10299224, 10151017, 11724916, 10190642, 12586486, 9564886, 12586487, 10129643, 12586488, 12586489, 10018789, 10248523, 9715581, 9770451, 11889177, 10425676, 9683047, 10180307, 10126094, 10396041, 10132870, 10094201, 10193846, 11664046, 10324294, 9414040, 12586490, 9819805, 12586491, 9795214, 12586492, 12586493, 12586494, 10142788, 12586495, 11830776, 9905049, 11674898, 10419984, 12586496, 11830777, 6892311, 11830778, 10358019, 12431716, 10422126, 10200404, 11651810, 10102506, 11067567, 12827726, 11733179, 10229886, 10040531, 10155605, 10326338, 10356782, 10082277, 10051315, 10218814, 9788588, 10278773, 12326246, 10622001, 11707302, 10230571, 9966609, 12419321, 12546006, 10137324, 9771278, 10013431, 10228151, 10324526, 11894889, 10238786, 10217802, 10061015, 9572787, 10332111, 10227288, 10623249, 10073683, 12639234, 11664719, 9735282, 9748749, 10022980, 10237773, 11800854, 12419331, 11674485, 10097711, 10187168, 6523037, 10648873, 10053725, 8685446 <span style="color: #ff0000">Patches [ 12827726 ] will be rolled back. </span> Do you want to proceed? [y|n] y User Responded with: Y OPatch continues with these patches: 13343424 Do you want to proceed? [y|n] y User Responded with: Y Prerequisite check "CheckRollbackable" on auto-rollback patches failed. The details are: Patch 12827726: Archive Action: Source file <span style="color: #ff0000">"/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11</span>.a/kgl2.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgl2.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgh.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgh.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgx.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgx.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgl.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgl.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgkp.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgkp.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgsk.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgsk.o' Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.a/kgski.o" does not exists. 'oracle.rdbms.rsf, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libgeneric11.a' with '/kgski.o' ......省略部分内容 Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libordsdo11.a/mdrt.o" does not exists. 'oracle.sdo.locator, 11.2.0.2.0': Cannot update file '/home/ora11g/product/11.2/db/lib/libordsdo11.a' with '/mdrt.o' UtilSession failed: Prerequisite check "CheckRollbackable" on auto-rollback patches failed. Log file location: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_19-56-17PM.log OPatch failed with error code 73 [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
7. Run the post script for DB component of the patch As the database home owner execute: /home/ora11g/install/13343447/custom/server/13343447/custom/scripts/postpatch.sh -dbhome /home/ora11g/product/11.2/db 执行结果: [ora11g@11gr2test ~]$ /home/ora11g/install/13343447/custom/server/13343447/custom/scripts/postpatch.sh -dbhome /home/ora11g/product/11.2/db Reading /home/ora11g/product/11.2/db/install/params.ora.. Reading /home/ora11g/product/11.2/db/install/params.ora.. Parsing file /home/ora11g/product/11.2/db/bin/racgwrap Parsing file /home/ora11g/product/11.2/db/bin/srvctl Parsing file /home/ora11g/product/11.2/db/bin/srvconfig Parsing file /home/ora11g/product/11.2/db/bin/cluvfy Verifying file /home/ora11g/product/11.2/db/bin/racgwrap Verifying file /home/ora11g/product/11.2/db/bin/srvctl Verifying file /home/ora11g/product/11.2/db/bin/srvconfig Verifying file /home/ora11g/product/11.2/db/bin/cluvfy Reapplying file permissions on /home/ora11g/product/11.2/db/bin/racgwrap Reapplying file permissions on /home/ora11g/product/11.2/db/bin/srvctl Reapplying file permissions on /home/ora11g/product/11.2/db/bin/srvconfig Reapplying file permissions on /home/ora11g/product/11.2/db/bin/cluvfy Reapplying file permissions on /home/ora11g/product/11.2/db/bin/diskmon.bin Reapplying file permissions on /home/ora11g/product/11.2/db/bin/lsnodes Reapplying file permissions on /home/ora11g/product/11.2/db/bin/osdbagrp Reapplying file permissions on /home/ora11g/product/11.2/db/bin/rawutl Reapplying file permissions on /home/ora11g/product/11.2/db/srvm/admin/ractrans Reapplying file permissions on /home/ora11g/product/11.2/db/srvm/admin/getcrshome Reapplying file permissions on /home/ora11g/product/11.2/db/bin/gnsd Reapplying file permissions on /home/ora11g/product/11.2/db/bin/crsdiag.pl Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libhasgen11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libclsra11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libdbcfg11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libocr11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libocrb11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libocrutl11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libuini11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/librdjni11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libgns11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libgnsjni11.so Reapplying file permissions on /home/ora11g/product/11.2/db/lib/libagfw11.so |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
8. Run the post script /home/ora11g/11.2/grid/crs/install/roothas.pl -patch --执行结果: [root@11gr2test ~]# /home/ora11g/11.2/grid/crs/install/roothas.pl -patch Using configuration parameter file: /home/ora11g/11.2/grid/crs/install/crsconfig_params ACFS-9300: ADVM/ACFS distribution files found. ACFS-9312: Existing ADVM/ACFS installation detected. ACFS-9314: Removing previous ADVM/ACFS installation. ACFS-9315: Previous ADVM/ACFS components successfully removed. ACFS-9307: Installing requested ADVM/ACFS software. ACFS-9308: Loading installed ADVM/ACFS drivers. ACFS-9321: Creating udev for ADVM/ACFS. ACFS-9323: Creating module dependencies - this may take some time. ACFS-9327: Verifying ADVM/ACFS devices. ACFS-9309: ADVM/ACFS installation correctness verified. CRS-4123: Oracle High Availability Services has been started. |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
9. Start the CRS managed resources that were earlier running from DB homes /home/ora11g/product/11.2/db/bin/srvctl start home -o /home/ora11g/product/11.2/db -s /home/ora11g/1120205.log --执行结果: [root@11gr2test ~]# su - ora11g [ora11g@11gr2test ~]$ /home/ora11g/product/11.2/db/bin/srvctl start home -o /home/ora11g/product/11.2/db -s /home/ora11g/1120205.log [ora11g@11gr2test ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA1.dg ora....up.type ONLINE ONLINE 11gr2test ora....ER.lsnr ora....er.type ONLINE ONLINE 11gr2test ora.asm ora.asm.type ONLINE ONLINE 11gr2test ora.cssd ora.cssd.type ONLINE ONLINE 11gr2test ora.diskmon ora....on.type ONLINE ONLINE 11gr2test ora.evmd ora.evm.type ONLINE ONLINE 11gr2test ora.ons ora.ons.type OFFLINE OFFLINE ora.roger.db ora....se.type ONLINE ONLINE 11gr2test procwatcher application ONLINE ONLINE 11gr2test [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 |
10. Check [ora11g@11gr2test ~]$ /home/ora11g/install/OPatch/opatch lsinventory Invoking OPatch 11.2.0.1.8 Oracle Interim Patch Installer version 11.2.0.1.8 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /home/ora11g/product/11.2/db Central Inventory : /home/ora11/ora11g/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.8 OUI version : 11.2.0.2.0 Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2012-01-19_20-06-07PM.log Lsinventory Output file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/lsinv/lsinventory2012-01-19_20-06-07PM.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 13343447 : applied on Thu Jan 19 19:45:52 PST 2012 Unique Patch ID: 14281419.1 <span style="color: #000000">Patch Description: "Grid Infrastructure Patch Set Update : 11.2.0.2.5 (13343447)" </span> Created on 15 Jan 2012, 22:47:31 hrs PST8PDT Bugs fixed: 13343447, 10157506, 10178670, 10425672, 12311357, 12419353, 12827731 9959110, 10272615, 10314123, 10014392, 10089120, 10057296, 11692271 9864003, 11775080, 9916145, 12695202, 12593451, 10044622, 11705438 10365625, 12767231, 9935308, 12399977, 11882456, 12421404, 12862012 11744343, 12340700, 10056713, 10637741, 9939306, 9795321, 9902536 10007185, 10376847, 10038791, 11741224, 12823479, 11655840, 10048487 10322157, 11768599, 10260251, 10052721, 10028235, 10027079, 12412303 10357258, 11871469, 10045436, 10231906, 12722095, 10622973, 9891341 10072474, 10036834, 10029900, 9974223, 10161846, 10016083, 12597463 9918485, 11781515, 10040647, 13332363, 12651595, 12345151, 11925641 10069541, 10029119, 10233159, 12332919, 9812956, 10036193, 10015210 12424479, 12340501, 10621175, 9686152, 12556028, 11877079, 8906163 10111010, 12366642, 11777648, 10115514, 10104377, 10057680, 10280665 10078086, 9944948, 10146768, 10052529, 10011084, 10012319, 10073075 10233811, 12720728, 10299006, 12426375, 10248739, 10236074, 10128191 11071429, 10019726, 9975837, 10253630, 12615394, 10420872, 9949676 11936945, 11820787, 10637483, 13396479, 12677816, 10157622, 11698552 10385838, 10053985, 12718811, 10229297, 10425674, 9812970, 11828633 12359585, 11899801, 10083789, 12728585, 9876201, 10073372, 9963327 10428946, 11077756, 10375649, 9336825, 11682409, 10062301, 12767563 12546712, 10018215, 10105195, 10419987, 13355549, 10071992, 11807012 10634513, 9926027, 10103954, 12743755, 12406573, 10028343, 11768055 11866171, 10065216, 9907089, 9897335, 10190153, 11744313, 10175855 12600343, 12422324, 10284828, 10028637, 10361177, 12800501, 9979706 12950415, 10324594, 10015460, 11818524, 9971646, 11782423, 11654726 9978765, 10398810, 11904778, 10397652, 9915329, 10107380, 10110969 10305361, 10331452, 10083009, 10631693, 10008467, 10048027, 10040109 9944978, 10370797, 10033106, 12700217, 11840629, 10042143, 9978195 10284693, 12639016, 10638381, 11839004, 9679401, 11663339, 10075643 10057719, 11834289, 9458055, 10205290, 10124517, 12680491, 13334158 11069614, 10165314, 9593552, 10168006 <span style="color: #000000">Patch 12827726 : applied on Sun Oct 30 07:29:27 PDT 2011 </span>Unique Patch ID: 14021063 Created on 21 Sep 2011, 05:09:52 hrs PST8PDT Bugs fixed: 10158965, 10031806, 12635537, 9746210, 9744252, 9956713, 10356513 10204358, 10378005, 10170431, 11853815, 10222719, 12639177, 9591812 10127360, 9443361, 10035737, 10384285, 12846268, 9873405, 12846269 11069199, 12670165, 10245086, 10159846, 10205230, 10052141, 10039731 11818335, 12371955, 10040921, 12366627, 10077191, 11827088, 11785938 10219576, 10258337, 11707699, 10264680, 10094823, 10209232, 11695333 9881076, 10278372, 10281887, 10621169, 10048701, 9078442, 11057263 10157249, 9735237, 10317487, 10219583, 10636231, 10310299, 11065646 10055063, 10368698, 12340939, 10079168, 10233732, 8223165, 10264696 10142909, 9953542, 10052956, 10080579, 11699057, 12620422, 10285022 10329146, 10332589, 11666137, 10110863, 9869401, 12828071, 10019218 10229719, 9539440, 10373381, 11724984, 10239480, 10411618, 11670161 9724970, 10399808, 10113990, 10312847, 11893621, 10084145, 10367188 11800170, 11695285, 10285394, 10157402, 9651350, 10299224, 10151017 11724916, 10190642, 12586486, 9564886, 12586487, 10129643, 12586488 12586489, 10018789, 10248523, 9715581, 9770451, 11889177, 10425676 9683047, 10180307, 10126094, 10396041, 10132870, 10094201, 10193846 11664046, 10324294, 9414040, 12586490, 9819805, 12586491, 9795214 12586492, 12586493, 12586494, 10142788, 12586495, 11830776, 9905049 11674898, 10419984, 12586496, 11830777, 6892311, 11830778, 10358019 12431716, 10422126, 10200404, 11651810, 10102506, 11067567, 12827726 11733179, 10229886, 10040531, 10155605, 10326338, 10356782, 10082277 10051315, 10218814, 9788588, 10278773, 12326246, 10622001, 11707302 10230571, 9966609, 12419321, 12546006, 10137324, 9771278, 10013431 10228151, 10324526, 11894889, 10238786, 10217802, 10061015, 9572787 10332111, 10227288, 10623249, 10073683, 12639234, 11664719, 9735282 9748749, 10022980, 10237773, 11800854, 12419331, 11674485, 10097711 10187168, 6523037, 10648873, 10053725, 8685446 -------------------------------------------------------------------------------- OPatch succeeded. [ora11g@11gr2test ~]$ |
1 2 3 4 5 6 7 8 |
<span style="color: #0000ff">简单的总结下: 为什么在apply for db的时候会失败呢? 1. 一方面,11.2对磁盘空间需求感觉越来越大了; 2. 在apply 11.2.0.2.5时需要先对11.2.0.2.4 进行rollback,开始没有注意看,所以 我直接把.patch_storage下面的东西干掉了,导致不能rollback,也就导致最后for db 的时候无法继续,报错找不到文件了。 3. 由于最后13343424 for db没有成功,故最后也就不用执行相关sql脚本了。</span> |
One Response to “Apply 11.2.0.2.5 Failed ?”
I love to read http://www.killdb.com
Leave a Reply
You must be logged in to post a comment.