Oracle Patch (2) - PSU

接上...

参见官方文档,该文档存在于GI和DB PSU安装包中.
Patch 13923374 - 11.2.0.3.3 Patch Set Update
Patch 13919095 - 11.2.0.3.3 GI Patch Set Update (Includes Database PSU 11.2.0.3.3)

Oracle 11g R2的PSU与Oracle 10g不一样,它包括Database PSU(亦称DB PSU 或PSU)和Grid Infrastructure PSU(亦称GI PSU),Database PSU包括CPU,与通常讲的10g的PSU概念相同;但是GI PSU包含Databae PSU和CPU,内容更丰富,装GI PSU时也会一起将Database PSU安装,当然也包括了CPU的内容.

如果Oracle没有安装GI组件,那么直接安装Patch 13923374将11.2.0.3.0升级至11.2.0.3.3,这个PSU为Database PSU与10g版本的PSU安装类似,直接参照官方文档.
如果Oracle是如下这个GI+单实例的环境,则需要先安装GI PSU,同时会一并将Database PSU也安装,可以参见官方文档的Section 5, "Manual Steps for Apply/Rollback Patch"

例子3-PSU安装
测试环境:
Linux 5.6 x86 + Oracle 11.2.0.3.0单机 + GI 11.2.0.3.0 + Oracle Restart Service + ASM 11.2.0.3.0

步骤如下
1), 核实$ORACLE_HOME/OPatch/opatch的版本.
2), 创建ocm.rsp
ora11gr2.sannet.net | XXX | /home/oracle/patch > $ORACLE_HOME/OPatch/ocm/bin/emocmrsp
OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates.  All rights reserved.

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
The OCM configuration response file (ocm.rsp) was successfully created.
3), 检查Oracle Inventory
ora11gr2.sannet.net | XXX | /home/oracle/patch > $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
4),One-off冲突检测
$ opatch prereq CheckConflictAgainstOHWithDetail -ph <UNZIPPED_PATCH_LOCATION>/13923374 -oh $GRID_HOME
$ opatch prereq CheckConflictAgainstOHWithDetail -ph <UNZIPPED_PATCH_LOCATION>/13923374 -oh $DB_HOME
$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/13919095 -oh $GRID_HOME
$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/13919095/custom/server/13919095 -oh $DB_HOME
这里UNZIPPED_PATCH_LOCATION=/home/oracle/patch,$DB_HOME即为$ORACLE_HOME
5), 关闭CRS服务
$crsctl stop resource -all
$crsctl stop has
6), 执行脚本
This script does the following:
1) Setup permissions of binaries and DSOs in SI-HAS home
2) Setup OLR for storing SI-HAS configuration data
[root@ora11gr2 ~]# /u01/app/grid/product/11.2.0.3.0/crs/install/roothas.pl -unlock//这里因为GI是为支持service restart,所以运行这个脚本,而如果是为了支持RAC则运行rootcrs.pl
Using configuration parameter file: /u01/app/grid/product/11.2.0.3.0/crs/install/crsconfig_params
Successfully unlock /u01/app/grid/product/11.2.0.3.0
7), 确保$GRID_HOME/OPatch/opatch的版本为11.2.0.3.0
p6880880_112000_LINUX_OPatch11.2.3.zip
8), Apply CRS and DB patch
ora11gr2.sannet.net | XXX | /home/oracle > /u01/app/grid/product/11.2.0.3.0/OPatch/opatch napply -oh $GRID_HOME -local ./patch/13919095
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/grid/product/11.2.0.3.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/grid/product/11.2.0.3.0/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/grid/product/11.2.0.3.0/cfgtoollogs/opatch/opatch2012-10-06_18-10-01PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13919095  

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 = '/u01/app/grid/product/11.2.0.3.0')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '13919095' to OH '/u01/app/grid/product/11.2.0.3.0'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...

