这篇文章主要介绍Oracle 11.2.0.4如何添加补丁，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

所需补丁及高版本opatch

image上传后将p6880880_112000_Linux-x86-64.zip解压覆盖$ORACLE_HOME/OPatch目录即可

[oracle@localhostOPatch]$./opatchversionOPatchVersion:11.2.0.3.16OPatchsucceeded.

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

12:40:47SYS@std>setlinesize500pagesize60012:40:49SYS@std>colCOMP_NAMEfora3012:41:06SYS@std>selectCOMP_ID,COMP_NAME,VERSION,STATUSfromDBA_REGISTRY;COMP_IDCOMP_NAMEVERSIONSTATUS--------------------------------------------------------------------------------------------------------------------------------------OWBOWB11.2.0.4.0VALIDAPEXOracleApplicationExpress3.2.1.00.12VALIDEMOracleEnterpriseManager11.2.0.4.0VALIDAMDOLAPCatalog11.2.0.4.0VALIDSDOSpatial11.2.0.4.0VALIDORDIMOracleMultimedia11.2.0.4.0VALIDXDBOracleXMLDatabase11.2.0.4.0VALIDCONTEXTOracleText11.2.0.4.0VALIDEXFOracleExpressionFilter11.2.0.4.0VALIDRULOracleRulesManager11.2.0.4.0VALIDOWMOracleWorkspaceManager11.2.0.4.0VALIDCATALOGOracleDatabaseCatalogViews11.2.0.4.0VALIDCATPROCOracleDatabasePackagesandT11.2.0.4.0VALIDypesJAVAVMJServerJAVAVirtualMachine11.2.0.4.0VALIDXMLOracleXDK11.2.0.4.0VALIDCATJAVAOracleDatabaseJavaPackages11.2.0.4.0VALIDAPSOLAPAnalyticWorkspace11.2.0.4.0VALIDXOQOracleOLAPAPI11.2.0.4.0VALID18rowsselected.Elapsed:00:00:00.04

查看补丁情况

12:41:11SYS@std>colACTION_TIMEfora3012:46:03SYS@std>colCOMMENTSfora3012:46:07SYS@std>selectACTION_TIME,ACTION,version,COMMENTSfromsys.DBA_REGISTRY_HISTORY;ACTION_TIMEACTIONVERSIONCOMMENTS------------------------------------------------------------------------------------------------------------------------24-AUG-1312.03.45.119862PMAPPLY11.2.0.4Patchset11.2.0.2.022-MAR-1912.02.16.970055PMAPPLY11.2.0.4Patchset11.2.0.2.0Elapsed:00:00:00.01

查看无效对象

12:46:11SYS@std>selectcount(*)fromdba_objectswherestatus<>'VALID';COUNT(*)----------0

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

[oracle@localhostOPatch]$./opatchprereqCheckConflictAgainstOHWithDetail-phBaseDir/home/oracle/28689165/-oh$ORACLE_HOMEOracleInterimPatchInstallerversion11.2.0.3.16Copyright(c)2019,OracleCorporation.Allrightsreserved.PREREQsessionOracleHome:/u01/app/oracle/product/11.2.0/dbhome_1CentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatchversion:11.2.0.3.16OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3019-03-22_13-02-45PM_1.logInvokingprereq"checkconflictagainstohwithdetail"Prereq"checkConflictAgainstOHWithDetail"passed.OPatchsucceeded.

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

ps-ef|grep-vgrep|grepLOCAL=NO|awk'{print$2}'|xargskill-9

停库

13:11:12SYS@std>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.13:11:28SYS@std>

停止监听

[oracle@localhostOPatch]$lsnrctlstopLSNRCTLforLinux:Version11.2.0.4.0-Productionon22-MAR-201913:12:51Copyright(c)1991,2013,Oracle.Allrightsreserved.Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Thecommandcompletedsuccessfully[oracle@localhostOPatch]$

查看是否停干净

[oracle@localhostOPatch]$ps-ef|grepora_|grep-vgrep[oracle@localhostOPatch]$netstat-an|grep1158[oracle@localhostOPatch]$netstat-an|grep1521[oracle@localhostOPatch]$

正式打补丁

