linuxsir首页 LinuxSir.Org | Linux、BSD、Solaris、Unix | 开源传万世,因有我参与欢迎您!
网站首页 | 设为首页 | 加入收藏
您所在的位置:主页 > Linux数据库 >

Oracle 11.2.0.4打PSU补丁到 11.2.0.4.161018

时间:2016-12-22  来源:未知  作者:linuxsir首页

最近生产上要给Oracle数据库打11g最新的补丁,这里先做一个测试记录一下。

Oracle数据库所有补丁的MOS文档ID 1922396.1下载地址:https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=242245405602967&id=1577380.1&_afrWindowMode=0&_adf.ctrl-state=zv36z4hoo_53这个下载需要有MOS账号

Oracle数据库的补丁有几种:PSU、SPU、CPU等,这次打的PSU24006111 (11.2.0.4.161018)

平台:OS Linux6.7 x86-64+Oracle 11.2.0.4.0单实例

升级方法已经在补丁包里的README.html文档里写的很清楚了,这里只是做个演示。

1、下载最新的的PSU包和最新的OPatch包,上传到服务器上

p24006111_112040_Linux-x86-64.zip

p6880880_112000_Linux-x86-64.zip

2、解压压缩包,并把OPatch替换原ORACLE_HOME里的OPatch目录

[oracle@rhel6 psu]$ unzip p24006111_112040_Linux-x86-64.zip
[oracle@rhel6 psu]$ unzip p6880880_112000_Linux-x86-64.zip
[oracle@rhel6 psu]$ ls -l |grep ^d
drwxrwxr-x 14 oracle oinstall      4096 Aug 26 21:56 24006111
drwxr-x--- 10 oracle oinstall      4096 Aug 18  2015 OPatch
[oracle@rhel6 psu]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
[oracle@rhel6 psu]$ mv OPatch/ $ORACLE_HOME

3、配置OPatch的环境变量

[oracle@rhel6 psu]$ vi ~/.bash_profile
#添加
export PATH=$PATH:$ORACLE_HOME/OPatch
[oracle@rhel6 psu]$ source ~/.bash_profile
[oracle@rhel6 psu]$ which opatch
/u02/app/oracle/product/11.2.4/db1/OPatch/opatch
#查看当前数据库的补丁情况
[oracle@rhel6 psu]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
 
 
Oracle Home      : /u02/app/oracle/product/11.2.4/db1
Central Inventory : /u01/app/oraInventory
  from          : /u02/app/oracle/product/11.2.4/db1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-45-47AM_1.log
 
Lsinventory Output file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_10-45-47AM.txt
 
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rhel6
ARU platform id: 226
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1):
 
Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.
 
 
There are no Interim patches installed in this Oracle Home.
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.

4、升级前检查是否有冲突

[oracle@rhel6 psu]$ cd 24006111/
[oracle@rhel6 24006111]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home      : /u02/app/oracle/product/11.2.4/db1
Central Inventory : /u01/app/oraInventory
  from          : /u02/app/oracle/product/11.2.4/db1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-49-53AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.

5、安装Patch包,单实例的数据库按如下方法打patch就可以了,如果是RAC则需要详细查看README.html

[oracle@rhel6 psu]$ cd 24006111/
[oracle@rhel6 24006111]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
 
 
Oracle Home      : /u02/app/oracle/product/11.2.4/db1
Central Inventory : /u01/app/oraInventory
  from          : /u02/app/oracle/product/11.2.4/db1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log
 
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
 
 
Following executables are active :
/u02/app/oracle/product/11.2.4/db1/bin/oracle
/u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log
 
OPatch failed with error code 73
#打补丁报错,查看日志
[oracle@rhel6 24006111]$ more /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log
......
[Dec 20, 2016 10:53:21 AM]  Following executables are active :
                            /u02/app/oracle/product/11.2.4/db1/bin/oracle
                            /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1
