oracle 补丁包安装

ssplyh

　　PSU 11.2.0.3.5的补丁号是14727310，可以从MOS网站上下载到。
　　Patch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch.
　　11.2.0.3.5累积的，不需要安装前面的PSU补丁。
　　1、先决条件
　　PSU 11.2.0.3.5 patch 的安装需要首先安装ORACLE 11.2.0.3的RDBMS。
　　[oracle@db2server ~]$ sqlplus -version

　　SQL*Plus:>　　opatch版本必须11.2.0.3.0以上。
　　[oracle@db2server ~]$ opatch version
　　Invoking OPatch 11.2.0.1.7
　　OPatch Version: 11.2.0.1.7
　　OPatch succeeded.

　　可以从MOS上下载最新的opatch,PATCH>　　解压替换老的OPatch即可。
　　[oracle@db2server db11.2.0.3]$ mv OPatch/ OPatch_old
　　[oracle@db2server db11.2.0.3]$ unzip  /tmp/p6880880_112000_LINUX.zip  -d .
　　[oracle@db2server db11.2.0.3]$ opatch version
　　OPatch Version: 11.2.0.3.3
　　OPatch succeeded.
　　[oracle@db2server db11.2.0.3]$
　　2、安装
　　确保RDBMS相关的进程关闭。
　　[oracle@db2server db11.2.0.3]$ cd OPatch
　　[oracle@db2server OPatch]$ mkdir patchs
　　[oracle@db2server OPatch]$ cd patchs/
　　将下载的p14727310_112030_LINUX.zip 上传到服务器上。
　　[oracle@db2server patchs]$ ls -ltr
　　total 22444
　　-rw-r--r-- 1 oracle oinstall 22939052 Mar 12  2013 p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ unzip p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ ls -ltr
　　total 22448
　　drwxrwxr-x 7 oracle oinstall     4096 Jan  8 21:24 14727310
　　-rw-r--r-- 1 oracle oinstall 22939052 Mar 12  2013 p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ cd 14727310
　　[oracle@db2server 14727310]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./  
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　PREREQ session
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-34-30PM_1.log
　　Invoking prereq "checkconflictagainstohwithdetail"
　　Prereq "checkConflictAgainstOHWithDetail" passed.
　　OPatch succeeded.
　　下面开始应用补丁。
　　[oracle@db2server 14727310]$ opatch apply
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-37-12PM_1.log
　　Verifying environment and performing prerequisite checks...
　　Prerequisite check "CheckActiveFilesAndExecutables" failed.
　　The details are:
　　Following executables are active :
　　/u01/app/oracle/product/db11.2.0.3/lib/libclntsh.so.11.1
　　UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
　　Log file location: /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-37-12PM_1.log
　　OPatch failed with error code 73
　　由于我本地的SQLPLUS没有全部关闭，导致libclntsh库文件还被占用，因此导致应用补丁失败。
　　[oracle@db2server 14727310]$ ps -ef | grep sqlplus
　　oracle    2238 10939  0 20:38 pts/0    00:00:00 grep sqlplus
　　oracle   29169 15849  0 19:52 pts/2    00:00:00 sqlplus   as sysdba
　　oracle   31296 30839  0 20:11 pts/1    00:00:00 sqlplus   as sysdba
　　关闭所有的sqlplus，重新应用补丁。
　　[oracle@db2server 14727310]$ opatch apply
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-38-57PM_1.log
　　Verifying environment and performing prerequisite checks...
　　OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310
　　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/oracle/product/db11.2.0.3')
　　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/db11.2.0.3'
　　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/db11.2.0.3'
　　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/db11.2.0.3'
　　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...
　　Applying sub-patch '14275605' to OH '/u01/app/oracle/product/db11.2.0.3'
　　ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
　　Patching component oracle.network.client, 11.2.0.3.0...
　　Patching component oracle.network.rsf, 11.2.0.3.0...
　　Patching component oracle.precomp.common, 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.rdbms.rman, 11.2.0.3.0...
　　Patching component oracle.rdbms.rsf, 11.2.0.3.0...
　　Patching component oracle.rdbms.util, 11.2.0.3.0...
　　Verifying the update...
　　Applying sub-patch '14727310' to OH '/u01/app/oracle/product/db11.2.0.3'
　　Patching component oracle.rdbms, 11.2.0.3.0...
　　Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
　　Patching component oracle.rdbms.deconfig, 11.2.0.3.0...
　　Patching component oracle.rdbms.rsf, 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...
　　Composite patch 14727310 successfully applied.
　　Log file location: /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-38-57PM_1.log
　　OPatch succeeded.
　　补丁应用成功。
　　[oracle@db2server 14727310]$ opatch lsinventory
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-50-55PM_1.log
　　Lsinventory Output file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2013-03-10_20-50-55PM.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  14727310     : applied on Sun Mar 10 20:46:01 CST 2013

