liunx7 oracle 11g rac 应用patch 28429134

近期公司打算新上线一套系统，领导说这次的存储性能很强悍（确实很强，而且自带压缩去重功能），系统使用的是liunx7版本，由于和liunx6的内核结构不同，所以liunx7安装11grac有一些坑比如执行crs脚本时提提示ohas进程异常，最终导致crs脚本执行失败，crs安装失败：此处除了其他方法外可以使用一个patch补丁避免:18370031，该补丁避免crs执行脚本异常报错，但也给后面打28429134补丁埋了坑。

系统:redhat7.6

数据库版本:11.2.0.4.0

patch:28429134

新建的环境，肯定没补丁，先看了一下28429134补丁要求OPatch版本是:简单地说必须大于11.2.0.3.6，搞个opatch备份切换上去就行了

1.打OPatch---各节点执行

将p6880880_112000_Linux-x86-64.zip（最新的Opatch）拷贝到oracle_home和grid_home下面，解压覆盖。

DB:

注意使用oracle用户解压

[oracle@db1 ~]$cd /tmp/orasoftware/

[oracle@db1 ~]$ unzip -q p6880880_112000_Linux-x86-64.zip 

[oracle@db_1]$cd /u01/app/oracle/product/11.2.0/db_1

[oracle@db_1]$mv OPatch OPatch.bak

[root@db1 ]# chmod 755 OPatch

[oracle@db_1]$ cp -rp /tmp/orasoftware/OPatch/ .
[oracle@db_1]$ ./OPatch/opatch version

OPatch Version: 11.2.0.3.12

GI:

[grid@db1 ~]$ unzip -q p6880880_112000_Linux-x86-64.zip 

root@db1 ~]# cd /u01/11.2.0/grid/

root@db1 grid]# mv OPatch OPatch.bak

[root@db1 grid]# chmod 755 OPatch

[root@db1 grid]# mv OPatch /u01/11.2.0/grid/

[grid@qdb1 ~]$ /u01/11.2.0/grid/OPatch/opatch version
OPatch Version: 11.2.0.3.12

 

2.安装28429134-各节点执行

 

patch 28429134信息

[root@db1 soft]$unzip -q p28429134_112040_Linux-x86-64.zip 

[root@db1 soft]$chmod 777 28429134

[root@db1 soft]$chown  -R grid.oinstall 28429134

grid:生成ocm.rsp
[grid@db1 ~]$ cd /u01/11.2.0/grid/OPatch/ocm/bin
[grid@db1 bin]$ ./emocmrsp  -no_banner -output /tmp/ocm.rsp

root用户执行

[grid@db1 ~]$/u01/11.2.0/grid/OPatch/opatch  auto /soft/28429134/ -ocmrf  /tmp/ocm.rsp

滴滴错误来啦，提示patch 18370031 已存在patch 28429134，需要退回补丁 18370031

接下来好办了，回退补丁---各节点执行

 

3.root:回退18370031

[root@db1 soft]$cd /soft/18370031/
[root@db1 soft]$/u01/11.2.0/grid/OPatch/opatch rollback -local -id 18370031 -oh /u01/11.2.0/grid/

 

4.root:生成Switch.pm----liunx7版本的坑

这个是perl5.10以上版本的原因,如果是auto打psu,最简单的办法,就是把oracle的perl替换本身的perl,如下:

cp /u01/app/grid/product/11.2.0/grid/perl/lib/5.10.0/Switch.pm /usr/lib64/perl5/.

之后,再去安装psu ,就没有问题了.

cp /u01/11.2.0/grid/perl/lib/5.10.0/Switch.pm /usr/lib64/perl5/.

 

5.打补丁28429134---各节点执行

打GI补丁28429134

root:gi补丁28429134
/u01/11.2.0/grid/OPatch/opatch  auto /soft/28429134/ -ocmrf  /tmp/ocm.rsp

 

打DB补丁28429134

root:db补丁28429134
/u01/11.2.0/grid/OPatch/opatch auto /soft/28429134/ -oh  /u01/app/oracle/product/11.2.0/db_1 -ocmrf /tmp/ocm.rsp

 

以下为补丁输出

节点1：
GI：
[root@qzzbdb1 28429134]# /u01/11.2.0/grid/OPatch/opatch  auto /soft/28429134/ -ocmrf  /tmp/ocm.rsp
Executing /u01/11.2.0/grid/perl/bin/perl /u01/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -ocmrf /tmp/ocm.rsp -paramfile /u01/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/11.2.0/grid/cfgtoollogs/opatchauto2021-04-28_10-18-50.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/11.2.0/grid/cfgtoollogs/opatchauto2021-04-28_10-18-50.report.log

2021-04-28 10:18:50: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully

patch /soft/28429134/27735020  apply successful for home  /u01/11.2.0/grid 
patch /soft/28429134/28204707  apply successful for home  /u01/11.2.0/grid 
patch /soft/28429134/28204939  apply successful for home  /u01/11.2.0/grid 

Starting CRS...
Installing Trace File Analyzer
ACFS driver install actions failed
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.
[root@qzzbdb1 28429134]# su - grid
Last login: Wed Apr 28 10:23:43 CST 2021
[grid@qzzbdb1 ~]$ /u01/11.2.0/grid/OPatch/opatch lspatches
28204939;ACFS Patch Set Update : 11.2.0.4.181016 (28204939)
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
27735020;OCW Patch Set Update : 11.2.0.4.181016 (27735020)

OPatch succeeded.

