DB and RAC(11.2.0.3 ) Patch Set Update(11.2.0.3.6 )
- WBOYOriginal
- 2016-06-07 17:29:20979browse
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):