2012/1/18 oracle发布了11.2.0.2的最新psu 11.2.0.2.5,其中Grid Infrastructure
的补丁号为13343447,其实该补丁中已经包含了db的补丁13343438,如下:
[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]$我这里是oracle restart环境,何为restart呢?简单的说,oracle推出这个特性也有
取代传统的HA环境之意吧,个人猜测。11gR2中的restart 其实是10g的single instance HA
的升级版本,当然确实更强悍了,虽然有HA之意,但是仍然无法避免主机层面的故障。
如下是我的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. 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 ~]$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 ~]#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:
Required amount of space(3084990246) is not available.
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
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/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
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/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 ~]$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 ~]$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: No space left on device
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
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
Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
The details are:
Patch 12827726:
Archive Action: Source file "/home/ora11g/product/11.2/db/.patch_storage/12827726_Sep_21_2011_05_09_52/files/lib/libgeneric11.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 ~]$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.so8. 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.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 ~]$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
Patch Description: "Grid Infrastructure Patch Set Update : 11.2.0.2.5 (13343447)"
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
Patch 12827726 : applied on Sun Oct 30 07:29:27 PDT 2011
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 ~]$简单的总结下:
为什么在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脚本了。「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