DB:
[root@qzzbdb1 28429134]# /u01/11.2.0/grid/OPatch/opatch auto /soft/28429134/ -oh  /u01/app/oracle/product/11.2.0/db_1 -ocmrf /tmp/ocm.rsp
Executing /u01/11.2.0/grid/perl/bin/perl /u01/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 28429134 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /tmp/ocm.rsp -paramfile /u01/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/11.2.0/grid/cfgtoollogs/opatchauto2021-04-28_11-32-06.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/11.2.0/grid/cfgtoollogs/opatchauto2021-04-28_11-32-06.report.log

2021-04-28 11:32:06: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /soft/28429134/27735020/custom/server/27735020  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch /soft/28429134/28204707  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

补丁查看：
GI:
[grid@qzzbdb1 ~]$ /u01/11.2.0/grid/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.4.0
Log file location : /u01/11.2.0/grid/cfgtoollogs/opatch/opatch2021-04-28_11-45-22AM_1.log

Lsinventory Output file location : /u01/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2021-04-28_11-45-22AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: qzzbdb1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Grid Infrastructure 11g                                       11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch  28204939     : applied on Wed Apr 28 10:23:29 CST 2021
Unique Patch ID:  22366206
Patch description:  "ACFS Patch Set Update : 11.2.0.4.181016 (28204939)"
   Created on 31 Jul 2018, 08:37:40 hrs PST8PDT
   Bugs fixed:
     16318126, 21369858, 19690653, 17203009, 17503605, 17359415, 17611362
     20140148, 17164243, 17270418, 25098392, 19053182, 17696547, 17488768
     18168684, 18143006, 21519796, 21208140, 17428148, 17070158, 20438706
     17510275, 17172303, 18610307, 17376318, 17721778, 22198405, 17699423
     22810422, 18915417, 18155334, 19919907, 18321597, 18185024, 17636008
     17363999, 20681968, 17475946, 27463879

Patch  28204707     : applied on Wed Apr 28 10:22:56 CST 2021
Unique Patch ID:  22491169
Patch description:  "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
   Created on 19 Sep 2018, 03:24:06 hrs PST8PDT
Sub-patch  27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
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:
     17288409, 21051852, 24316947, 17811429, 17205719, 18607546, 25654936
     17484762, 17816865, 20506699, 24835538, 25957038, 19692824, 23330119
     17922254, 17754782, 13364795, 16934803, 17311728, 18604692, 26679352
     20387265, 17284817, 17441661, 20671094, 24560906, 25635149, 16992075
     17446237, 14015842, 19972569, 21756677, 17375354, 21538558, 20925795
     17449815, 17019086, 19463897, 26575788, 13866822, 17235750, 17982555
     17478514, 18317531, 14338435, 18235390, 19461270, 20803583, 13944971
     19475971, 20142975, 17811789, 16929165, 18704244, 24662775, 20506706
     17359610, 17546973, 21422580, 20334344, 14054676, 25489607, 17570606
     17088068, 17346091, 18264060, 17343514, 21538567, 19680952, 18471685
     19211724, 21132297, 25775213, 13951456, 16315398, 21847223, 18744139
     16850630, 23177648, 19049453, 18090142, 18673304, 17883081, 19915271
     18641419, 18262334, 25600421, 17006183, 16065166, 18277454, 18685892
     16833527, 10136473, 18051556, 17865671, 25879984, 18554871, 17852463
     18774543, 17853498, 18334586, 19487147, 20879889, 17551709, 17588480
     19827973, 17344412, 17842825, 18828868, 20509482, 17025461, 26039623
     19429927, 13609098, 11883252, 16410570, 17239687, 23007241, 17602269
     19197175, 22195457, 18316692, 17313525, 12611721, 21174504, 19544839
     20294666, 18964939, 17600719, 26667015, 18191164, 17571306, 19393542
     20777150, 18482502, 27086138, 19466309, 22243719, 17165204, 17040527
     18098207, 24790914, 16785708, 19891090, 17465741, 16180763, 17174582
     12982566, 16777840, 19463893, 22195465, 16875449, 22148226, 12816846
     17237521, 6599380, 19358317, 17811438, 25505394, 17811447, 21983325
     17945983, 18762750, 16912439, 17184721, 18061914, 20598042, 26631046
     21380789, 17282229, 18948177, 18331850, 21142837, 18202441, 17082359
     18723434, 21972320, 21532755, 19554106, 25505371, 20273319, 14034426
     18339044, 19458377, 17752995, 20448824, 17891943, 17767676, 17258090
     16668584, 18384391, 21063322, 17040764, 17381384, 15913355, 18356166
     14084247, 20596234, 21641760, 20506715, 13853126, 21756661, 18610915
     18203837, 14245531, 16043574, 21756699, 22195441, 17848897, 17877323
     26667032, 21453153, 19272701, 20569094, 17468141, 17786518, 20861693
     17912217, 17037130, 16956380, 18155762, 17478145, 17394950, 18641461
     18189036, 17551674, 18619917, 17019356, 17027426, 21352646, 16268425
     24476274, 22195492, 19584068, 26544823, 18436307, 22507210, 17265217
     13498382, 17634921, 19469538, 21526048, 19258504, 23003979, 16354467
     18043064, 19174430, 20004087, 17443671, 22195485, 18000422, 22321756
     20004021, 17571039, 25897615, 27053456, 16832076, 21067387, 22905130
     16344544, 21429602, 18009564, 14354737, 21286665, 18135678, 14521849
     18614015, 204