[Dec 20, 2016 10:53:21 AM]  Prerequisite check "CheckActiveFilesAndExecutables" failed.
                            The details are:
                             
                             
                            Following executables are active :
                            /u02/app/oracle/product/11.2.4/db1/bin/oracle
                            /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1
......
#这个错误的意思是检测到有命令正在运行,不能进行升级,停止数据库和监听
[oracle@rhel6 24006111]$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 20 10:57:16 2016
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
sys@ORCL>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@ORCL>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rhel6 24006111]$ lsnrctl stop
 
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-DEC-2016 10:58:32
 
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The command completed successfully
[oracle@rhel6 24006111]$ ps -ef |grep ora
root      2361  2342  0 10:11 pts/0    00:00:00 su - oracle
oracle    2362  2361  0 10:11 pts/0    00:00:01 -bash
oracle    3409  2362  0 10:59 pts/0    00:00:00 ps -ef
oracle    3410  2362  0 10:59 pts/0    00:00:00 grep ora
#重新打补丁
[oracle@rhel6 24006111]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
 
 
Oracle Home      : /u02/app/oracle/product/11.2.4/db1
Central Inventory : /u01/app/oraInventory
  from          : /u02/app/oracle/product/11.2.4/db1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-18-32AM_1.log
 
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:  17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111 
 
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 = '/u02/app/oracle/product/11.2.4/db1')
 
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u02/app/oracle/product/11.2.4/db1'
......
Composite patch 24006111 successfully applied.
Log file location: /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-18-32AM_1.log
 
OPatch succeeded.

6、升级数据字典并重新编译无效对象

[oracle@rhel6 24006111]$ sqlplus / as sysdba
idle>startup
......
idle>@?/rdbms/admin/catbundle.sql psu apply
.......
idle>SPOOL off
idle>SET echo off
Check the following log file for errors:
/u02/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2016Dec20_11_30_47.log
#检查??志没有报错
#编译失效对象
sys@ORCL>@?/rdbms/admin/utlrp.sql
#检查升级情况
sys@ORCL>col action_time for a30
sys@ORCL>col action for a10
sys@ORCL>col namespace for a20
sys@ORCL>col version for a20
sys@ORCL>col bundle_series for a30
sys@ORCL>col comments for a30
sys@ORCL>select * from dba_registry_history;
 
ACTION_TIME            ACTION      NAMESPACE          VERSION              ID BUNDLE_SERIES            COMMENTS
------------------------------ ---------- -------------------- -------------------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45.119862 PM  APPLY    SERVER        11.2.0.4              0 PSU                  Patchset 11.2.0.2.0
07-JUL-16 11.03.29.165250 AM  APPLY    SERVER        11.2.0.4              0 PSU                  Patchset 11.2.0.2.0
20-DEC-16 11.32.28.671654 AM  APPLY    SERVER        11.2.0.4        161018 PSU              PSU 11.2.0.4.161018
#使用opatch命令查看补丁情况
[oracle@rhel6 24006111]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
 
 
Oracle Home      : /u02/app/oracle/product/11.2.4/db1
Central Inventory : /u01/app/oraInventory
  from          : /u02/app/oracle/product/11.2.4/db1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version      : 11.2.0.4.0
Log file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-52-01AM_1.log
 
Lsinventory Output file location : /u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_11-52-01AM.txt
 
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rhel6
ARU platform id: 226
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1):
 
Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.
 
 
Interim patches (1) :
 
Patch  24006111    : applied on Tue Dec 20 11:24:30 CST 2016
Unique Patch ID:  20508568
Patch description:  "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
  Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  Bugs fixed:
    17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699
    17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728
    17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677
    17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750
    17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971
    20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344
    14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952
    18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630
    23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334
    17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671
    17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973
    17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687
    17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839
    18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502
    19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741
    17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226
    16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447
    17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229
    18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426
    18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676
    16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247
    20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574
    21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693
    17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950
    18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274
    22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382
    21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756
    20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665
    18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
    17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
    20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
    17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560
    17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634
    18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
    17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
    19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995
    22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719
    18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979
    16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741
    13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721
    17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522
    16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369
    17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842
    14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191
    17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024
    17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234
    19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005
    18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491
    17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054
    17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214
    17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926
    18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225
    17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946
    17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227
    18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192
    17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422
    18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485
    18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991
    14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673
    16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945
    20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858
    17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813
    20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271
    17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760
    18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996
    14852021, 17853456, 18674047, 12364061, 22195448
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.

