Oracle11.2.0.3.7PSU补丁升级

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle11.2.0.3.7PSU补丁升级，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4384字，纯文字阅读大概需要7分钟。

内容图文

SUSE Linux Enterprise Server 11 sp1 (x86_64)，要求将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU（最新），补丁为：166198

说明：这是新上线主机，还没有建库的。如果库已经存在，那么最后还要进行刷库操作呢！

环境：SUSE Linux Enterprise Server 11 sp1 (x86_64)

要求将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU（最新），补丁为：16619892
p16619892_112030_Linux-x86-64.zip

推荐阅读：Oracle数据库服务器升级内存需要考虑的问题

用oracle用户解压后：
oracle@tb-dinggou3:~/softs> unzip p16619892_112030_Linux-x86-64.zip
oracle@tb-dinggou3:~/softs> ls
16619892 p16619892_112030_Linux-x86-64.zip
oracle@tb-dinggou3:~/softs> cd 16619892/
oracle@tb-dinggou3:~/softs/16619892> ls
13343438 13696216 13923374 14275605 14727310 16056266 16619892 patchmd.xml README.html README.txt

这个PSU对OPatch有要求，要用11.2.0.3.0之后版本的OPatch，，这个OPatch的补丁号为6880880。那么就要下载这个OPatch补丁了：
p6880880_112000_Linux-x86-64.zip
然后进行OPatch替换：
oracle@tb-dinggou3:~/softs> cd $ORACLE_HOME
oracle@tb-dinggou3:/opt/oracle/product/11gR2/db> mv OPatch OPatch_bak
oracle@tb-dinggou3:/opt/oracle/product/11gR2/db> unzip p6880880_112000_Linux-x86-64.zip

oracle@tb-dinggou3:/opt/oracle/product/11gR2/db> opatch version
OPatch Version: 11.2.0.3.4

补丁冲突检查：

oracle@tb-dinggou3:~/softs/16619892> 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 : /opt/oracle/product/11gR2/db
Central Inventory : /opt/oraInventory
from : /opt/oracle/product/11gR2/db/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.3.0
Log file location : /opt/oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-08-20_04-52-55AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

没有补丁冲突。

补丁应用：

oracle@tb-dinggou3:~/softs/16619892> opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /opt/oracle/product/11gR2/db
Central Inventory : /opt/oraInventory
from : /opt/oracle/product/11gR2/db/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.3.0
Log file location : /opt/oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-08-20_04-53-08AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/11gR2/db')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/opt/oracle/product/11gR2/db'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/opt/oracle/product/11gR2/db'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/opt/oracle/product/11gR2/db'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

内容总结

以上是互联网集市为您收集整理的Oracle11.2.0.3.7PSU补丁升级全部内容，希望文章能够帮你解决Oracle11.2.0.3.7PSU补丁升级所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---