DBandRAC(11.2.0.3)PatchSetUpdate(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):