　　Unique Patch>　　Patch description:  "Database Patch Set Update : 11.2.0.3.5 (14727310)"
　　Created on 8 Jan 2013, 00:29:36 hrs PST8PDT
　　Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
　　Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
　　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:
　　.....
　　Patch  13498243     : applied on Sun Mar 10 01:19:22 CST 2013

　　Unique Patch>　　Created on 17 Jan 2012, 06:37:29 hrs PST8PDT
　　Bugs fixed:
　　13498243
　　--------------------------------------------------------------------------------
　　OPatch succeeded.
　　从上面可以看出 PSU 11.2.0.3.5 包含了如下Sub-patch
　　Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
　　Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
　　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)"
　　[oracle@db2server 14727310]$ sqlplus / as sysdba

　　SQL*Plus:>　　Copyright (c) 1982, 2011, Oracle.  All rights reserved.

　　Connected to an>　　SQL> startup
　　ORACLE instance started.
　　Total System Global Area  184135680 bytes

　　Fixed>
　　Variable>　　Database Buffers           20971520 bytes
　　Redo Buffers                2433024 bytes
　　Database mounted.
　　Database opened.
　　SQL> select ACTION_TIME,ACTION,VERSION,COMMENTS from registry$history;
　　ACTION_TIME                    ACTION                         VERSION            COMMENTS
　　------------------------------ ------------------------------ ------------------ ------------------------------
　　07-MAR-13 10.29.06.238118 AM   VIEW INVALIDATE                                   view invalidation
　　07-MAR-13 10.29.11.700764 AM   UPGRADE                        11.2.0.3.0         Upgraded from 11.2.0.1.0
　　07-MAR-13 10.33.48.208350 AM   APPLY                          11.2.0.3           Patchset 11.2.0.2.0
　　SQL> @?/rdbms/admin/catbundle.sql psu apply
　　PL/SQL procedure successfully completed.
　　........................
　　SQL> select ACTION_TIME,ACTION,VERSION,COMMENTS from registry$history;
　　ACTION_TIME                    ACTION                         VERSION            COMMENTS
　　------------------------------ ------------------------------ ------------------ ------------------------------
　　07-MAR-13 10.29.06.238118 AM   VIEW INVALIDATE                                   view invalidation
　　07-MAR-13 10.29.11.700764 AM   UPGRADE                        11.2.0.3.0         Upgraded from 11.2.0.1.0
　　07-MAR-13 10.33.48.208350 AM   APPLY                          11.2.0.3           Patchset 11.2.0.2.0
　　10-MAR-13 08.58.27.118656 PM   APPLY                          11.2.0.3           PSU 11.2.0.3.5
　　如果使用了RMAN的CATALOG的话，别忘记更新CATALOG.
　　$ rman catalog username/password@alias
　　RMAN> UPGRADE CATALOG;PSU 11.2.0.3.5的补丁号是14727310，可以从MOS网站上下载到。
　　Patch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch.
　　11.2.0.3.5累积的，不需要安装前面的PSU补丁。
　　1、先决条件
　　PSU 11.2.0.3.5 patch 的安装需要首先安装ORACLE 11.2.0.3的RDBMS。
　　[oracle@db2server ~]$ sqlplus -version

　　SQL*Plus:>　　opatch版本必须11.2.0.3.0以上。
　　[oracle@db2server ~]$ opatch version
　　Invoking OPatch 11.2.0.1.7
　　OPatch Version: 11.2.0.1.7
　　OPatch succeeded.

