百度360必应搜狗淘宝本站头条
当前位置:网站首页 > 技术资源 > 正文

Oracle 11g 单机环境安装补丁实战

lipiwang 2024-11-25 14:52 6 浏览 0 评论

一、概述

数据库作为企业的核心应用节点之一,其稳定性至关重要,但是一些产品bug对oracle数据库的使用产生很大的影响,有些bug,我们通过调整参数来规避,但是一些bug需要打补丁才能解决。 作为DBA,掌握给数据库打补丁是一项必备的技能,本文分享一下在 Oracle 11g 数据库上应用 PSU 补丁的步骤。

二、过程步骤

2.1 安装OPATCH 实用程序

1、从 Oracle 支持门户下载补丁。

2、验证补丁版本:

opatch 实用程序用于将补丁应用到数据库。所以在应用补丁之前,我们需要检查补丁是否支持现有的opatch版本。因此,请参阅补丁的自述文件以了解最低支持版本。

根据补丁自述文件:

1.2.1 OPatch 实用程序 您必须使用 OPatch 实用程序版本 11.2.0.3.6 或更高版本才能应用此补丁。Oracle 建议您使用适用于 11.2 的最新发布的 OPatch 版本,该版本可通过选择 11.2.0.0.0 版本从 My Oracle Support 补丁 6880880 下载。 有关 OPatch 文档的信息,包括任何已知问题,请参阅 My Oracle Support Document 293369.1 OPatch 文档列表。

所以对于这个补丁,opatch版本应该是11.2.0.3.6或者更高版本

让我们检查数据库中现有的 opatch 版本。

echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1

$ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.

现有版本为 11.2.0.3.4,低于要求的版本。所以我们需要安装所需的 opatch 实用程序。

3、安装 OPATCH 实用程序

  • 从 Oracle 支持链接下载 opatch 实用程序 – 6880880
  • 将 zip 复制到 ORACLE_HOME。
$ cp p6880880_112000_Linux-x86-64.zip $ORACLE_HOME/
  • 对现有的 OPatch 目录进行备份
cd $ORACLE_HOME
mv  OPatch  OPatch.bak
  • 解压缩 zip 文件。
unzip p6880880_112000_Linux-x86-64.zip
  • 检查opatch版本
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.19

OPatch succeeded.

现在让我们继续 PSU 补丁安装。

2.2 安装 PSU 补丁

1、复制并解压 PATCH ZIP 文件

unzip p27734982_112040_Linux-x86-64.zip
ls -ltr
total 243220
drwxr-xr-x 21 oracle oinstall 4096 May 31 12:49 27734982
-rw-rw-r-- 1 oracle oinstall 93035 Jul 17 13:15 PatchSearch.xml
-rw-r--r-- 1 oracle oinstall 140724601 Oct 8 09:17 p27734982_112040_Linux-x86-64.zip

2、再次检查 ORACLE_HOME 是否有冲突

- go to patch folder.
cd 27734982

[27734982]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-10-08_09-35-06AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

3、关闭数据库和侦听器

shutdown immediate;

lsnrctl stop LISTENER_DMCRM

注意– 如果任何 Goldengate 进程正在 ORACLE_HOME 上运行,那么这些进程都需要关闭。

4、检查活动的可执行文件

$ORACLE_HOME/OPatch/opatch prereq CheckActiveFilesAndExecutables -ph ./

[27734982]$ $ORACLE_HOME/OPatch/opatch prereq CheckActiveFilesAndExecutables -ph ./

Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-10-08_09-35-58AM_1.log

Invoking prereq "checkactivefilesandexecutables"

Prereq "checkActiveFilesAndExecutables" for patch 17478514 passed.

Prereq "checkActiveFilesAndExecutables" for patch 18031668 passed.

Prereq "checkActiveFilesAndExecutables" for patch 18522509 passed.

Prereq "checkActiveFilesAndExecutables" for patch 19121551 passed.

Prereq "checkActiveFilesAndExecutables" for patch 19769489 passed.

Prereq "checkActiveFilesAndExecutables" for patch 20299013 passed.

