Oracle 11.2.0.4打补丁

所需补丁及高版本opatch

上传后将p6880880_112000_linux-x86-64.zip解压覆盖$oracle_home/opatch目录即可

[oracle@localhost opatch]$ ./opatch version
opatch version: 11.2.0.3.16

opatch succeeded.

检查环境是否需要打补丁，opatch版本安装环境可以看mos和readme 查看组件信息

12:40:47 sys@std> set linesize 500 pagesize 600
12:40:49 sys@std> col comp_name for a30
12:41:06 sys@std> select comp_id,comp_name,version,status from dba_registry;

comp_id                        comp_name                      version                        status
------------------------------ ------------------------------ ------------------------------ --------------------------------------------
owb                            owb                            11.2.0.4.0                     valid
apex                           oracle application express     3.2.1.00.12                    valid
em                             oracle enterprise manager      11.2.0.4.0                     valid
amd                            olap catalog                   11.2.0.4.0                     valid
sdo                            spatial                        11.2.0.4.0                     valid
ordim                          oracle multimedia              11.2.0.4.0                     valid
xdb                            oracle xml database            11.2.0.4.0                     valid
context                        oracle text                    11.2.0.4.0                     valid
exf                            oracle expression filter       11.2.0.4.0                     valid
rul                            oracle rules manager           11.2.0.4.0                     valid
owm                            oracle workspace manager       11.2.0.4.0                     valid
catalog                        oracle database catalog views  11.2.0.4.0                     valid
catproc                        oracle database packages and t 11.2.0.4.0                     valid
                               ypes

javavm                         jserver java virtual machine   11.2.0.4.0                     valid
xml                            oracle xdk                     11.2.0.4.0                     valid
catjava                        oracle database java packages  11.2.0.4.0                     valid
aps                            olap analytic workspace        11.2.0.4.0                     valid
xoq                            oracle olap api                11.2.0.4.0                     valid

18 rows selected.

elapsed: 00:00:00.04

查看补丁情况

12:41:11 sys@std> col action_time for a30
12:46:03 sys@std> col comments for a30
12:46:07 sys@std> select action_time, action,version, comments from sys.dba_registry_history;

action_time                    action                         version                        comments
------------------------------ ------------------------------ ------------------------------ ------------------------------
24-aug-13 12.03.45.119862 pm   apply                          11.2.0.4                       patchset 11.2.0.2.0
22-mar-19 12.02.16.970055 pm   apply                          11.2.0.4                       patchset 11.2.0.2.0

elapsed: 00:00:00.01

查看无效对象

12:46:11 sys@std> select count(*) from dba_objects where status<>'valid';

  count(*)
----------
         0

测试兼容性，如果之前没打过，这步可以忽略

[oracle@localhost opatch]$ ./opatch prereq checkconflictagainstohwithdetail -phbasedir /home/oracle/28689165/ -oh $oracle_home         
oracle interim patch installer version 11.2.0.3.16
copyright (c) 2019, oracle corporation.  all rights reserved.

prereq session

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.16
oui version       : 11.2.0.4.0
log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45pm_1.log

invoking prereq "checkconflictagainstohwithdetail"

prereq "checkconflictagainstohwithdetail" passed.

opatch succeeded.

为数据库做冷备份,因为是学习用的库不是生产库，这步骤省了 停库 停止数据库外部进程

ps -ef|grep -v grep |grep local=no|awk '{print $2}'|xargs kill -9

停库

13:11:12 sys@std> shutdown immediate;
database closed.
database dismounted.
oracle instance shut down.
13:11:28 sys@std>

停止监听

[oracle@localhost opatch]$ lsnrctl stop

lsnrctl for linux: version 11.2.0.4.0 - production on 22-mar-2019 13:12:51

copyright (c) 1991, 2013, oracle.  all rights reserved.

connecting to (address=(protocol=tcp)(host=)(port=1521))
the command completed successfully
[oracle@localhost opatch]$

查看是否停干净

[oracle@localhost opatch]$ ps -ef |grep ora_|grep -v grep
[oracle@localhost opatch]$ netstat -an |grep 1158
[oracle@localhost opatch]$ netstat -an|grep 1521
[oracle@localhost opatch]$

正式打补丁