Verifying the update...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
ins_srvm.mk:31: warning: ignoring old commands for target `libsrvm11.so'
ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'
ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'
ins_srvm.mk:74: warning: overriding commands for target `libsrvmhas11.so'
ins_srvm.mk:37: warning: ignoring old commands for target `libsrvmhas11.so'


Patch 13919095 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/grid/product/11.2.0.3.0/cfgtoollogs/opatch/opatch2012-10-06_18-10-01PM_1.log

OPatch completed with warnings.

ora11gr2.sannet.net | XXX | /home/oracle > /u01/app/grid/product/11.2.0.3.0/OPatch/opatch napply -oh $GRID_HOME -local ./patch/13923374
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/grid/product/11.2.0.3.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/grid/product/11.2.0.3.0/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/grid/product/11.2.0.3.0/cfgtoollogs/opatch/opatch2012-10-06_18-41-06PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  

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 = '/u01/app/grid/product/11.2.0.3.0')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/grid/product/11.2.0.3.0'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/grid/product/11.2.0.3.0'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/grid/product/11.2.0.3.0'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Verifying the update...
Composite patch 13923374 successfully applied.
Log file location: /u01/app/grid/product/11.2.0.3.0/cfgtoollogs/opatch/opatch2012-10-06_18-41-06PM_1.log

OPatch succeeded.

ora11gr2.sannet.net | XXX | /home/oracle/patch > ./13919095/custom/server/13919095/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
./13919095/custom/server/13919095/custom/scripts/prepatch.sh completed successfully.

ora11gr2.sannet.net | XXX | /home/oracle/patch > /u01/app/oracle/product/11.2.0.3.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local ./13919095/custom/server/13919095
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/opatch2012-10-06_19-35-09PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13919095  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0.3.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '13919095' to OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
ins_srvm.mk:31: warning: ignoring old commands for target `libsrvm11.so'
ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'
ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'
ins_srvm.mk:74: warning: overriding commands for target `libsrvmhas11.so'
ins_srvm.mk:37: warning: ignoring old commands for target `libsrvmhas11.so'


Patch 13919095 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/opatch2012-10-06_19-35-09PM_1.log

OPatch completed with warnings.

ora11gr2.sannet.net | XXX | /home/oracle/patch > /u01/app/oracle/product/11.2.0.3.0/db_1/OPatch/opatch apply -oh $ORACLE_HOME -local ./13923374
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/opatch2012-10-06_20-48-49PM_1.log

Verifying environment and performing prerequisite checks...
Composite Patch 13923374 is a bug superset of 14063281,14063280,14062797,14062796,14062795,14062794,14062793,14062792,14038787,13742464,13742438,13742437,13742436,13742435,13742434,13742433 in OH.

Patches [   14063281   14063280   14062797   14062796   14062795   14062794   14062793   14062792   14038787   13742464   13742438   13742437   13742436   13742435   13742434   13742433 ] will be rolled back.


Do you want to proceed? [y|n]
y
User Responded with: Y
OPatch continues with these patches:   13343438  13696216  13923374  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0.3.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0.3.0/db_1'
Rolling back interim patch '14063281' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14063281' from inventory
Rolling back interim patch '14063280' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...
RollbackSession removing interim patch '14063280' from inventory
Rolling back interim patch '14062797' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062797' from inventory
Rolling back interim patch '14062796' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062796' from inventory
Rolling back interim patch '14062795' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAChecklistController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAExadataController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAOptimizerStatsController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAParameterChangeController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAUpgradeController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/StsImExportController.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/DBMonitoringObject.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/spia/TrialsComparisonBean.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_optimizerStats.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_parameterChange.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_sage.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_trialComparison.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_upgrade.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_upgrade2.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_sqlset/_stsExport.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emdb_emjsp.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/14062795_Jun_26_2012_23_03_15/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_sqlset/_stsImport.class"
RollbackSession removing interim patch '14062795' from inventory
Rolling back interim patch '14062794' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062794' from inventory
Rolling back interim patch '14062793' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062793' from inventory
Rolling back interim patch '14062792' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062792' from inventory
Rolling back interim patch '14038787' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14038787' from inventory
Rolling back interim patch '13742464' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '13742464' from inventory
Rolling back interim patch '13742438' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emCORE.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/13742438_Mar_12_2012_03_20_41/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$BuiltInIds.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emCORE.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/13742438_Mar_12_2012_03_20_41/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$TokenSeparatorWords.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emCORE.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/13742438_Mar_12_2012_03_20_41/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$Parameters.class"
Updating jar file "/u01/app/oracle/product/11.2.0.3.0/db_1/sysman/jlib/emCORE.jar" with "/u01/app/oracle/product/11.2.0.3.0/db_1/.patch_storage/13742438_Mar_12_2012_03_20_41/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$Tokenizations.class"

Patching component oracle.sysman.oms.core, 10.2.0.4.4...
RollbackSession removing interim patch '13742438' from inventory
Rolling back interim patch '13742437' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sysman.console.db, 11.2.0.3.0...
RollbackSession removing interim patch '13742437' from inventory
Rolling back interim patch '13742436' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sysman.console.db, 11.2.0.3.0...
RollbackSession removing interim patch '13742436' from inventory
Rolling back interim patch '13742435' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sysman.console.db, 11.2.0.3.0...
RollbackSession removing interim patch '13742435' from inventory
Rolling back interim patch '13742434' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '13742434' from inventory
Rolling back interim patch '13742433' from OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.sdo.locator, 11.2.0.3.0...
RollbackSession removing interim patch '13742433' from inventory