　　可以从MOS上下载最新的opatch,PATCH>　　解压替换老的OPatch即可。
　　[oracle@db2server db11.2.0.3]$ mv OPatch/ OPatch_old
　　[oracle@db2server db11.2.0.3]$ unzip  /tmp/p6880880_112000_LINUX.zip  -d .
　　[oracle@db2server db11.2.0.3]$ opatch version
　　OPatch Version: 11.2.0.3.3
　　OPatch succeeded.
　　[oracle@db2server db11.2.0.3]$
　　2、安装
　　确保RDBMS相关的进程关闭。
　　[oracle@db2server db11.2.0.3]$ cd OPatch
　　[oracle@db2server OPatch]$ mkdir patchs
　　[oracle@db2server OPatch]$ cd patchs/
　　将下载的p14727310_112030_LINUX.zip 上传到服务器上。
　　[oracle@db2server patchs]$ ls -ltr
　　total 22444
　　-rw-r--r-- 1 oracle oinstall 22939052 Mar 12  2013 p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ unzip p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ ls -ltr
　　total 22448
　　drwxrwxr-x 7 oracle oinstall     4096 Jan  8 21:24 14727310
　　-rw-r--r-- 1 oracle oinstall 22939052 Mar 12  2013 p14727310_112030_LINUX.zip
　　[oracle@db2server patchs]$ cd 14727310
　　[oracle@db2server 14727310]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./  
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　PREREQ session
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-34-30PM_1.log
　　Invoking prereq "checkconflictagainstohwithdetail"
　　Prereq "checkConflictAgainstOHWithDetail" passed.
　　OPatch succeeded.
　　下面开始应用补丁。
　　[oracle@db2server 14727310]$ opatch apply
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-37-12PM_1.log
　　Verifying environment and performing prerequisite checks...
　　Prerequisite check "CheckActiveFilesAndExecutables" failed.
　　The details are:
　　Following executables are active :
　　/u01/app/oracle/product/db11.2.0.3/lib/libclntsh.so.11.1
　　UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
　　Log file location: /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-37-12PM_1.log
　　OPatch failed with error code 73
　　由于我本地的SQLPLUS没有全部关闭，导致libclntsh库文件还被占用，因此导致应用补丁失败。
　　[oracle@db2server 14727310]$ ps -ef | grep sqlplus
　　oracle    2238 10939  0 20:38 pts/0    00:00:00 grep sqlplus
　　oracle   29169 15849  0 19:52 pts/2    00:00:00 sqlplus   as sysdba
　　oracle   31296 30839  0 20:11 pts/1    00:00:00 sqlplus   as sysdba
　　关闭所有的sqlplus，重新应用补丁。
　　[oracle@db2server 14727310]$ opatch apply
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-38-57PM_1.log
　　Verifying environment and performing prerequisite checks...
　　OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310
　　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/oracle/product/db11.2.0.3')
　　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/db11.2.0.3'
　　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/db11.2.0.3'
　　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/db11.2.0.3'
　　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...
　　Applying sub-patch '14275605' to OH '/u01/app/oracle/product/db11.2.0.3'
　　ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
　　Patching component oracle.network.client, 11.2.0.3.0...
　　Patching component oracle.network.rsf, 11.2.0.3.0...
　　Patching component oracle.precomp.common, 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.rdbms.rman, 11.2.0.3.0...
　　Patching component oracle.rdbms.rsf, 11.2.0.3.0...
　　Patching component oracle.rdbms.util, 11.2.0.3.0...
　　Verifying the update...
　　Applying sub-patch '14727310' to OH '/u01/app/oracle/product/db11.2.0.3
　　Patching component oracle.rdbms, 11.2.0.3.0...
　　Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
　　Patching component oracle.rdbms.deconfig, 11.2.0.3.0...
　　Patching component oracle.rdbms.rsf, 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...
　　Composite patch 14727310 successfully applied.
　　Log file location: /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-38-57PM_1.log
　　OPatch succeeded.
　　补丁应用成功。
　　[oracle@db2server 14727310]$ opatch lsinventory
　　Oracle Interim Patch Installer version 11.2.0.3.3
　　Copyright (c) 2012, Oracle Corporation.  All rights reserved.
　　Oracle Home       : /u01/app/oracle/product/db11.2.0.3
　　Central Inventory : /u01/app/oraInventory
　　from           : /u01/app/oracle/product/db11.2.0.3/oraInst.loc
　　OPatch version    : 11.2.0.3.3
　　OUI version       : 11.2.0.3.0
　　Log file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/opatch2013-03-10_20-50-55PM_1.log
　　Lsinventory Output file location : /u01/app/oracle/product/db11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2013-03-10_20-50-55PM.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  14727310     : applied on Sun Mar 10 20:46:01 CST 2013