[oracle@localhostOPatch]$./opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.16Copyright(c)2019,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/11.2.0/dbhome_1CentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatchversion:11.2.0.3.16OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3019-03-25_08-44-35AM_1.logLsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:localhostARUplatformid:226ARUplatformdescription::Linuxx86-64InstalledTop-levelProducts(1):OracleDatabase11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.TherearenoInterimpatchesinstalledinthisOracleHome.--------------------------------------------------------------------------------OPatchsucceeded.[oracle@localhostOPatch]$./opatchnapply-oh$ORACLE_HOME-local/home/oracle/28689165manymorelinescompressed..+make-f/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mknew_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+exportPATH+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.mknew_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:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored./bin/ld:warning:-zlazyloadignored./bin/ld:warning:-znolazyloadignored.Compositepatch28204707successfullyapplied.Patch28440700successfullyapplied.OPatchSessioncompletedwithwarnings.Logfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3019-03-25_08-50-02AM_1.logOPatchcompletedwithwarnings.[oracle@localhostOPatch]$./opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.16Copyright(c)2019,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/11.2.0/dbhome_1CentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatchversion:11.2.0.3.16OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3019-03-25_09-02-42AM_1.logLsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_09-02-42AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:localhostARUplatformid:226ARUplatformdescription::Linuxx86-64InstalledTop-levelProducts(1):OracleDatabase11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.Interimpatches(2):Patch28440700:appliedonMonMar2508:54:00CST2019UniquePatchID:22461927Patchdescription:"OJVMPATCHSETUPDATE11.2.0.4.181016"Createdon15Oct2018,08:12:17hrsPST8PDTBugsfixed:18933818,19176885,17201047,25649873,25067795,28502128,2795257714774730,27461842,19153980,21911849,23727132,18166577,2700066324448240,17056813,21811517,19909862,25494379,22675136,2453429819895326,22253904,17804361,19231857,27642235,26023002,1752831519058059,19554117,19007266,17285560,22670385,18458318,1918798823265914,19699946,19006757,19374518,19223010,25076732,2211883526637592,19852360,20408829,21047766,21566944Patch28204707:appliedonMonMar2508:53:49CST2019UniquePatchID:22491169Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.181016(28204707)"Createdon19Sep2018,03:24:06hrsPST8PDTSub-patch27734982;"DatabasePatchSetUpdate:11.2.0.4.180717(27734982)"Sub-patch27338049;"DatabasePatchSetUpdate:11.2.0.4.180417(27338049)"Sub-patch26925576;"DatabasePatchSetUpdate:11.2.0.4.180116(26925576)"Sub-patch26392168;"DatabasePatchSetUpdate:11.2.0.4.171017(26392168)"Sub-patch26609445;"DatabasePatchSetUpdate:11.2.0.4.170814(26609445)"Sub-patch25869727;"DatabasePatchSetUpdate:11.2.0.4.170718(25869727)"Sub-patch24732075;"DatabasePatchSetUpdate:11.2.0.4.170418(24732075)"Sub-patch24006111;"DatabasePatchSetUpdate:11.2.0.4.161018(24006111)"Sub-patch23054359;"DatabasePatchSetUpdate:11.2.0.4.160719(23054359)"Sub-patch22502456;"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"Sub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"Bugsfixed:21174504,17184721,21538558,16091637,18092127,17381384,1597996520671094,16731148,16314254,13837378,18441944,17291347,1783504828254374,21656630,21842740,13558557,17008068,17201159,2542766217853498,20717359,17246576,18356166,18681862,18440047,2056909420031873,16875449,20387265,19788842,17296856,21330264,1401018317648596,17551063,17025461,24719736,21063322,17267114,2250721017912217,17889583,18202441,17040764,17478145,16524926,2565539019358317,22730454,22148226,18747196,26544823,18641419,1703697318948177,17811789,16542886,14285317,18009564,17359610,166186948322815,16832076,18247991,16692232,22507234,17570240,1387109224624166,26631046,19429927,24348685,17848897,17441661,1403442617465741,20273319,19207156,16596890,17437634,21343897,2050670621453153,18339044,17951233,22321741,21795111,18430495,2178705622380919,19692824,19469538,20506715,17811429,19721304,1790359818230522,19554106,19458377,21281607,17612828,6599380,2209297917040527,22321756,17811438,18641461,18682983,25635149,1465774013364795,21387964,19490948,17346671,17588480,22351572,1823539026474853,18849970,17889549,19309466,16472716,25775213,2059623418331850,18641451,17019356,17344412,19461270,21179898,1754676124842886,17231779,14521849,18203835,18203838,18964939,1820383717313525,22195457,18139690,16837842,22296366,14106803,1784282521352646,22657942,22594718,16360112,20657441,22195441,1738919226198926,14565184,17019345,17205719,18740837,18440095,1476482922195448,14354737,17019086,13944971,16571443,21868720,1718690517080436,18673342,22905130,17027426,27374796,19972569,1997256820144308,19972566,17282229,19972564,16870214,16410570,2162906419615136,26039623,21354456,17390431,18762750,23007241,1661396417957017,18098207,17484762,18471685,19730508,21538485,1826406017323222,17754782,17600719,18317531,17852463,17596908,1816601317655634,16228604,27053456,20074391,24790914,19972570,2085676619891090,18090142,18996843,19854503,16042673,22901797,1783562720334344,17393683,20861693,18000422,17551709,26575788,2331588920506699,19006849,18277454,18456514,19174430,17258090,1717458225654936,17242746,16399083,17824637,21132297,22465352,1776229622168163,18604692,17397545,16450169,12364061,20067212,1885699919211724,19463893,19463897,21343775,17853456,18673304,2000402126030218,21668627,16194160,17477958,23140259,16538760,1298256624570598,20828947,18259031,20296213,18293054,17610798,1969919123065323,17311728,18135678,18774543,23294548,16785708,1013647324560906,22551446,19777862,17786518,25879984,18315328,1833458612747740,18096714,19032867,21641760,17390160,18899974,1723201416354467,26245237,26679352,20598042,17484731,18673325,1642254118155762,14015842,19827973,22683225,17726838,18554871,2317764818051556,20803583,21972320,15990359,17922254,18282562,1685529216668584,21343838,20299015,17446237,18093615,18043064,2371323617694209,17288409,18308268,20475845,17274537,13955826,1693480317634921,17501491,16315398,22683212,23725036,17006183,1382954318191164,17655240,22809871,26746894,18384391,19393542,2153856716198143,21847223,25823754,17892268,20142975,19584068,1716520425165496,18604493,21756699,18508861,16901385,18554763,2153275518189036,17443671,17385178,14829250,17936109,20925795,2050948217478514,27441326,16850630,13951456,16595641,14054676,1586177521142837,16912439,17299889,17297939,23003979,18619917,1683352717798953,17816865,25914276,18607546,17571306,21286665,1734132626910644,17851160,20558005,17586955,19049453,21051840,1758706316956380,18328509,25423453,14133975,19718981,18061914,1751865218522509,21051833,20294666,18765602,20860659,18272672,2032404918199537,17332800,13609098,22502493,18384537,14338435,1794598316392068,21067387,17752995,21051862,16863422,17237521,2550538218244962,19544839,24433711,24717859,17156148,18973907,2302658517877323,17449815,18180390,17088068,17037130,20004087,2142258019466309,11733603,25505371,18610915,21051858,18084625,2624369818674024,21051852,18091059,25369547,16306373,18306996,1778725918193833,19915271,20513399,20631274,25879656,16344544,1469276218614015,17346091,18228645,17721717,13960236,18685892,1843630721756677,19888853,11883252,17891943,19475971,22353199,1638498319121551,25634317,27825893,12816846,17982555,17761775,2224371917265217,25505394,17071721,16721594,18262334,21756661,1789194615913355,17672719,17602269,25555252,17239687,17042658,1723851117811456,17284817,17752121,20879889,21380789,17394950,1701183216579084,22195465,14602788,18325460,24476265,26569225,2447627412611721,18674465,16903536,17006570,19689979,16043574,1878322424662775,16494615,21526048,17392698,19197175,16069901,1781144727870645,17308789,22195477,24835538,17865671,17343514,1901318317325413,18316692,16180763,17348614,14368995,21983325,1739391516285691,19211433,20331945,17883081,17705023,24316947,1761422719578350,22195485,24975421,14084247,26078387,23115139,1364587516777840,19727057,14852021,18744139,18674047,17716305,1928502518482502,17622427,19289642,27534509,22195492,25947799,1445821420869721,21172913,17767676,18723434,25505407,17786278,1925850417082983,21351877,17365043,13498382,18331812,16065166,2548960716685417,18031668,22893153,17551674,16943711,19272701,2151744025897615,17649265,13866822,18094246,24528741,17783588,1424553117082359,18280813,20448824,23330119,16268425,19487147,2560042118018515,17302277,17215560,24411921,19271443,14176370,2576402017016369,20777150,23330124,16756406,20441797,19769489,2810048717545847,25093656,18260550,13853126,17551699,17227277,2353683525957038,24652769,20725343,19207117,9756271,18868646,1761413426667023,17546973,18704244,19680952,26667015,17050888,1882886818273830,17360606,16992075,24563422,17375354,12905058,1836222221429602,28364007,26667032,27086138,17571039,17468141,1843664717570606,17235750,21168487,17279227,16220077,16929165--------------------------------------------------------------------------------OPatchsucceeded.

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

[oracle@localhost28689165]$cd$ORACLE_HOME/rdbms/admin[oracle@localhostadmin]$sqlSQL*Plus:Release11.2.0.4.0ProductiononMonMar2511:10:532019Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions11:10:53SYS@std>@catbundle.sqlpsuapplyPL/SQLproceduresuccessfullycompleted.Elapsed:00:00:00.00Functioncreated.Elapsed:00:00:00.14Functioncreated.manymorelinescompressed

以上是“Oracle 11.2.0.4如何添加补丁”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！