oracle 11.2.0.4安装psu 29141056,日志末尾抛出报错
Patching component oracle.ctx, 11.2.0.4.0...
Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 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/dbhome_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 29141056 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-16_11-33-18AM_1.log
OPatch completed with warnings.
参考mos文档:
安装Proactive Bundle / PSU Patch报错 “chmod: changing permissions of `$ORACLE_HOME/bin/extjobO’: Operation not permitted” (Doc ID 2668094.1)
这个问题/警告"chmod: changing permissions of ‘$ORACLE_HOME/bin/extjobO’’: Operation not permitted" 可以被安全的忽略。
查看补丁、数据库版本等情况
[oracle@oracle ~]$ ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether fa:16:3e:0c:cb:77 brd ff:ff:ff:ff:ff:ff
inet 192.168.0.11/24 brd 172.16.0.255 scope global eth1
inet6 fe80::f816:3eff:fe0c:cb77/64 scope link
valid_lft forever preferred_lft forever
[oracle@oracle ~]$
[oracle@oracle ~]$ hostname
oracle
[oracle@oracle ~]$
[oracle@oracle ~]$ date
Tue Mar 16 11:39:40 CST 2021
[oracle@oracle ~]$
[oracle@oracle ~]$ opatch version
OPatch Version: 11.2.0.3.21
OPatch succeeded.
[oracle@oracle ~]$
[oracle@oracle ~]$ opatch lspatches
29141056;Database Patch Set Update : 11.2.0.4.190416 (29141056)
OPatch succeeded.
[oracle@oracle ~]$
[oracle@oracle ~]$ sqlplus -v
SQL*Plus: Release 11.2.0.4.0 Production
[oracle@oracle ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.21
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.21
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-16_11-42-37AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2021-03-16_11-42-37AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oracle.novalocal
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 29141056 : applied on Tue Mar 16 11:35:04 CST 2021
Unique Patch ID: 22768427
Patch description: "Database Patch Set Update : 11.2.0.4.190416 (29141056)"
Created on 17 Feb 2019, 23:52:26 hrs PST8PDT
Sub-patch 28729262; "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
Sub-patch 28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
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:
17184721, 21174504, 21538558, 16091637, 18092127, 17381384, 15979965
20671094, 16731148, 16314254, 13837378, 18441944, 17291347, 23105538
17835048, 28254374, 13558557, 21656630, 21842740, 17008068, 18382302
17201159, 25427662, 17853498, 21197626, 20717359, 17246576, 18356166
18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842
17296856, 21330264, 14010183, 17648596, 18886413, 17025461, 17551063
24719736, 17267114, 21063322, 22507210, 17912217, 17889583, 18202441
17040764, 17478145, 16524926, 25655390, 19358317, 22730454, 22148226
18747196, 26544823, 18641419, 17036973, 18948177, 17811789, 16542886
14285317, 18009564, 17359610, 16618694, 8322815, 16832076, 18247991
16692232, 22507234, 17570240, 13871092, 24624166, 26631046, 19429927
24348685, 17848897, 17441661, 14034426, 17465741, 20273319, 19207156
16596890, 18510194, 17437634, 21343897, 20506706, 28849751, 18339044
21453153, 17951233, 21795111, 22321741, 18430495, 21787056, 22380919
19469538, 19692824, 20506715, 17811429, 17903598, 19721304, 11786053
18230522, 19554106, 19458377, 21281607, 17612828, 6599380, 22092979
17040527, 22321756, 17811438, 18641461, 18682983, 14657740, 25635149
13364795, 19490948, 21387964, 17346671, 17588480, 22351572, 18235390
18849970, 26474853, 17889549, 19309466, 20627866, 23008056, 16472716
24908321, 20134113, 25775213, 20596234, 18331850, 18641451, 20882568
17019356, 17344412, 19461270, 21179898, 17546761, 24842886, 17231779
14521849, 18203835, 18203838, 18964939, 18203837, 17313525, 22195457
18139690, 16837842, 14106803, 22296366, 17842825, 22657942, 21352646
16360112, 22594718, 20657441, 22195441, 17389192, 26198926, 14565184
19781326, 17019345, 17205719, 18740837, 18440095, 14764829, 14354737
22195448, 17019086, 13944971, 16571443, 21868720, 17186905, 17080436
18673342, 22905130, 17027426, 27374796, 19972569, 19972568, 20144308
19972566, 17282229, 19972564, 16870214, 16410570, 21629064, 19615136
21354456, 26039623, 17390431, 18762750, 23007241, 16613964, 17957017
18098207, 17484762, 18471685, 19730508, 18264060, 21538485, 17323222
17754782, 17600719, 18317531, 17852463, 17596908, 17655634, 18166013
16228604, 20074391, 27053456, 24790914, 19972570, 20856766, 18090142
19891090, 18996843, 16042673, 19854503, 17835627, 22901797, 20334344
17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699
19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936
17242746, 27097854, 16399083, 17824637, 21132297, 22465352, 17762296
22168163, 18604692, 17397545, 16450169, 12364061, 20067212, 18856999
19211724, 19463893, 27351628, 19463897, 21343775, 17853456, 18373438
18673304, 20004021, 28000269, 26030218, 21668627, 16194160, 17477958
23140259, 16538760, 12982566, 24570598, 20828947, 27255377, 18259031
20296213, 21425496, 28855981, 18293054, 17610798, 19699191, 23065323
17311728, 18135678, 18774543, 23294548, 16785708, 10136473, 24560906
19777862, 22551446, 17786518, 25879984, 18315328, 18334586, 12747740
18096714, 19032867, 21641760, 17390160, 18899974, 17232014, 20598042
26679352, 26245237, 16354467, 17484731, 18673325, 16422541, 18155762
19827973, 14015842, 22683225, 17726838, 18554871, 23177648, 18051556
20803583, 18282562, 21972320, 15990359, 17922254, 16855292, 16668584
21343838, 20299015, 17446237, 18043064, 18093615, 23713236, 17694209
17288409, 20475845, 18308268, 17274537, 13955826, 16934803, 17634921
17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164
26746894, 22809871, 17655240, 28819280, 18384391, 19393542, 21538567
16198143, 21847223, 25823754, 17892268, 20142975, 19584068, 17165204
25165496, 18604493, 21756699, 18508861, 18554763, 16901385, 21532755
18189036, 17443671, 17385178, 14829250, 17936109, 20925795, 20509482
17478514, 27441326, 16850630, 13951456, 16595641, 14054676, 15861775
21142837, 16912439, 17299889, 17297939, 23003979, 16833527, 18619917
17798953, 19697993, 17816865, 25914276, 18607546, 17571306, 21286665
16898135, 16819962, 17341326, 26910644, 17851160, 17586955, 20558005
19049453, 21051840, 17587063, 16956380, 18328509, 25423453, 14133975
29033139, 19718981, 18061914, 18522509, 17518652, 21051833, 20294666
18765602, 20860659, 18272672, 20324049, 18199537, 17332800, 13609098
22502493, 18384537, 14338435, 17945983, 16392068, 21067387, 17752995
21051862, 16863422, 17237521, 25505382, 18244962, 19544839, 24433711
24717859, 17156148, 18973907, 23026585, 17449815, 17877323, 18180390
17088068, 17037130, 20004087, 21422580, 19466309, 11733603, 25505371
18610915, 21051858, 18084625, 29027694, 18674024, 26243698, 21051852
18091059, 18306996, 25369547, 16306373, 17787259, 18193833, 19915271
20513399, 20631274, 26439748, 16344544, 25879656, 14692762, 18614015
22782647, 17346091, 18228645, 17721717, 13960236, 18685892, 18436307
11883252, 19888853, 21756677, 17891943, 19475971, 22353199, 16384983
19121551, 25634317, 27825893, 12816846, 17982555, 17761775, 17227073
22243719, 17265217, 25505394, 17071721, 16721594, 18262334, 21756661
17891946, 15913355, 17672719, 17602269, 17239687, 17042658, 25555252
17238511, 21059919, 17811456, 17284817, 17752121, 20879889, 28806384
21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 28790634
18325460, 27567477, 26569225, 24476265, 24476274, 12611721, 18674465
16903536, 17006570, 19689979, 28076295, 16043574, 18783224, 24662775
16494615, 21526048, 17392698, 19197175, 16069901, 17811447, 27870645
28876684, 17308789, 24835538, 22195477, 17865671, 17343514, 19013183
17325413, 18316692, 16180763, 17348614, 14368995, 21983325, 17393915
16285691, 19211433, 20331945, 17883081, 17705023, 24316947, 17614227
19578350, 22195485, 14084247, 24975421, 26078387, 23115139, 13645875
16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 19285025
18482502, 17622427, 19289642, 27534509, 25947799, 22195492, 14458214
20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504
17082983, 17365043, 21351877, 13498382, 18331812, 16065166, 25489607
16685417, 18031668, 22893153, 17551674, 16943711, 19272701, 21517440
25897615, 17649265, 13866822, 18094246, 24528741, 17783588, 14245531
17082359, 26007010, 18280813, 20448824, 23330119, 16268425, 19487147
25600421, 18018515, 17302277, 17215560, 24411921, 19271443, 25764020
14176370, 17016369, 20777150, 16756406, 23330124, 22977256, 20441797
19769489, 28100487, 17545847, 25093656, 18260550, 13853126, 17227277
17551699, 23536835, 25957038, 24652769, 20725343, 19207117, 9756271
18868646, 17614134, 26667023, 17546973, 19680952, 18704244, 26667015
17050888, 18273830, 18828868, 17360606, 16992075, 24563422, 17375354
12905058, 18362222, 21429602, 17254374, 26667032, 28364007, 27086138
17571039, 17468141, 18436647, 17570606, 17235750, 21168487, 17279227
16220077, 16929165
--------------------------------------------------------------------------------
OPatch succeeded.
因此,补丁安装成功,最后那个报错可忽略