Prereq "checkActiveFilesAndExecutables" for patch 20760982 passed.

Prereq "checkActiveFilesAndExecutables" for patch 21352635 passed.

Prereq "checkActiveFilesAndExecutables" for patch 21948347 passed.

Prereq "checkActiveFilesAndExecutables" for patch 22502456 passed.

Prereq "checkActiveFilesAndExecutables" for patch 23054359 passed.

Prereq "checkActiveFilesAndExecutables" for patch 24006111 passed.

Prereq "checkActiveFilesAndExecutables" for patch 24732075 passed.

Prereq "checkActiveFilesAndExecutables" for patch 25869727 passed.

Prereq "checkActiveFilesAndExecutables" for patch 26609445 passed.

Prereq "checkActiveFilesAndExecutables" for patch 26392168 passed.

Prereq "checkActiveFilesAndExecutables" for patch 26925576 passed.

Prereq "checkActiveFilesAndExecutables" for patch 27338049 passed.

Prereq "checkActiveFilesAndExecutables" for patch 27734982 passed.

OPatch succeeded.

5、应用补丁

cd 27734982 $ORACLE_HOME/OPatch/ opatch apply


[27734982]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-10-08_09-36-41AM_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 24732075 25869727 26609445 26392168 26925576 27338049 27734982

Do you want to proceed? [y|n] ----------------------->> Press Y
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 ---- > Press Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')

Is the local system ready for patching? [y|n] -- >> Press Y
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db_1'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sdo, 11.2.0.4.0...

Patching component oracle.ctx.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/11.2.0/db_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)

Composite patch 27734982 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-10-08_09-36-41AM_1.log

OPatch completed with warnings.

修补完成。可以忽略警告。

6、验证补丁是否已经更新

$ORACLE_HOME/OPatch/opatch lsinventory

[27734982]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-10-08_09-41-09AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-10-08_09-41-09AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname:
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 27734982 : applied on Mon Oct 08 09:39:20 AST 2018
Unique Patch ID: 22229176
Patch description: "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
Created on 31 May 2018, 01:37:49 hrs PST8PDT
Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
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:
21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557
17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166
18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842
17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736
17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145
16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419
17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694
8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092
24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890
17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741
21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429
19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828
6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390
26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850
18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849
18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690
16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112
20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095
14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905
17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568
20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136
21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207
18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391
19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344
17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699
19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936
17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163
17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893
19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627
16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031
20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678
18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862
17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760
17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762
14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556
20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584
21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209
17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921
17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164
17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143
21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496
18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036
17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514
27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837
16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953
17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160
20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509
25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602
20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537
14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422
25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148
18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130
20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625
18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259
18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762
18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853
11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893
12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721
16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269
17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889
21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460
24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979
16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175
16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671
17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995
21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023
24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502
27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721
21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983
21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417
18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265
13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813
20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277
17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124
16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550
13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271
18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354
12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647
17235750, 21168487, 16220077, 16929165


--------------------------------------------------------------------------------

OPatch succeeded.

7、启动数据库和监听器

STARTUP

lsnrctl start LISTENER_DMCRM

8、运行补丁后脚本

cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@catbundle.sql psu apply
quit

9、编译无效对象

$ORACLE_HOME/rdbms/admin/utlrp.sql

10、检查补丁情况

select action_time,action from dba_registry_history;

ACTION_TIME ACTION
--------------------------------------------------------------------------- ------------------------------
21-APR-15 08.52.24.728992 AM APPLY
08-OCT-18 09.43.41.923815 AM APPLY

2 rows selected.

三、小结

本文分享了非RAC数据库的打补丁的详细过程,随手一记,以备不时之需。

相关推荐

软件测试|MySQL CROSS JOIN:交叉连接的详细解析

简介在MySQL数据库中,CROSSJOIN是一种用于生成两个或多个表的笛卡尔积的连接方法。CROSSJOIN不需要任何连接条件,它将左表的每一行与右表的每一行进行组合,从而生成一个包含所...

「MySQL笔记」left join-on-and 与 left join-on-where 的区别

