溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
1.更新opatch包 1.1 chown oracle.oinstall p6880880_112000_Linux-x86-64_opatch.zip 1.2 unzip p6880880_112000_Linux-x86-64_opatch.zip 解壓生成OPatch文件夾 1.3 替換$ORACLE_HOME/OPatch rm -rf $ORACLE_HOME/OPatch mv OPatch $ORACLE_HOME/ (為方便使用修改Oracle環境變量 export OPATCH_HOME=/u01/app/oracle/product/11.2.0/db_1/OPatch export PATH=$HOME/bin:$ORACLE_HOME/bin:$GRID_HOME/bin:$OPATCH_HOME:$PATH export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:$OPATCH_HOME/jlib ) 1.4 驗證OPatch版本號 opatch version OPatch Version: 11.2.0.3.19 OPatch succeeded. 2.解壓補丁包 2.1 unzip p28204707_112040_Linux-x86-64.zip 在當前目錄下生成文件夾 28204707 2.2 修改補丁使用權限 chown -R oracle.oinstall 28204707 3 打補丁前檢查 3.1 關閉數據庫 sqlplus / as sysdba shutdown immediate 關閉監聽 lsnrctl stop 3.2 補丁信息檢查 cd 28204707 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.19 Copyright (c) 2019, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.19 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3019-01-01_14-55-44PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. 4.打補丁 4.1 進入補丁目錄 cd 28204707 4.2 打補丁 opatch apply 依次輸入 y y 5.更新數據字典 @?/rdbms/admin/catbundle psu apply 6.補丁后驗證 opatch lspatches 28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707) OPatch succeeded. opatch lsinv Oracle Interim Patch Installer version 11.2.0.3.19 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.19 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3018-12-25_18-18-55PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-12-25_18-18-55PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: node3 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 28204707 : applied on Tue Dec 25 17:42:57 CST 2018 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. 數據庫驗證數據字典 set line 200 col action_time for a30 col action for a30 col namespace for a20 col version for a20 col id for 999999999999 col BUNDLE_SERIES for a30 col COMMENTS for a30 select * from dba_registry_history;
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