[oracle@localhost opatch]$ ./opatch lsinventory
oracle interim patch installer version 11.2.0.3.16
copyright (c) 2019, 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.16
oui version       : 11.2.0.4.0
log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35am_1.log

lsinventory output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35am.txt

--------------------------------------------------------------------------------
local machine information::
hostname: localhost
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.
[oracle@localhost opatch]$

./opatch napply -oh $oracle_home -local /home/oracle/28689165

many more lines compressed..

+ make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _full_libname=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfhc.so _libname=libnmcfhc _libdir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_libname_libs=$(libnmcfhclibs)' '_libname_extralibs=$(libnmcfhcextralibs)'
+ path=/bin:/usr/bin:/usr/ccs/bin
+ export path
+ lib=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so
+ makefile=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk
+ so_ext=so
+ target=new_ld_shlib
+ var=
++ basename /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so .so
+ libname=libnmcfsga
++ dirname /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so
+ dir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib
+ '[' var = new_ld_shlib ']'
+ '[' -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.a ']'
+ dir2=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/
+ '[' '' '!=' '' ']'
+ make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _full_libname=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so _libname=libnmcfsga _libdir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_libname_libs=$(libnmcfsgalibs)' '_libname_extralibs=$(libnmcfsgaextralibs)'
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.


composite patch 28204707 successfully applied.
patch 28440700 successfully applied.
opatch session completed with warnings.
log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-50-02am_1.log

opatch completed with warnings.

[oracle@localhost opatch]$ ./opatch lsinventory
oracle interim patch installer version 11.2.0.3.16
copyright (c) 2019, 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.16
oui version       : 11.2.0.4.0
log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_09-02-42am_1.log

lsinventory output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_09-02-42am.txt

--------------------------------------------------------------------------------
local machine information::
hostname: localhost
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 (2) :

patch  28440700     : applied on mon mar 25 08:54:00 cst 2019
unique patch id:  22461927
patch description:  "ojvm patch set update 11.2.0.4.181016"
   created on 15 oct 2018, 08:12:17 hrs pst8pdt
   bugs fixed:
     18933818, 19176885, 17201047, 25649873, 25067795, 28502128, 27952577
     14774730, 27461842, 19153980, 21911849, 23727132, 18166577, 27000663
     24448240, 17056813, 21811517, 19909862, 25494379, 22675136, 24534298
     19895326, 22253904, 17804361, 19231857, 27642235, 26023002, 17528315
     19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
     23265914, 19699946, 19006757, 19374518, 19223010, 25076732, 22118835
     26637592, 19852360, 20408829, 21047766, 21566944

