DBandRAC(11.2.0.3)PatchSetUpdate(11.2.0.3.6)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了DBandRAC(11.2.0.3)PatchSetUpdate(11.2.0.3.6),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4323字,纯文字阅读大概需要7分钟。
内容图文
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):
内容总结
以上是互联网集市为您收集整理的DBandRAC(11.2.0.3)PatchSetUpdate(11.2.0.3.6)全部内容,希望文章能够帮你解决DBandRAC(11.2.0.3)PatchSetUpdate(11.2.0.3.6)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。