最近生产上要给Oracle数据库打11g最新的补丁，这里先做一个测试记录一下。
Oracle数据库所有补丁的MOS文档ID 1922396.1下载地址：https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=242245405602967&id=1577380.1&_afrWindowMode=0&_adf.ctrl-state=zv36z4hoo_53这个下载需要有MOS账号
Oracle数据库的补丁有几种：PSU、SPU、cpu等，这次打的PSU24006111(11.2.0.4.161018)
平台：OS Linux6.7 x86-64+Oracle 11.2.0.4.0单实例
升级方法已经在补丁包里的README.html文档里写的很清楚了，这里只是做个演示。
1、下载最新的的PSU包和最新的OPatch包，上传到服务器上
p24006111_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
2、解压压缩包，并把OPatch替换原ORACLE_HOME里的OPatch目录
[oracle@rhel6psu]$unzipp24006111_112040_Linux-x86-64.zip [oracle@rhel6psu]$unzipp6880880_112000_Linux-x86-64.zip [oracle@rhel6psu]$ls-l|grep^d drwxrwxr-x14oracleoinstall4096Aug2621:5624006111 drwxr-x---10oracleoinstall4096Aug182015OPatch [oracle@rhel6psu]$mv$ORACLE_HOME/OPatch$ORACLE_HOME/OPatch_bak [oracle@rhel6psu]$mvOPatch/$ORACLE_HOME
3、配置OPatch的环境变量
[oracle@rhel6psu]$vi~/.bash_profile #添加 exportPATH=$PATH:$ORACLE_HOME/OPatch [oracle@rhel6psu]$source~/.bash_profile [oracle@rhel6psu]$whichopatch /u02/app/oracle/product/11.2.4/db1/OPatch/opatch #查看当前数据库的补丁情况 [oracle@rhel6psu]$opatchlsinventory OracleInterimPatchInstallerversion11.2.0.3.12 Copyright(c)2016,OracleCorporation.Allrightsreserved. OracleHome:/u02/app/oracle/product/11.2.4/db1 CentralInventory:/u01/app/oraInventory from:/u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatchversion:11.2.0.3.12 OUIversion:11.2.0.4.0 Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-45-47AM_1.log LsinventoryOutputfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_10-45-47AM.txt -------------------------------------------------------------------------------- LocalMachineInformation:: Hostname:rhel6 ARUplatformid:226 ARUplatformdescription::Linuxx86-64 InstalledTop-levelProducts(1): OracleDatabase11g11.2.0.4.0 Thereare1productsinstalledinthisOracleHome. TherearenoInterimpatchesinstalledinthisOracleHome. -------------------------------------------------------------------------------- OPatchsucceeded.
4、升级前检查是否有冲突
[oracle@rhel6psu]$cd24006111/ [oracle@rhel624006111]$opatchprereqCheckConflictAgainstOHWithDetail-ph./ OracleInterimPatchInstallerversion11.2.0.3.12 Copyright(c)2016,OracleCorporation.Allrightsreserved. PREREQsession OracleHome:/u02/app/oracle/product/11.2.4/db1 CentralInventory:/u01/app/oraInventory from:/u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatchversion:11.2.0.3.12 OUIversion:11.2.0.4.0 Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-49-53AM_1.log Invokingprereq"checkconflictagainstohwithdetail" Prereq"checkConflictAgainstOHWithDetail"passed. OPatchsucceeded.
5、安装Patch包，单实例的数据库按如下方法打patch就可以了，如果是RAC则需要详细查看README.html
[oracle@rhel6psu]$cd24006111/ [oracle@rhel624006111]$opatchapply OracleInterimPatchInstallerversion11.2.0.3.12 Copyright(c)2016,OracleCorporation.Allrightsreserved. OracleHome:/u02/app/oracle/product/11.2.4/db1 CentralInventory:/u01/app/oraInventory from:/u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatchversion:11.2.0.3.12 OUIversion:11.2.0.4.0 Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log Verifyingenvironmentandperformingprerequisitechecks... Prerequisitecheck"CheckActiveFilesAndExecutables"Failed. Thedetailsare: Followingexecutablesareactive: /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 UtilSessionFailed:Prerequisitecheck"CheckActiveFilesAndExecutables"Failed. Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log OPatchFailedwitherrorcode73 #打补丁报错，查看日志 [oracle@rhel624006111]$more/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_10-53-13AM_1.log ...... [Dec20,201610:53:21AM]Followingexecutablesareactive: /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 [Dec20,201610:53:21AM]Prerequisitecheck"CheckActiveFilesAndExecutables"Failed. Thedetailsare: Followingexecutablesareactive: /u02/app/oracle/product/11.2.4/db1/bin/oracle /u02/app/oracle/product/11.2.4/db1/lib/libclntsh.so.11.1 ...... #这个错误的意思是检测到有命令正在运行，不能进行升级，停止数据库和监听 [oracle@rhel624006111]$sqlplus/assysdba sql*Plus:Release11.2.0.4.0ProductiononTueDec2010:57:162016 Copyright(c)1982,2013,Oracle.Allrightsreserved. Connectedto: OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions sys@ORCL>shutdownimmediate; Databaseclosed. Databasedismounted. ORACLEinstanceshutdown. sys@ORCL>exit DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction WiththePartitioning,DataMiningandRealApplicationTestingoptions [oracle@rhel624006111]$lsnrctlstop LSNRCTLforLinux:Version11.2.0.4.0-Productionon20-DEC-201610:58:32 Copyright(c)1991,Oracle.Allrightsreserved. Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) Thecommandcompletedsuccessfully [oracle@rhel624006111]$ps-ef|grepora root23612342010:11pts/000:00:00su-oracle oracle23622361010:11pts/000:00:01-bash oracle34092362010:59pts/000:00:00ps-ef oracle34102362010:59pts/000:00:00grepora #重新打补丁 [oracle@rhel624006111]$opatchapply OracleInterimPatchInstallerversion11.2.0.3.12 Copyright(c)2016,OracleCorporation.Allrightsreserved. OracleHome:/u02/app/oracle/product/11.2.4/db1 CentralInventory:/u01/app/oraInventory from:/u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatchversion:11.2.0.3.12 OUIversion:11.2.0.4.0 Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-18-32AM_1.log Verifyingenvironmentandperformingprerequisitechecks... OPatchcontinueswiththesepatches:174785141803166818522509191215511976948920299013207609822135263521948347225024562305435924006111 Doyouwanttoproceed?[y|n] y UserRespondedwith:Y Allcheckspassed. Provideyouremailaddresstobeinformedofsecurityissues,installand initiateOracleConfigurationManager.EasierforyouifyouuseyourMy OracleSupportEmailaddress/UserName. Visithttp://www.oracle.com/support/policies.htmlfordetails. Emailaddress/UserName: Youhavenotprovidedanemailaddressfornotificationofsecurityissues. Doyouwishtoremainuninformedofsecurityissues([Y]es,[N]o)[N]:y PleaseshutdownOracleinstancesrunningoutofthisORACLE_HOMEonthelocalsystem. (OracleHome='/u02/app/oracle/product/11.2.4/db1') Isthelocalsystemreadyforpatching?[y|n] y UserRespondedwith:Y Backingupfiles... Applyingsub-patch'17478514'toOH'/u02/app/oracle/product/11.2.4/db1' ...... Compositepatch24006111successfullyapplied. Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-18-32AM_1.log OPatchsucceeded.
6、升级数据字典并重新编译无效对象
[oracle@rhel624006111]$sqlplus/assysdba idle>startup ...... idle>@?/rdbms/admin/catbundle.sqlpsuapply ....... idle>SPOOLoff idle>SETechooff Checkthefollowinglogfileforerrors: /u02/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2016Dec20_11_30_47.log #检查日志没有报错 #编译失效对象 sys@ORCL>@?/rdbms/admin/utlrp.sql #检查升级情况 sys@ORCL>colaction_timefora30 sys@ORCL>colactionfora10 sys@ORCL>colnamespacefora20 sys@ORCL>colversionfora20 sys@ORCL>colbundle_seriesfora30 sys@ORCL>colcommentsfora30 sys@ORCL>select*fromdba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION IDBUNDLE_SERIES COMMENTS ------------------------------------------------------------------------------------------------------------------------------------------------------ 24-AUG-1312.03.45.119862PMAPPLY SERVER 11.2.0.4 0PSU Patchset11.2.0.2.0 07-JUL-1611.03.29.165250AMAPPLY SERVER 11.2.0.4 0PSU Patchset11.2.0.2.0 20-DEC-1611.32.28.671654AMAPPLY SERVER 11.2.0.4 161018PSU PSU11.2.0.4.161018 #使用opatch命令查看补丁情况 [oracle@rhel624006111]$opatchlsinventory OracleInterimPatchInstallerversion11.2.0.3.12 Copyright(c)2016,OracleCorporation.Allrightsreserved. OracleHome:/u02/app/oracle/product/11.2.4/db1 CentralInventory:/u01/app/oraInventory from:/u02/app/oracle/product/11.2.4/db1/oraInst.loc OPatchversion:11.2.0.3.12 OUIversion:11.2.0.4.0 Logfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/opatch2016-12-20_11-52-01AM_1.log LsinventoryOutputfilelocation:/u02/app/oracle/product/11.2.4/db1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-20_11-52-01AM.txt -------------------------------------------------------------------------------- LocalMachineInformation:: Hostname:rhel6 ARUplatformid:226 ARUplatformdescription::Linuxx86-64 InstalledTop-levelProducts(1): OracleDatabase11g11.2.0.4.0 Thereare1productsinstalledinthisOracleHome. Interimpatches(1): Patch24006111:appliedonTueDec2011:24:30CST2016 UniquePatchID:20508568 Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.161018(24006111)" Createdon26Aug2016,05:54:48hrsPST8PDT 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: 17288409,21051852,24316947,17811429,18607546,17205719,20506699 17816865,17922254,23330119,17754782,16934803,13364795,17311728 17441661,17284817,16992075,17446237,14015842,19972569,21756677 17375354,20925795,21538558,17449815,19463897,13866822,17235750 17982555,17478514,18317531,14338435,18235390,20803583,13944971 20142975,17811789,16929165,18704244,20506706,17546973,20334344 14054676,17088068,17346091,18264060,17343514,21538567,19680952 18471685,19211724,13951456,21847223,16315398,18744139,16850630 23177648,19049453,18673304,17883081,19915271,18641419,18262334 17006183,16065166,18277454,16833527,10136473,18051556,17865671 17852463,18554871,17853498,18334586,17551709,17588480,19827973 17344412,17842825,18828868,17025461,11883252,13609098,17239687 17602269,19197175,22195457,18316692,17313525,12611721,19544839 18964939,17600719,18191164,19393542,17571306,20777150,18482502 19466309,22243719,17040527,17165204,18098207,16785708,17465741 17174582,16180763,16777840,12982566,19463893,22195465,22148226 16875449,12816846,17237521,6599380,19358317,17811438,17811447 17945983,21983325,18762750,16912439,17184721,18061914,17282229 18331850,18202441,17082359,18723434,21972320,19554106,14034426 18339044,19458377,17752995,20448824,17891943,17258090,17767676 16668584,18384391,17040764,17381384,15913355,18356166,14084247 20596234,20506715,21756661,13853126,18203837,14245531,16043574 21756699,22195441,17848897,17877323,21453153,17468141,20861693 17786518,17912217,17037130,16956380,18155762,17478145,17394950 18641461,18189036,18619917,17027426,21352646,16268425,24476274 22195492,19584068,18436307,22507210,17265217,17634921,13498382 21526048,19258504,20004087,17443671,22195485,18000422,22321756 20004021,17571039,21067387,16344544,18009564,14354737,21286665 18135678,18614015,20441797,18362222,17835048,16472716,17936109 17050888,17325413,14010183,18747196,17761775,16721594,17082983 20067212,21179898,17302277,18084625,15990359,18203835,17297939 17811456,22380919,16731148,21168487,14133975,13829543,17215560 17694209,17385178,18091059,8322815,17586955,17201159,17655634 18331812,19730508,18868646,17648596,16220077,16069901,17348614 17393915,17274537,17957017,18096714,17308789,18436647,14285317 19289642,14764829,18328509,17622427,16943711,22195477,14368995 22502493,17346671,18996843,17783588,21343838,16618694,17672719 18856999,18783224,17851160,17546761,17798953,18273830,22092979 16596890,19972566,16384983,17726838,22296366,17360606,22321741 13645875,18199537,16542886,21787056,17889549,14565184,17071721 17610798,20299015,21343897,22893153,20657441,17397545,18230522 16360112,19769489,12905058,18641451,12747740,18430495,17016369 17042658,14602788,17551063,19972568,21517440,18508861,19788842 14657740,17332800,13837378,19972564,17186905,18315328,19699191 17437634,22353199,18093615,19006849,19013183,17296856,18674024 17232014,16855292,17762296,14692762,21051840,17705023,22507234 19121551,21330264,19854503,21868720,19309466,18681862,20558005 18554763,17390160,18456514,16306373,13955826,18139690,17501491 17752121,21668627,17299889,17889583,18673325,19721304,18293054 17242746,17951233,18094246,17649265,19615136,17011832,16870214 17477958,18522509,20631274,16091637,17323222,16595641,16524926 18228645,18282562,17596908,18031668,17156148,16494615,22683225 17545847,17655240,24528741,17614134,13558557,17341326,17891946 17716305,22657942,16392068,19271443,21351877,18092127,17614227 18440047,16903536,14106803,18973907,18673342,19032867,17389192 17612828,16194160,17006570,17721717,17390431,17570240,16863422 18325460,19727057,16422541,19972570,17267114,18244962,21538485 18765602,18203838,16198143,17246576,14829250,17835627,18247991 14458214,21051862,16692232,17786278,17227277,24476265,16042673 16314254,16228604,16837842,17393683,23536835,17787259,20331945 20074391,15861775,16399083,18018515,22683212,18260550,21051858 17080436,16613964,17036973,16579084,24433711,18384537,18280813 20296213,16901385,15979965,23330124,18441944,16450169,9756271 17892268,11733603,16285691,17587063,21343775,18180390,16538760 18193833,21387964,21051833,17238511,17824637,16571443,18306996 14852021,17853456,18674047,12364061,22195448 -------------------------------------------------------------------------------- OPatchsucceeded.
7、升级失败回滚
opatch rollback -id 24006111 原文链接：https://www.f2er.com/oracle/211214.html