1.摘要关于这两种写法的重要知识点摘要如下:left-join时,即使有相同的查询条件,二者的查询结果集也不同,原因是优先级导致的,on的优先级比where高on-and是进行韦恩运算连接...

MySQL中的JOIN——联合查询的基本语法

MySQL中的JOIN指令用来将两个或多个表中的数据进行联合查询,根据连接条件来匹配记录,从而得到需要的结果集。在MySQL中,常见的JOIN类型包括INNERJOIN、LEFTJOIN和RIGH...

MySQL 中的 CROSS JOIN:强大的连接工具

CROSSJOIN在MySQL里是一种挺特别的连接操作,它能弄出连接表的笛卡尔积。这就是说,要是表A有m行,表B有n行,那ACROSSJOINB的结果就会有m*n...

大厂必问:MySQL 三表 JOIN 操作的解析与性能优化,效率又如何?

大厂必问:MySQL三表JOIN操作的解析与性能优化策略,效率又如何?点击关注,开启技术之旅!大家好,这里是互联网技术学堂,无论你是一名程序员、设计师、还是对技术充满好奇心的普通人,都欢迎你加入...

面试题:MySQL 的 JOIN 查询优化(mysql查询优化方法)

MySQL的JOIN查询优化是提升数据库性能的关键环节。以下是综合多个技术文档的核心优化策略,按优先级和实现难度分类:一、索引优化:性能提升的基础为连接字段建立索引确保参与JOIN的列(通常...

Flink中处理维表关联技术实现路径

在Flink中处理维表关联大体氛围TableSQLLookupJoin和DataStream算子函数,主要技术实现路径:I.FlinkSQL/TableAPI中的Lookup...

深入剖析Zookeeper原理(一)整体设计

1.ZK集群架构设计与特性1.ZK集群架构设计:ZK主要分为三种角色:Leader(领导者):一个Zookeeper集群同一时间只会有一个实际工作的Leader,它会发起并维护与各Follwer及...

多种负载均衡算法及其Java代码实现

首先给大家介绍下什么是负载均衡负载均衡建立在现有网络结构之上,它提供了一种廉价有效透明的方法扩展网络设备和服务器的带宽、增加吞吐量、加强网络数据处理能力、提高网络的灵活性和可用性。负载均衡,英...

一分钟了解SpringCloud中的ribbon到底是什么,原理是啥?

1.概念ribbon是一款客户端负载均衡器,用于微服务之间的负载均衡。首先,什么是客户端负载均衡?如图,ribbon可以通过注册中心获取服务列表,然后自己执行自己的负载均衡策略来决定要访问哪个微服务,...

Step by Step之腾讯云短信-验证码实践

在商城小程序和前端上线用了一阵子之后,用户提出了体验提升的需求,如忘记密码、绑定用户、快捷注册等,作为业界最佳实践的短信验证码登录、重置密码和注册等功能开发也就提上日程了,本文就以重置密码为例,将验证...

10分钟入门响应式:Springboot整合kafka实现reactive

Springboot引入Reactor已经有一段时间了,笔者潜伏在各种技术群里暗中观察发现,好像scala圈子的同仁们,似乎对响应式更热衷一点。也许是因为他们对fp理解的更深吧,所以领悟起来障碍性更少...

使用java随机生成有个性的用户名,LOL地名+水浒传,合计2808个

*随机生成用户名*取水浒传108好汉名字*取LOL地名26个,组合而成*一共可以生成2808个不同特色的用户名如果你在上网的时候,用户名难取的话,这里有很多可选择的用户名,现提供100个...

深入理解Math.random()的概率分布特性

直接上源码/***Returnsa{@codedouble}valuewithapositivesign,*返回一个带符号的double类型的数字,说人话就是返回一个非负...

编程英文 - 创建/生成/构建 (create/generate/build)

在软件开发中,create、generate和build这三个词经常被用到,它们都与"创造"或"产生"某些东西有关,但在具体使用场景和含义上有所不同。基本含义creat...

取消回复欢迎 发表评论: