sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle 11GR2数据库安装PSU遇到问题失败

时间:2016-11-29 23:01   来源:Oracle研究中心   作者:网络   点击:

天萃荷净 Oracle研究中心案例分析:分享一篇关于Oracle 11Gr2数据库升级时的详细步骤,详细介绍了11.2.0.2.4升级至11.2.0.2.5的详细步骤。

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: Apply 11.2.0.2.5 Failed

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

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

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]

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.so
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.
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, 10Oracleо190153, 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脚本了。

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle 11GR2数据库安装PSU遇到问题失败

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1345.html

Oracle研究中心

关键词:

Oracle 11.2.0.2.4 TO 11.2.0.2.5

Oracle升级安装PSU详细步骤