首页 >

Oracle 11.2.0.3.7 PSU补丁升级

数据库|mysql教程Oracle 11.2.0.3.7 PSU补丁升级
Oracle升级,Oracle 11.2.0.3.7,Ora
数据库-mysql教程
仿qq java源码,vscode中文下载,ubuntu查看文件,怎么下载tomcat,sqlite 导出,网页设计项目介绍是写什么,sql数据库更新,阿里云服务器 不稳定,兼容性高的轮播图插件,好看前端框架,go 爬虫,php json,seo引擎搜索优化,springboot直接访问html,关键词 与标签,jquery京东浮动网站楼层导航代码,特别炫的网页,选项框模板,aspcms 修改后台地址,大转盘页面,jsp商品管理系统代码,微信点菜小程序源码lzw
SUSE Linux Enterprise Server 11 sp1 (x86_64),要求将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU(最新),补丁为:166198
宝石迷阵 源码,vscode开发umi,Ubuntu所有应用死机,tomcat咋搭建,sqlite下载官网,joomla瀑布流插件,企业官网 框架前端,vue调用python爬虫,php ==null,短网址 seo,网站首页底部弹窗代码,游戏官网网页模板,织梦模板有哪些文件,css 整个页面高度,主机管理系统源码,主成分分析matlab源程序lzw
仿百度搜索引擎 源码,ubuntu免光盘安装,防火墙阻止tomcat,神箭手 爬虫 融资,破解php模拟登录,商丘seo整站优化排名要多少钱lzw

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

环境: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…


Oracle 11.2.0.3.7 PSU补丁升级
  • Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记
  • Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记 | Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记 ...

    Oracle 11.2.0.3.7 PSU补丁升级
  • Oracle 11g R2单机升级步骤
  • Oracle 11g R2单机升级步骤 | Oracle 11g R2单机升级步骤 ...

    Oracle 11.2.0.3.7 PSU补丁升级
  • OCM_简化安装Oracle10.2.0.1.0以及升级为10.2.0.2.0
  • OCM_简化安装Oracle10.2.0.1.0以及升级为10.2.0.2.0 | OCM_简化安装Oracle10.2.0.1.0以及升级为10.2.0.2.0 ...