DB and RAC(11.2.0.3 ) Patch Set Update(11.2.0.3.6 ) - 数据库编程

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)

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