patch  28204707     : applied on mon mar 25 08:53:49 cst 2019
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:
     21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
     20671094, 16731148, 16314254, 13837378, 18441944, 17291347, 17835048
     28254374, 21656630, 21842740, 13558557, 17008068, 17201159, 25427662
     17853498, 20717359, 17246576, 18356166, 18681862, 18440047, 20569094
     20031873, 16875449, 20387265, 19788842, 17296856, 21330264, 14010183
     17648596, 17551063, 17025461, 24719736, 21063322, 17267114, 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, 17437634, 21343897, 20506706
     21453153, 18339044, 17951233, 22321741, 21795111, 18430495, 21787056
     22380919, 19692824, 19469538, 20506715, 17811429, 19721304, 17903598
     18230522, 19554106, 19458377, 21281607, 17612828, 6599380, 22092979
     17040527, 22321756, 17811438, 18641461, 18682983, 25635149, 14657740
     13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390
     26474853, 18849970, 17889549, 19309466, 16472716, 25775213, 20596234
     18331850, 18641451, 17019356, 17344412, 19461270, 21179898, 17546761
     24842886, 17231779, 14521849, 18203835, 18203838, 18964939, 18203837
     17313525, 22195457, 18139690, 16837842, 22296366, 14106803, 17842825
     21352646, 22657942, 22594718, 16360112, 20657441, 22195441, 17389192
     26198926, 14565184, 17019345, 17205719, 18740837, 18440095, 14764829
     22195448, 14354737, 17019086, 13944971, 16571443, 21868720, 17186905
     17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568
     20144308, 19972566, 17282229, 19972564, 16870214, 16410570, 21629064
     19615136, 26039623, 21354456, 17390431, 18762750, 23007241, 16613964
     17957017, 18098207, 17484762, 18471685, 19730508, 21538485, 18264060
     17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 18166013
     17655634, 16228604, 27053456, 20074391, 24790914, 19972570, 20856766
     19891090, 18090142, 18996843, 19854503, 16042673, 22901797, 17835627
     20334344, 17393683, 20861693, 18000422, 17551709, 26575788, 23315889
     20506699, 19006849, 18277454, 18456514, 19174430, 17258090, 17174582
     25654936, 17242746, 16399083, 17824637, 21132297, 22465352, 17762296
     22168163, 18604692, 17397545, 16450169, 12364061, 20067212, 18856999
     19211724, 19463893, 19463897, 21343775, 17853456, 18673304, 20004021
     26030218, 21668627, 16194160, 17477958, 23140259, 16538760, 12982566
     24570598, 20828947, 18259031, 20296213, 18293054, 17610798, 19699191
     23065323, 17311728, 18135678, 18774543, 23294548, 16785708, 10136473
     24560906, 22551446, 19777862, 17786518, 25879984, 18315328, 18334586
     12747740, 18096714, 19032867, 21641760, 17390160, 18899974, 17232014
     16354467, 26245237, 26679352, 20598042, 17484731, 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, 22683212, 23725036, 17006183, 13829543
     18191164, 17655240, 22809871, 26746894, 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, 25914276, 18607546, 17571306, 21286665, 17341326
     26910644, 17851160, 20558005, 17586955, 19049453, 21051840, 17587063
     16956380, 18328509, 25423453, 14133975, 19718981, 18061914, 17518652
     18522509, 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
     17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 21422580
     19466309, 11733603, 25505371, 18610915, 21051858, 18084625, 26243698
     18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259
     18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762
     18614015, 17346091, 18228645, 17721717, 13960236, 18685892, 18436307
     21756677, 19888853, 11883252, 17891943, 19475971, 22353199, 16384983
     19121551, 25634317, 27825893, 12816846, 17982555, 17761775, 22243719
     17265217, 25505394, 17071721, 16721594, 18262334, 21756661, 17891946
     15913355, 17672719, 17602269, 25555252, 17239687, 17042658, 17238511
     17811456, 17284817, 17752121, 20879889, 21380789, 17394950, 17011832
     16579084, 22195465, 14602788, 18325460, 24476265, 26569225, 24476274
     12611721, 18674465, 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, 24975421, 14084247, 26078387, 23115139, 13645875
     16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 19285025
     18482502, 17622427, 19289642, 27534509, 22195492, 25947799, 14458214
     20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504
     17082983, 21351877, 17365043, 13498382, 18331812, 16065166, 25489607
     16685417, 18031668, 22893153, 17551674, 16943711, 19272701, 21517440
     25897615, 17649265, 13866822, 18094246, 24528741, 17783588, 14245531
     17082359, 18280813, 20448824, 23330119, 16268425, 19487147, 25600421
     18018515, 17302277, 17215560, 24411921, 19271443, 14176370, 25764020
     17016369, 20777150, 23330124, 16756406, 20441797, 19769489, 28100487
     17545847, 25093656, 18260550, 13853126, 17551699, 17227277, 23536835
     25957038, 24652769, 20725343, 19207117, 9756271, 18868646, 17614134
     26667023, 17546973, 18704244, 19680952, 26667015, 17050888, 18828868
     18273830, 17360606, 16992075, 24563422, 17375354, 12905058, 18362222
     21429602, 28364007, 26667032, 27086138, 17571039, 17468141, 18436647
     17570606, 17235750, 21168487, 17279227, 16220077, 16929165



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

opatch succeeded.

更新数据库，将修改过的sql文件应用到数据库中，很多dba在执行完上述安装命令以后就不再进行这一步，那么实际上psu是没有完整安装的

[oracle@localhost 28689165]$ cd $oracle_home/rdbms/admin
[oracle@localhost admin]$ sql

sql*plus: release 11.2.0.4.0 production on mon mar 25 11:10:53 2019

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

11:10:53 sys@std> @catbundle.sql psu apply

pl/sql procedure successfully completed.

elapsed: 00:00:00.00

function created.

elapsed: 00:00:00.14

function created.

many more lines compressed