当前位置:操作系统 > Unix/Linux >>

11.2.0.3.7 PSU补丁升级

11.2.0.3.7 PSU补丁升级
 
说明:这是新上线主机,还没有建库的。如果库已经存在,那么最后还要进行刷库操作呢!
 
环境:SUSE Linux Enterprise Server 11 sp1 (x86_64)
要求将数据库从11.2.0.3.0升级到11.2.0.3.7 PSU(最新),补丁为:16619892
p16619892_112030_Linux-x86-64.zip
 
用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 http://www.oracle.com/support/policies.html 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...
 
 
Verifying the update...
Applying sub-patch '14275605' to OH '/opt/oracle/product/11gR2/db'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.
 
 
Patching component oracle.network.client, 11.2.0.3.0...
 
 
Patching component oracle.network.rsf, 11.2.0.3.0...
 
 
Patching component oracle.precomp.common, 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.rdbms.rman, 11.2.0.3.0...
 
 
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
 
 
Patching component oracle.rdbms.util, 11.2.0.3.0...
 
 
Verifying the update...
Applying sub-
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,