打补丁21255373(Restart)
grid由12.1.0.2升级到12.2.0.1的时候需要安装补丁包
这里提示补丁需要在旧的oracle_home目录下打补丁的
解压:
[root@localhost soft]# unzip p21255373_121020_Linux-x86-64.zip
1.root用户下打补丁
[root@localhost 21255373]# /u01/grid/grid_home/12.1.0.2/OPatch/opatchauto apply /soft/21255373
OPatch Automation Tool
Copyright (c) 2021, Oracle Corporation. All rights reserved.
OPatchauto version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Running from : /u01/grid/grid_home/12.1.0.2
opatchauto log file: /u01/grid/grid_home/12.1.0.2/cfgtoollogs/opatchauto/21255373/opatch_gi_2021-02-20_02-21-52_deploy.log
Parameter Validation: Successful
Grid Infrastructure home:
/u01/grid/grid_home/12.1.0.2
Configuration Validation: Successful
Patch Location: /soft/21255373
Grid Infrastructure Patch(es): 21255373
RAC Patch(es): 21255373
Patch Validation: Successful
Stopping CRS ... Successful
Applying patch(es) to "/u01/grid/grid_home/12.1.0.2" ...
Patch "/soft/21255373/21255373" successfully applied to "/u01/grid/grid_home/12.1.0.2".
Starting CRS ... Successful
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /u01/grid/grid_home/12.1.0.2: 21255373
opatchauto succeeded.
2.查看打补丁情况
[grid@localhost OPatch]$ ./opatch lsinv Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/grid/grid_home/12.1.0.2 Central Inventory : /u01/grid/oraInventory from : /u01/grid/grid_home/12.1.0.2/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location : /u01/grid/grid_home/12.1.0.2/cfgtoollogs/opatch/opatch2021-02-20_02-36-51AM_1.log
Lsinventory Output file location : /u01/grid/grid_home/12.1.0.2/cfgtoollogs/opatch/lsinv/lsinventory2021-02-20_02-36-51AM.txt
-------------------------------------------------------------------------------- Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21255373 : applied on Sat Feb 20 02:26:04 EST 2021 Unique Patch ID: 19853332 Patch description: "OCW Patch Set Update : 12.1.0.2.0 (21255373)" Created on 18 Sep 2017, 08:26:25 hrs PST8PDT Bugs fixed: 21339083, 19701617, 18589889, 20768643, 19280860, 19139608, 19061429 19133945, 19521169, 19341538, 20011424, 18946768, 19135521, 18604143 19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221 20177779, 19699720, 19266658, 19168690, 18899171, 19244316, 19653795 18330979, 19471722, 19027351, 18634372, 21227730, 19536337, 18707416 19184188, 19131709, 21113068, 20235486, 20160490, 19925992, 20995001 20006646, 18991776, 18439295, 19380733, 21245437, 20552947, 18943696 19591984, 19550195, 19163425, 18135723, 20014326, 19524857, 18849021 18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283 19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19682695 19050688, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228 18980002, 18922918, 19683886, 18956780, 19325604, 19026993, 18777835 17338864, 18261648, 18945906, 19513650, 20185476, 19702758, 18952577 18882642, 19414274, 17447588, 20752167, 19262534, 19147513, 21242118 19473088, 20758997, 19178517, 18729269, 19659885, 19529729, 19455563 20877072, 19319904, 18703978, 20340620, 18536826, 19700256, 19703246 19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037 19479503, 19147751, 19029647, 19179158, 18901356, 19140712, 20012766 21232394, 18964974, 18835366, 19184276, 19207286, 19013789, 20510208 20001507, 18950232, 20079414, 19680763, 19259765, 19148791, 19556820 19449737, 18962892, 21646169, 19187515, 19513888, 19230771, 14661880 21519340, 21222147, 20795241, 20218012, 19853036, 19453778, 19551830 21616278, 19068333, 18843572, 18520351, 19185148, 18945435, 20775015 19232454, 18541110, 19319192, 18834955, 19204743, 20839581, 19178629 19304104, 19140891, 18747335, 20676340, 19457575, 19270660, 21297657 19069755, 19021575, 18715884, 19584688, 18798573, 19812592, 19018001 19325701, 19292272, 19270956, 20877003, 19222693, 18700893, 21276514 19662663, 18406774, 19684131, 19010177, 21082737, 19272663, 18907170 18910576, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828 19331454, 19155350, 20119857, 19703199, 18508710, 18955644, 19908346 18798432, 19146822, 21123424, 19589221, 19471836, 19537762, 16286734 20669114, 18762843, 18945249, 19045143, 19146980, 19184799, 19601003 19205086, 20099624, 19351363, 21378016, 20091753, 19537547, 18862203 19281106, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741 19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351 20219458, 18843054, 19150313, 18708349, 18953639, 19332386, 21423055 21259359, 19067804, 19371270, 19203996, 20038431, 18747382, 19054979 19209951, 19318983, 19154673, 18752378, 19150088, 19370846, 19013444 21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747 19367276, 19632437, 19874047, 19612597, 18990354, 19288396, 19557558 19427050, 19127078, 18910443, 20053557, 20033787, 19315567, 19444471 19148982, 18290252, 19915945, 18813323, 19777496, 19500293, 18643483 18523468, 19134098, 19277814, 20562133, 21420753, 19071526, 18965694 19226858, 18850051, 19602208, 19591356, 20061168, 18417590, 19370739 18920408, 19609388, 18636884, 20136892, 18776786, 18989446, 19148793 19043795, 19585454, 20746507, 19955755, 18317489, 18260170, 18919682 19059053, 19807548, 18678829, 19124972, 19617592, 18910748, 18849896 19147509, 18953878, 19076165, 19273758, 19319357, 19704993, 19498411 18999195, 18759724, 19459023, 20634511, 21474380, 20276459, 19066844 17208793, 19234907, 20290467, 13843841, 19538714, 19649640, 19383028 19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 20293730 19986391, 18304090, 19343245, 19314048, 19473851, 18834934, 19241655 18242738, 19458082, 19470791, 18894342, 20649573, 18372060, 19522067 18953889, 18827679, 19023430, 19140711, 19259290, 19045388, 20186278 19241857, 19522571, 19076778, 19709663, 18875012, 18861564, 19066699 19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186 21394146, 19916737, 19049721, 19368917, 21255373, 19635215, 20408163 18868829, 22024217, 20783416, 19315522, 19141785, 19885321, 19163887 19820247, 20363708, 18852058, 18715868, 19538241, 19804032
--------------------------------------------------------------------------------
OPatch succeeded. |
3.补丁回滚
回滚操作必须参考补丁的readme文件
1.停掉数据库
[oracle@localhost ~]$ srvctl stop database -d restart
2.执行roothas.pl命令(root用户)
#/u01/grid/grid_home/12.1.0.2/crs/install/roothas.pl -prepatch
3.回滚(grid用户)
$/u01/grid/grid_home/12.1.0.2/OPatch/opatch rollback -local -id 21255373 -oh /u01/grid/grid_home/12.1.0.2
4.步骤
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
root用户执行
/u01/grid/grid_home/12.1.0.2/rdbms/install/rootadd_rdbms.sh
# <GI_HOME>/crs/install/roothas.pl -postpatch
root用户执行
#/u01/grid/grid_home/12.1.0.2/crs/install/roothas.pl -postpatch
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
2020-02-20 表空间传输-例子2(full transportable)
2020-02-20 表空间传输-例子3(rman-transport获取传输表空间文件)
2020-02-20 transport_datafiles与FLASHBACK_SCN不能一起使用
2020-02-20 表空间传输数据文件转换
2019-02-20 非认证转模式换成认证模式数据库账号创建
2019-02-20 mongodb主从(副本集附仲裁节点)部署带认证模式