DB and RAC(11.2.0.3 ) Patch Set Update(11.2.0.3.6 )

Oracle最新的PSU为11.2.0.3.6,本次升级为RAC和DB分别进行升级，为日后的RAC+DG环境做准备。

现在是2013年05月29日，Oracle最新的PSU为11.2.0.3.6,本次升级为RAC和DB分别进行升级，，为日后的RAC+DG环境做准备。
 
    系统:linux 5.7 x86_64
 
    数据库版本：11.2.0.3.0
 
单机升级ORACLE
 
    首先升级单机的DB到11.2.0.3.6：
 
    下载11.2.0.3.6的补丁包，补丁编号为16056266。
 
1.1  检查补丁冲突
 
用oracle用户unzip补丁包到ORACLE_HOME目录下。
 
[oracle@bogon db_1]$ cd 16056266/
 
[oracle@localhost 16056266]$ ../OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
 

Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-27_11-00-06AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 

1.2  检查当前数据库补丁历史
 
SQL> select action,comments from registry$history;
 
ACTION
 ------------------------------
 COMMENTS
 --------------------------------------------------------------------------------
 APPLY
 Patchset 11.2.0.2.0
 
APPLY
 Patchset 11.2.0.2.0
 
 
 
1.3 应用补丁进行升级
 
--升级前将数据库，监听及sqlplus都退出，否则在前置检查的时候会报错。
 
[oracle@bogon 16056266]$ ../OPatch/opatch apply
 Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 

Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
Verifying environment and performing prerequisite checks...
 OPatch continues with these patches:  13343438  13696216  13923374  14275605  14727310  16056266
 
Do you want to proceed? [y|n]
 Y
 
--单机PSU可以不需要MOS账号
 

  Composite patch 16056266 successfully applied.
  UtilSession: N-Apply done.
    --------------------------------------------------------------------------------
  The following warnings have occurred during OPatch execution:
    1) OUI-67215:
    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_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
    --------------------------------------------------------------------------------
    OUI-67008:OPatch Session completed with warnings.
    Finishing UtilSession at Tue May 28 11:10:43 CST 2013
    Log file location: /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
--虽然有告警，但依然安装成功
 
1.4 检查升级（PSU)后的版本
 
--查看当前补丁版本
 [oracle@localhost OPatch]$ ./opatch lspatches
16056266;Database Patch Set Update : 11.2.0.3.6 (16056266)
 

--查看当前补丁详细信息
 [oracle@localhost OPatch]$ ./opatch lsinventory
 Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 

Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-33-02AM_1.log
 
Lsinventory Output file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-05-28_11-33-02AM.txt
 
--------------------------------------------------------------------------------
 Installed Top-level Products (1):