Oracle11.2.0.4升级补丁包

Oracle11.2.0.4升级补丁包

说明

系统版本：RedHat 7.6

Oracle版本：11.2.0.4 64位

OPatch补丁版本：p6880880_112000_Linux-x86-64.zip

Oracle补丁版本：p31718723_112040_Linux-x86-64.zip

查看补丁说明

Oracle补丁p31718723_112040_Linux-x86-64.zip解压后，打开README.html，查看补丁说明

 

升级Oracle补丁p31718723_112040_Linux-x86-64.zip，需要的OPatch版本至少是11.2.0.3.23及以上。

查看Oracle现有OPatch版本及当前Oracle数据库补丁情况

[root@localhost ~]# su - oracle

Last login: Thu Dec 23 23:12:41 CST 2021 on pts/2

-bash: export: `//ORACLE': not a valid identifier

[oracle@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory;

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/product/11.2.0/db_1

Central Inventory : /u01/oraInventory

   from           : /u01/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-12-23_23-13-25PM_1.log

Lsinventory Output file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-12-23_23-13-25PM.txt

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

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 ~]$ $ORACLE_HOME/OPatch/opatch lspatches;

There are no Interim patches installed in this Oracle Home.

以上结果说明Oracle软件中没有补丁，且OPatch版本是11.2.0.3.4，OPatch需要升级

升级OPatch

[oracle@localhost ~]$ echo $ORACLE_HOME

/u01/oracle/product/11.2.0/db_1

[oracle@localhost ~]$ cd $ORACLE_HOME

[oracle@localhost db_1]$ mv OPatch/ OPatch_bak

将/u01目录下的OPatch补丁包复制到/u01/oracle/product/11.2.0/db_1

[oracle@localhost db_1]$ cp /u01/p6880880_112000_Linux-x86-64.zip /u01/oracle/

product/11.2.0/db_1

解压

[oracle@localhost db_1]$ unzip p6880880_112000_Linux-x86-64.zip

查看OPatch版本

[oracle@localhost db_1]$  $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.27

OPatch succeeded.

以上显示OPatch升级成功

[oracle@localhost 31718723]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-DEC-2021 23:26:28

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

[oracle@localhost 31718723]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 23 23:26:45 2021

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

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

[oracle@localhost OPatch]$ cd /u01/

[oracle@localhost u01]$ ll

total 3897284

drwxr-xr-x.  7 oracle oinstall        136 Aug 27  2013 database

-rw-r--r--.  1 root   root      124096701 Dec 20 09:27 p6880880_112000_Linux-x86-64.zip

drwxrwxr-x. 10 oracle oinstall        147 Dec 23 23:27 oracle

-rw-r--r--.  1 oracle oinstall 1319414278 Dec 20 09:18 p31718723_112040_Linux-x86-64.zip

drwxrwx---.  5 oracle oinstall         89 Dec 23 23:32 oraInventory

[oracle@localhost u01]$ unzip p31718723_112040_Linux-x86-64.zip

[oracle@localhost u01]$ cd 31718723/

 

补丁包中含有三个补丁，只需要升级包含DB的就行了，也就是31537677

  

[oracle@localhost 31718723]$ cd 31537677/

[oracle@localhost 31537677]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@localhost 31537677]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.27

Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/product/11.2.0/db_1

Central Inventory : /u01/oraInventory

   from           : /u01/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.27

OUI version       : 11.2.0.4.0

Log file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-12-23_23-51-11PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@localhost 31537677]$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.27

Copyright (c) 2021, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/product/11.2.0/db_1

Central Inventory : /u01/oraInventory

   from           : /u01/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.27

OUI version       : 11.2.0.4.0

Log file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-12-23_23-51-16PM_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  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677  

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/oracle/product/11.2.0/db_1')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying sub-patch '17478514' to OH '/u01/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.sysman.agent, 10.2.0.4.5...

......中间省略......

Composite patch 31537677 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-12-23_23-51-16PM_1.log

OPatch completed with warnings.

查看升级是否成功

[oracle@localhost 31537677]$ $ORACLE_HOME/OPatch/opatch lspatches;

31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)

OPatch succeeded.

查看补丁信息

[oracle@localhost 31537677]$ $ORACLE_HOME/OPatch/opatch lsinventory;

Oracle Interim Patch Installer version 11.2.0.3.27

Copyright (c) 2021, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/product/11.2.0/db_1

Central Inventory : /u01/oraInventory

   from           : /u01/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.27

OUI version       : 11.2.0.4.0

Log file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-12-23_23-57-47PM_1.log

Lsinventory Output file location : /u01/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-12-23_23-57-47PM.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 (1) :

Patch  31537677     : applied on Thu Dec 23 23:53:42 CST 2021

Unique Patch ID:  23828543

Patch description:  "Database Patch Set Update : 11.2.0.4.201020 (31537677)"

   Created on 24 Sep 2020, 06:02:11 hrs PST8PDT

Sub-patch  31103343; "Database Patch Set Update : 11.2.0.4.200714 (31103343)"

Sub-patch  30670774; "Database Patch Set Update : 11.2.0.4.200414 (30670774)"

Sub-patch  30298532; "Database Patch Set Update : 11.2.0.4.200114 (30298532)"

Sub-patch  29913194; "Database Patch Set Update : 11.2.0.4.191015 (29913194)"

Sub-patch  29497421; "Database Patch Set Update : 11.2.0.4.190716 (29497421)"

Sub-patch  29141056; "Database Patch Set Update : 11.2.0.4.190416 (29141056)"

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:

     18619917, 19309466, 28876684, 28855981, 18189036, 19781326, 13609098

     16285691, 16756406, 18430495, 17323222, 13854364, 29483723, 19915271

     22468255, 19516448, 14458214, 23713236, 23140259, 29434301, 22502493

     19540573, 18272672, 16410570, 16494615, 19174430, 21352646, 16901385

     16596890, 22243719, 18996843, 21387964, 20334344, 17174582, 22250006

     17798953, 24307571, 14015842, 18031668, 15955387, 30758943, 21534893

     16832076, 16065166, 16579084, 25427662, 21179898, 24589081, 11786053

     15990359, 17982832, 18685892, 20142975, 24835538, 16315398, 20861693

     30018017, 17037130, 17284817, 17643573, 18832544, 17891946, 17279227

     17588480, 17291347, 16731148, 21097043, 24528741, 22321741, 17165204

     26245237, 17891943, 25205368, 17359610, 17265217, 17465741, 29621961

     22551446, 31492176, 18191164, 16721594, 18614015, 27825893, 18440095

     19769489, 20596234, 25115178, 18482502, 16043574, 20936905, 17360606

     22321756, 19211724, 17392698, 19463893, 31492164, 29033139, 17477958

     17040764, 18362222, 19463897, 24624166, 17853456, 14521849, 17816865

     19692824, 21868720, 17951233, 25505407, 17040527, 31022191, 24975421

     19888853, 18009564, 20882568, 20803583, 23026585, 18604692, 17622427

     16903536, 29483771, 17865671, 17883081, 16228604, 17325413, 17082359

     12747740, 30517516, 22168163, 16091637, 20569094, 31492144, 17468141

     30365745, 29962939, 19469538, 29633753, 20598042, 16042673, 23302839

     17437634, 24473736, 28734355, 19049453, 16941434, 20387265, 16833527

     21343775, 17297939, 16069901, 14285317, 22380919, 18436647, 23065323

     31885190, 21983325, 17853498, 24790914, 23571055, 16542886, 21286665

     17365043, 17752995, 25914276, 17296856, 18783224, 22353199, 22083366

     28305362, 21419850, 16180763, 23294548, 26679352, 13960236, 25328093

     25423453, 18339044, 17282229, 28384353, 25600421, 18856999, 31031715

     18259031, 28806384, 21354456, 23725036, 18471685, 31885162, 30237239

     17258090, 16344544, 17903598, 17011832, 18135678, 18704244, 17786518

     19718981, 25655390, 17242746, 20250147, 19197175, 17390431, 17835627

     17672719, 31125948, 17393915, 21566639, 18765602, 21425496, 26544823

     22228324, 29962927, 18682983, 30179644, 25165496, 12816846, 31885179

     18774543, 18747196, 31885173, 17824637, 21834568, 19429927, 21429602

     16524926, 17343514, 19271443, 17019345, 18681862, 17186905, 23330119

     17811438, 26474853, 17215560, 16875449, 21380789, 17184721, 18508861

     19466309, 23330124, 17811429, 17019356, 25654936, 17754782, 17752121

     22809871, 17201159, 18308268, 19777862, 16198143, 29027694, 18828868

     17586955, 28076295, 19445860, 26654363, 22977256, 16692232, 30200680

     27374796, 21142837, 20869721, 17649265, 24555417, 17847764, 25879656

     21756699, 19697993, 28364007, 17787259, 23628685, 30578221, 30252098

     23007241, 27351628, 18094246, 18460587, 20031873, 17375354, 21698350

     26513067, 21538567, 18232865, 22683212, 16450169, 17478145, 17311728

     17648596, 17308789, 22836801, 21756677, 18674047, 14084247, 19788303

     22683225, 27534509, 16833845, 18948177, 17205719, 21756661, 20004021

     17922254, 13837378, 18084625, 17912217, 11883252, 24842886, 12982566

     26203182, 14176370, 14764829, 21847223, 16875230, 28079127, 22568797

     17237521, 29511611, 25635149, 16934803, 17848897, 20441797, 20175161

     19831647, 16613964, 17532245, 18334586, 17288409, 17341326, 31338362

     17449815, 15913355, 16399083, 18740837, 20294666, 27404573, 14565184

     21517440, 17614134, 19854503, 14245531, 16194160, 18325460, 15979965

     30562923, 20671094, 29965888, 27870645, 25093656, 18247991, 16912439

     30562936, 17047404, 24433711, 19930276, 22092979, 20506715, 31884535

     23003979, 20506706, 13871092, 19272701, 17397545, 16785708, 19461270

     21051862, 13829543, 16220077, 17008068, 18061914, 20448824, 30275359

     18674024, 29343156, 19689979, 24411921, 30275351, 23184013, 17596908

     17036973, 22175564, 22499356, 17612828, 20725343, 31001455, 28199085

     23194294, 17630484, 21051858, 20017509, 21051852, 17767676, 17232014

     22893153, 12611721, 25555252, 18356166, 17071721, 19315668, 25764020

     16863422, 21051840, 17820741, 17267114, 18043064, 21538558, 26243698

     20324049, 21612959, 30305880, 16392068, 18744139, 24348685, 26746894

     17806696, 18628388, 27072923, 14010183, 16595641, 17080436, 17332800

     20777150, 21453153, 20299015, 18413820, 18264060, 16819962, 22465352

     21351877, 21051833, 18673342, 30393318, 30562907, 30562909, 29200700

     27441326, 16571443, 18328509, 27567477, 18674465, 16422541, 18306996

     19359219, 21424824, 17443671, 17478514, 21067387, 16268425, 17381384

     18723434, 17235750, 23328639, 22195448, 24570598, 21172913, 17655240

     18384391, 16992075, 22195441, 17025461, 30562891, 16472716, 19289642

     21502702, 22195457, 20475845, 22148226, 26030218, 18331850, 17945983

     13498382, 24652769, 31885230, 18673304, 17610798, 19891090, 25369547

     18456514, 8322815, 22657942, 17313525, 17050888, 18317531, 19835133

     17495022, 11733603, 18798250, 19285025, 18260550, 17390160, 18316692

     19458377, 14368995, 17551063, 21343838, 12905058, 14735792, 28612674

     16855292, 23315889, 13364795, 18235390, 18293054, 18673325, 30215130

     19393542, 14657740, 17532729, 17393683, 17389192, 17783588, 17852463

     19358317, 17441661, 14034426, 28254374, 20631274, 19207117, 26569225

     17518652, 24662775, 19475971, 31885201, 18282562, 30421204, 19896336

     17348614, 19827973, 31883489, 17346671, 31022281, 19791273, 24476274

     22296366, 13853126, 18273830, 17570606, 13558557, 26007010, 20425790

     16685417, 31885223, 18180390, 14692762, 18159793, 17027426, 24476265

     23177648, 17851160, 16870214, 18202441, 17227073, 20657411, 19006849

     22606521, 20506699, 28000269, 23536835, 17761775, 20382309, 16306373

     31885213, 17801017, 19680952, 16850630, 17694209, 26667015, 17877323

     18230522, 24563422, 17446237, 17889549, 17551674, 16233738, 22730454

     17571039, 26667023, 19972570, 18849970, 21532755, 20860659, 22905130

     21168487, 17016369, 21263635, 17231779, 17717883, 21343897, 27710072

     18522509, 23209741, 17484731, 21972320, 19972569, 19972568, 17716305

     21059919, 19972566, 19972564, 26667032, 17394950, 26318200, 20657441

     17551699, 17006570, 18051556, 12364061, 18029658, 17546973, 18262334

     19699191, 30387666, 17227277, 18018515, 16943711, 18388363, 17982555

     20828947, 18098207, 18436307, 19584068, 16898135, 13936038, 19601762

     31010960, 14054676, 25505394, 18228645, 19013183, 29782211, 25042823

     17721717, 17239687, 25248384, 25634317, 20134113, 20273319, 28501075

     30624864, 21063322, 31834759, 17344412, 22507210, 16354467, 21795111

     25505371, 16777840, 25879984, 17811456, 19730508, 17385178, 18166013

     17484762, 10136473, 6599380, 20717359, 20296213, 27097854, 13955826

     18193833, 17545847, 16837842, 18964939, 19871910, 25505382, 14786201

     17811447, 18554763, 21132297, 25957038, 20004087, 17889583, 19544839

     26631046, 22507234, 24719736, 18868646, 17042658, 20627866, 14106803

     13951456, 18139690, 18277454, 13680635, 22750215, 25823754, 18554871

     18515268, 20169408, 24908321, 17274537, 17602269, 26575788, 19032867

     17762296, 14829250, 16929165, 14602788, 28849751, 21794615, 18899974

     29944660, 18441944, 14521218, 17811789, 20074391, 14852021, 17705023

     13645875, 24316947, 16668584, 17786278, 25947799, 20879889, 19578350

     28022101, 22594718, 16384983, 26439748, 17957017, 19121551, 17570240

     19788842, 18382302, 27086138, 21330264, 21197626, 14338435, 13944971

     21656630, 22826067, 18886413, 17156148, 17936109, 20509482, 27255377

     24717859, 18762750, 21526048, 24560906, 18096714, 17238511, 26078387

     27053456, 20144308, 25364628, 18244962, 19433930, 20476175, 19297917

     19330795, 21174504, 18280813, 31506720, 28819280, 17614227, 28357401

     21911701, 25809524, 17006183, 18092127, 19727057, 17695685, 26039623

     22820579, 20856766, 15861775, 17258582, 21668627, 19487147, 20925795

     28100487, 22760679, 26482376, 19554106, 21629064, 18199537, 18091059

     17299889, 26999139, 21538485, 17546761, 26336977, 25775213, 18155762

     30803210, 16956380, 31194264, 19207156, 14705949, 23105538, 26198926

     19258504, 16314254, 17890099, 17246576, 17655634, 16989630, 20067212

     19721304, 25077278, 19490948, 18203835, 18203838, 18973907, 18203837

     29483672, 19615136, 17587063, 18000422, 18641451, 18090142, 21641760

     17019086, 30559616, 19373893, 18373438, 21820934, 18641461, 17346091

     21422580, 22351572, 18604493, 23008056, 22901797, 18610915, 22666802

     17892268, 31668061, 17501491, 20907061, 14354737, 17835048, 21787056

     22195485, 22782647, 17082983, 23266217, 18641419, 16618694, 14133975

     22195492, 18331812, 18093615, 24385983, 25897615, 20513399, 21281607

     13866822, 18841764, 17600719, 17842825, 20558005, 17088068, 9756271

     22195465, 18440047, 19211433, 21515534, 20331945, 22686674, 18384537

     18607546, 17254374, 18315328, 31172207, 23115139, 28790634, 21394225

     16360112, 22195477, 17726838, 18510194, 17571306, 24766121, 17302277

     21842740, 17551709, 26910644, 17634921, 28566241, 25489607, 16538760

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

OPatch succeeded.

启动数据库

[oracle@localhost 31537677]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 23 23:58:21 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size     2253784 bytes

Variable Size  1006636072 bytes

Database Buffers   637534208 bytes

Redo Buffers     7094272 bytes

Database mounted.

Database opened.

查询数据库补丁安装时间

SQL> set linesize 1000

SQL> select * from dba_registry_history;

ACTION_TIME                      ACTION      NAMESPACE  VERSION  ID BUNDLE_SERIES    COMMENTS

24-AUG-13 12.03.45.119862 PM   APPLY       SERVER       11.2.0.4            0 PSU                 Patchset 11.2.0.2.0

23-DEC-21 11.07.36.993333 PM   APPLY       SERVER       11.2.0.4            0 PSU               Patchset 11.2.0.2.0