所需補丁及高版本opatch
image上傳后將p6880880_112000_Linux-x86-64.zip
解壓覆蓋$ORACLE_HOME/OPatch
目錄即可
[oracle@localhost OPatch]$ ./opatch versionOPatch Version: 11.2.0.3.16 OPatch succeeded.
檢查環境是否需要打補丁,opatch版本安裝環境可以看mos和readme 查看組件信息
12:40:47 SYS@std> set linesize 500 pagesize 60012:40:49 SYS@std> col COMP_NAME for a3012: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 VALIDAPEX Oracle Application Express 3.2.1.00.12 VALIDEM Oracle Enterprise Manager 11.2.0.4.0 VALIDAMD OLAP Catalog 11.2.0.4.0 VALIDSDO Spatial 11.2.0.4.0 VALIDORDIM Oracle Multimedia 11.2.0.4.0 VALIDXDB Oracle XML Database 11.2.0.4.0 VALIDCONTEXT Oracle Text 11.2.0.4.0 VALIDEXF Oracle Expression Filter 11.2.0.4.0 VALIDRUL Oracle Rules Manager 11.2.0.4.0 VALIDOWM Oracle Workspace Manager 11.2.0.4.0 VALIDCATALOG Oracle Database Catalog Views 11.2.0.4.0 VALIDCATPROC Oracle Database Packages and T 11.2.0.4.0 VALID ypesJAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALIDXML Oracle XDK 11.2.0.4.0 VALIDCATJAVA Oracle Database Java Packages 11.2.0.4.0 VALIDAPS OLAP Analytic Workspace 11.2.0.4.0 VALIDXOQ Oracle OLAP API 11.2.0.4.0 VALID18 rows selected.Elapsed: 00:00:00.04
查看補丁情況
12:41:11 SYS@std> col ACTION_TIME for a3012:46:03 SYS@std> col COMMENTS for a3012: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.022-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.16Copyright (c) 2019, Oracle Corporation. All rights reserved.PREREQ sessionOracle Home : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version : 11.2.0.3.16OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45PM_1.logInvoking 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 stopLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2019 13:12:51Copyright (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 lsinventoryOracle Interim Patch Installer version 11.2.0.3.16Copyright (c) 2019, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version : 11.2.0.3.16OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35AM_1.logLsinventory 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: localhostARU platform id: 226ARU platform description:: Linux x86-64Installed Top-level Products (1):Oracle Database 11g 11.2.0.4.0There 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/28689165many 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 lsinventoryOracle Interim Patch Installer version 11.2.0.3.16Copyright (c) 2019, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version : 11.2.0.3.16OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_09-02-42AM_1.logLsinventory 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: localhostARU platform id: 226ARU platform description:: Linux x86-64Installed Top-level Products (1):Oracle Database 11g 11.2.0.4.0There are 1 products installed in this Oracle Home.Interim patches (2) :Patch 28440700 : applied on Mon Mar 25 08:54:00 CST 2019Unique Patch ID: 22461927Patch 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, 21566944Patch 28204707 : applied on Mon Mar 25 08:53:49 CST 2019Unique Patch ID: 22491169Patch description: "Database Patch Set Update : 11.2.0.4.181016 (28204707)" Created on 19 Sep 2018, 03:24:06 hrs PST8PDTSub-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]$ sqlSQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 25 11:10:53 2019Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options11:10:53 SYS@std> @catbundle.sql psu applyPL/SQL procedure successfully completed.Elapsed: 00:00:00.00Function created.Elapsed: 00:00:00.14Function created.many more lines compressed
總結
以上所述是小編給大家介紹的Oracle 11.2.0.4打補丁的方法,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復大家的。在此也非常感謝大家對武林網網站的支持!
如果你覺得本文對你有幫助,歡迎轉載,煩請注明出處,謝謝!
新聞熱點
疑難解答