在10月18号发布的psu 11.2.0.2.4以后，已经有一段时间，一直没时间下载，今天进行了安装。
在apply psu之前，有几点需要说明一下，在此也顺便提醒下大家：
1. 该psu相对grid来说变化较大，需要较大空间，最好保证GI_HOME有足够的剩余空间;
2. apply psu之前，建议对GI_HOME以及ORACLE_HOME进行备份，可以直接tar包;
3. 对opatch版本有一定的要求，详见reamde文档;
根据reamde说明，需要 11.2.0.1.5+ 的opatch version，如果opatch版本不满足要求，那么你可能
会遇到如下类似错误：
[ora11g@11gr2test OPatch]$ ./opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/12827731
Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, 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.1
OUI version : 11.2.0.2.0
OUI location : /home/ora11g/11.2/grid/oui
Log file location : /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2011-10-30_06-44-52AM.log
Patch history file: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply"
UtilSession failed:
Patch 12827731 requires OPatch version 11.2.0.1.4.
The OPatch version being used (11.2.0.1.1) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
OPatch failed with error code 73
如下是我Apply该psu的一个全过程，一个手动全过程。
'###### 1. 下载最新的opatch ######'
[ora11g@11gr2test OPatch]$ ./opatch version
Invoking OPatch 11.2.0.1.8
OPatch Version: 11.2.0.1.8
OPatch succeeded.
'###### 2. stop dbconsole ######'
'###### 3. Stop database ######'
[root@11gr2test bin]# ./srvctl stop home -o /home/ora11g/product/11.2/db -s /home/ora11g/install.log
'###### 4. Stop oracle restart ######'
[root@11gr2test bin]# cd /home/ora11g/11.2/grid/crs/install
[root@11gr2test install]# ./roothas.pl -unlock
Using configuration parameter file: ./crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11gr2test'
CRS-2673: Attempting to stop 'ora.evmd' on '11gr2test'
CRS-2677: Stop of 'ora.evmd' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.asm' on '11gr2test'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on '11gr2test'
CRS-2677: Stop of 'ora.asm' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on '11gr2test'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on '11gr2test' succeeded
CRS-2677: Stop of 'ora.cssd' on '11gr2test' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on '11gr2test'
CRS-2677: Stop of 'ora.diskmon' on '11gr2test' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11gr2test' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /home/ora11g/11.2/grid
'###### 5. Apply crs patch ######'
[ora11g@11gr2test OPatch]$ ./opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/12827731
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/opatch2011-10-30_07-12-04AM.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 12827731
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 '12827731' to OH '/home/ora11g/11.2/grid'
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 12827731 successfully applied.
Log file location: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2011-10-30_07-12-04AM.log
OPatch succeeded.
[ora11g@11gr2test OPatch]$
'###### 6. Apply db patch ######'
[ora11g@11gr2test OPatch]$ ./opatch napply -oh /home/ora11g/11.2/grid -local /home/ora11g/install/12827726
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/opatch2011-10-30_07-17-59AM.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 12827726
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 '12827726' 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 ] not present in the Oracle Home or a higher version is found.
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.4/catpsu.sql"
Copying file to "/home/ora11g/11.2/grid/psu/11.2.0.2.4/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...
Patches 12827726 successfully applied.
Log file location: /home/ora11g/11.2/grid/cfgtoollogs/opatch/opatch2011-10-30_07-17-59AM.log
OPatch succeeded.
'###### 7. Run the pre script for DB component of the patch ######'
[ora11g@11gr2test scripts]$ pwd
/home/ora11g/install/12827731/custom/scripts
[ora11g@11gr2test scripts]$ ./prepatch.sh -dbhome /home/ora11g/product/11.2/db
./prepatch.sh completed successfully.
'###### 8. Apply the DB patch ######'
++++++ apply crs patch ++++++
[ora11g@11gr2test OPatch]$ ./opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/12827731/custom/server/12827731
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/opatch2011-10-30_07-24-40AM.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 12827731
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 '12827731' to OH '/home/ora11g/product/11.2/db'
Patching component oracle.rdbms, 11.2.0.2.0...
Patches 12827731 successfully applied.
Log file location: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2011-10-30_07-24-40AM.log
OPatch succeeded.
++++++ apply db patch ++++++
[ora11g@11gr2test OPatch]$ ./opatch napply -oh /home/ora11g/product/11.2/db -local /home/ora11g/install/12827726
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/opatch2011-10-30_07-26-02AM.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 12827726
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 '12827726' to OH '/home/ora11g/product/11.2/db'
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Patching component oracle.rdbms, 11.2.0.2.0...
Copying file to "/home/ora11g/product/11.2/db/psu/11.2.0.2.4/catpsu.sql"
Copying file to "/home/ora11g/product/11.2/db/psu/11.2.0.2.4/catpsu_rollback.sql"
Copying file to "/home/ora11g/product/11.2/db/cpu/scripts/patch_8837510.sql"
Copying file to "/home/ora11g/product/11.2/db/cpu/scripts/emdb_recomp_invalids.sql"
Patching component oracle.sysman.console.db, 11.2.0.2.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.3...
Patching component oracle.ldap.rsf, 11.2.0.2.0...
Patching component oracle.rdbms.dv, 11.2.0.2.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Patching component oracle.sysman.plugin.db.main.repository, 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...
Patches 12827726 successfully applied.
Log file location: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2011-10-30_07-26-02AM.log
OPatch succeeded.
'###### 9. Run the post script for DB component of the patch ######'
[ora11g@11gr2test scripts]$ pwd
/home/ora11g/install/12827731/custom/server/12827731/custom/scripts
[ora11g@11gr2test 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
[ora11g@11gr2test scripts]$
'###### 10. Run the post script ######'
[root@11gr2test install]# pwd
/home/ora11g/11.2/grid/crs/install
[root@11gr2test install]# ./roothas.pl -patch
Using configuration parameter file: ./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.
'###### 11. Start the CRS managed resources that were earlier running from DB homes ######'
[root@11gr2test install]# su - ora11g
[ora11g@11gr2test ~]$ which srvctl
~/product/11.2/db/bin/srvctl
[ora11g@11gr2test ~]$ env|grep ORA
ORACLE_SID=roger
ORACLE_BASE=/home/ora11g
ORACLE_TERM=xterm
ORACLE_HOME=/home/ora11g/product/11.2/db
[ora11g@11gr2test ~]$ srvctl start home -o /home/ora11g/product/11.2/db -s /home/ora11g/install.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
'###### 12. check psu ######'
[ora11g@11gr2test OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, 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.1
OUI version : 11.2.0.2.0
OUI location : /home/ora11g/product/11.2/db/oui
Log file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch2011-10-30_07-45-29AM.log
Patch history file: /home/ora11g/product/11.2/db/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /home/ora11g/product/11.2/db/cfgtoollogs/opatch/lsinv/lsinventory2011-10-30_07-45-29AM.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 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
Patch 12827731 : applied on Sun Oct 30 07:25:12 PDT 2011
Unique Patch ID: 14021063
Created on 14 Oct 2011, 22:42:34 hrs PST8PDT
Bugs fixed:
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.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