　　Unique Patch>　　Patch description:  "Database Patch Set Update : 11.2.0.3.5 (14727310)"
　　Created on 8 Jan 2013, 00:29:36 hrs PST8PDT
　　Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
　　Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
　　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:
　　13566938, 13593999, 10350832, 14138130, 12919564, 13624984, 13588248
　　13080778, 13804294, 14258925, 12873183, 13645875, 12880299, 14664355
　　14409183, 12998795, 14469008, 13719081, 13492735, 12857027, 14263036
　　14263073, 13742433, 13732226, 12905058, 13742434, 12849688, 12950644
　　13742435, 13464002, 12879027, 13534412, 14613900, 12585543, 12535346
　　12588744, 11877623, 12847466, 13649031, 13981051, 12582664, 12797765
　　14262913, 12923168, 13612575, 13384182, 13466801, 13484963, 11063191
　　13772618, 13070939, 12797420, 13041324, 12976376, 11708510, 13742437
　　13026410, 13737746, 13742438, 13326736, 13001379, 13099577, 14275605
　　13742436, 9873405, 9858539, 14040433, 12662040, 9703627, 12617123
　　12845115, 12764337, 13354082, 13397104, 12964067, 13550185, 12780983
　　12583611, 14546575, 13476583, 15862016, 11840910, 13903046, 15862017
　　13572659, 13718279, 13657605, 13448206, 13419660, 14480676, 13632717
　　14063281, 13430938, 13467683, 13420224, 14548763, 12646784, 14035825
　　12861463, 12834027, 15862021, 13377816, 13036331, 14727310, 13685544
　　13499128, 15862018, 12829021, 15862019, 12794305, 14546673, 12791981
　　13503598, 13787482, 10133521, 12718090, 13399435, 14023636, 12401111
　　13257247, 13362079, 12917230, 13923374, 14480675, 13524899, 13559697
　　14480674, 13916709, 14076523, 13773133, 13340388, 13366202, 13528551
　　12894807, 13343438, 13454210, 12748240, 14205448, 13385346, 15853081
　　12971775, 13035804, 13544396, 13035360, 14062795, 12693626, 13332439
　　14038787, 14062796, 12913474, 14841409, 14390252, 13370330, 14062797
　　13059165, 14062794, 12959852, 13358781, 12345082, 12960925, 9659614
　　13699124, 14546638, 13936424, 13338048, 12938841, 12658411, 12620823
　　12656535, 14062793, 12678920, 13038684, 14062792, 13807411, 12594032
　　13250244, 15862022, 9761357, 12612118, 13742464, 14052474, 13457582
　　13527323, 15862020, 12780098, 13502183, 13705338, 13696216, 10263668
　　15862023, 13554409, 15862024, 13103913, 13645917, 14063280, 13011409
　　Patch  13498243     : applied on Sun Mar 10 01:19:22 CST 2013

　　Unique Patch>　　Created on 17 Jan 2012, 06:37:29 hrs PST8PDT
　　Bugs fixed:
　　13498243
　　--------------------------------------------------------------------------------
　　OPatch succeeded.
　　从上面可以看出 PSU 11.2.0.3.5 包含了如下Sub-patch
　　Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
　　Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
　　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)"
　　[oracle@db2server 14727310]$ sqlplus / as sysdba

　　SQL*Plus:>　　Copyright (c) 1982, 2011, Oracle.  All rights reserved.

　　Connected to an>　　SQL> startup
　　ORACLE instance started.
　　Total System Global Area  184135680 bytes

　　Fixed>
　　Variable>　　Database Buffers           20971520 bytes
　　Redo Buffers                2433024 bytes
　　Database mounted.
　　Database opened.
　　SQL> select ACTION_TIME,ACTION,VERSION,COMMENTS from registry$history;
　　ACTION_TIME                    ACTION                         VERSION            COMMENTS
　　------------------------------ ------------------------------ ------------------ ------------------------------
　　07-MAR-13 10.29.06.238118 AM   VIEW INVALIDATE                                   view invalidation
　　07-MAR-13 10.29.11.700764 AM   UPGRADE                        11.2.0.3.0         Upgraded from 11.2.0.1.0
　　07-MAR-13 10.33.48.208350 AM   APPLY                          11.2.0.3           Patchset 11.2.0.2.0
　　SQL> @?/rdbms/admin/catbundle.sql psu apply
　　PL/SQL procedure successfully completed.
　　........................
　　SQL> select ACTION_TIME,ACTION,VERSION,COMMENTS from registry$history;
　　ACTION_TIME                    ACTION                         VERSION            COMMENTS
　　------------------------------ ------------------------------ ------------------ ------------------------------
　　07-MAR-13 10.29.06.238118 AM   VIEW INVALIDATE                                   view invalidation
　　07-MAR-13 10.29.11.700764 AM   UPGRADE                        11.2.0.3.0         Upgraded from 11.2.0.1.0
　　07-MAR-13 10.33.48.208350 AM   APPLY                          11.2.0.3           Patchset 11.2.0.2.0
　　10-MAR-13 08.58.27.118656 PM   APPLY                          11.2.0.3           PSU 11.2.0.3.5
　　如果使用了RMAN的CATALOG的话，别忘记更新CATALOG.
　　$ rman catalog username/password@alias
　　RMAN> UPGRADE CATALOG;