7、升级失败回滚

opatch rollback -id 24006111

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

友情链接
  • Mozilla发布Firefox 67.0.4,修复沙箱逃逸漏洞
  • 蚂蚁金服正式成为CNCF云原生计算基金会黄金会员
  • Firefox 68将采用Microsoft BITS安装更新
  • OpenSSH增加对存储在RAM中的私钥的保护
  • 谷歌想实现自己的curl,为什么?
  • Raspberry Pi 4发布:更快的CPU、更大的内存
  • Firefox的UA将移除CPU架构信息
  • Ubuntu放弃支持32位应用程序实属乌龙,Steam会否重回Ubuntu怀抱
  • Qt 5.13稳定版发布:引入glTF 2.0、改进Wayland以及支持Lottie动
  • 红帽企业Linux 7现已内置Redis 5最新版
  • Slack进入微软内部禁用服务清单,GitHub也在其列?
  • 安全的全新编程语言V发布首个可用版本
  • Windows Terminal已上架,快尝鲜
  • 阿里巴巴微服务开源生态报告No.1
  • 面世两年,Google地球将支持所有基于Chromium的浏览器
  • 推进企业容器化持续创新,Rancher ECIC千人盛典完美收官
  • CentOS 8.0最新构建状态公布,或于数周后发布
  • Debian移植RISC
  • 微软拆分操作系统的计划初现雏形
  • Oracle发布基于VS Code的开发者工具,轻松使用Oracle数据库
  • Ubuntu 19.10停止支持32位的x86架构
  • 微软为Windows Terminal推出全新logo
  • 联想ThinkPad P系列笔记本预装Ubuntu系统
  • 微软发布适用于Win7/8的Microsoft Edge预览版
  • 启智平台发布联邦学习开源数据协作项目OpenI纵横
  • 经过六个多月的延迟,微软终于推出Hyper
  • ZFS On Linux 0.8.1 发布,Python可移植性工作
  • DragonFly BSD 5.6.0 发布,HAMMER2状态良好
  • Linux Kernel 5.2
  • CentOS 8.0 看起来还需要几周的时间
  • 百度网盘Linux版正式发布
  • PCIe 6.0宣布:带宽翻倍 狂飙至256GB/s
  • PHP 7.4 Alpha 发布,FFI扩展,预加载Opcache以获得更好的性能
  • Canonical将在未来的Ubuntu版本中放弃对32位架构的支持
  • Scala 2.13 发布,改进的编译器性能
  • 微软的GitHub收购了Pull Panda,并且使所有订阅完全免费
  • Windows Subsystem for Linux 2 (WSL 2)现在适用于Windows 10用
  • Debian 10 “Buster”的RISC
  • MariaDB宣布发布MariaDB Enterprise Server 10.4
  • DXVK 1.2.2 发布,带来微小的CPU开销优化
  • DragonFlyBSD 5.6 RC1 发布,VM优化,默认为HAMMER2
  • PrimeNG 8.0.0 发布,支持Angular 8,FocusTrap等
  • GIMP 2.10.12 发布,一些有用的改进
  • 清华大学Anaconda 镜像服务即将恢复
  • Debian GNU/Linux 10 “Buster” 操作系统将于2019年7月6日发布
  • 时时彩论坛
  • 五星体育斯诺克
  • 北单比分直播
  • 河北11选5走势图
  • 福建体彩36选7开奖结果
  • 九龙图库下载