OPatch back to application of the patch '13343438' after auto-rollback.


Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0.3.0/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0.3.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Verifying the update...
Composite patch 13923374 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/opatch2012-10-06_20-48-49PM_1.log

OPatch completed with warnings.    

ora11gr2.sannet.net | XXX | /home/oracle/patch > ./13919095/custom/server/13919095/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /u01/app/oracle/product/11.2.0.3.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/11.2.0.3.0/db_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.2.0.3.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/bin/crsdiag.pl
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libhasgen11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libclsra11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libdbcfg11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libocr11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libocrb11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libocrutl11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libuini11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/librdjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libgns11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libgnsjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0.3.0/db_1/lib/libagfw11.so
9), 更新数据字典
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
10), 验证是否成功
SQL> set linesize 132
SQL> col action_time for a30
SQL> col comments for a50
SQL> select action_time,action,comments from registry$history;

ACTION_TIME                    ACTION                         COMMENTS
------------------------------ ------------------------------ --------------------------------------------------
18-SEP-11 06.02.59.465921 PM   APPLY                          Patchset 11.2.0.2.0
12-MAY-12 03.41.35.805037 AM   APPLY                          Patchset 11.2.0.2.0
25-SEP-12 05.19.19.245123 PM   APPLY                          CPUJul2012
06-OCT-12 09.34.50.788414 PM   APPLY                          PSU 11.2.0.3.3
ora11gr2.sannet.net | XXX | /home/oracle > /u01/app/oracle/product/11.2.0.3.0/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/opatch2012-10-08_13-33-23PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2012-10-08_13-33-23PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

Patch  13923374     : applied on Sat Oct 06 21:10:24 CST 2012
Unique Patch ID:  14859690
Patch description:  "Database Patch Set Update : 11.2.0.3.3 (13923374)"
   Created on 14 Jun 2012, 19:31:29 hrs PST8PDT
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     13419660, 10350832, 13632717, 14063281, 12919564, 13467683, 13588248
     13420224, 12646784, 12861463, 12834027, 13036331, 12880299, 13499128
     12998795, 13492735, 12829021, 13503598, 10133521, 12718090, 13742433
     12905058, 12401111, 13742434, 12849688, 13362079, 12950644, 13742435
     12917230, 13923374, 12879027, 12535346, 12588744, 11877623, 13916709
     12847466, 13340388, 13528551, 13366202, 12894807, 13981051, 13343438
     12582664, 12748240, 12797765, 12923168, 13466801, 13772618, 11063191
     13070939, 13035804, 12797420, 13041324, 12976376, 13742437, 14062795
     13035360, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
     13001379, 13370330, 14062797, 13742436, 9873405, 14062794, 9858539
     12960925, 12662040, 9703627, 12617123, 13338048, 12938841, 12658411
     12620823, 12656535, 12845115, 14062793, 12764337, 12678920, 13354082
     14062792, 12612118, 9761357, 13742464, 13457582, 13527323, 12780983
     12780098, 13502183, 13696216, 11840910, 13903046, 13554409, 13657605
     13103913, 14063280

Patch  13919095     : applied on Sat Oct 06 20:44:48 CST 2012
Unique Patch ID:  14859690
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.3 (13919095)"
   Created on 3 Jul 2012, 02:25:52 hrs PST8PDT
   Bugs fixed:
     13919095, 13696251, 13348650, 12659561, 13039908, 13036424, 12794268
     13011520, 13569812, 12758736, 13077654, 13001901, 13430715, 13806545
     14082976, 12771830, 12538907, 13066371, 13483672, 12594616, 12897651
     12897902, 13241779, 12896850, 12726222, 12829429, 12728585, 13079948
     12876314, 13090686, 12925041, 12995950, 13251796, 12650672, 12398492
     12848480, 13652088, 12990582, 13857364, 12975811, 12917897, 13082238
     12947871, 13037709, 13371153, 12878750, 10114953, 11772838, 13058611
     13001955, 11836951, 12965049, 13440962, 12765467, 13425727, 12885323
     13339443, 12784559, 13332363, 13074261, 12971251, 13811209, 12709476
     12857064, 13719731, 13396284, 12899169, 13111013, 12867511, 12639013
     12959140, 13085732, 12829917, 12934171, 12849377, 12349553, 12680491
     12914824, 13789135, 12730342, 13334158, 12950823, 13355963, 13531373
     13776758, 12720728, 13620816, 13002015, 13024624, 12791719



--------------------------------------------------------------------------------

OPatch succeeded.