视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
Oracle11.2.0.3.7PSU补丁升级
2020-11-09 10:41:31 责编:小采
文档


SUSE Linux Enterprise Server 11 sp1 (x86_),要求将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU(最新),补丁为:166198

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

环境:SUSE Linux Enterprise Server 11 sp1 (x86_)

要求将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU(最新),补丁为:166192
p166192_112030_Linux-x86-.zip

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

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

这个PSU对OPatch有要求,要用11.2.0.3.0之后版本的OPatch,,这个OPatch的补丁号为6880880。那么就要下载这个OPatch补丁了:
p6880880_112000_Linux-x86-.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-.zip

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


补丁冲突检查:

oracle@tb-dinggou3:~/softs/166192> 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/166192> 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 166192


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...

下载本文
显示全文
专题