Oracle单实例打补丁

1.更新opatch包1.1 chown oracle.oinstall p6880880_112000_Linux-x86-64_opatch.zip1.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/OPatchexport PATH=$HOME/bin:$ORACLE_HOME/bin:$GRID_HOME/bin:$OPATCH_HOME:$PATHexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:$OPATCH_HOME/jlib)1.4 验证OPatch版本号opatch versionOPatch Version: 11.2.0.3.19OPatch succeeded.2.解压补丁包2.1 unzip p28204707_112040_Linux-x86-64.zip    在当前目录下生成文件夹 282047072.2 修改补丁使用权限 chown -R oracle.oinstall  282047073 打补丁前检查    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            y5.更新数据字典    @?/rdbms/admin/catbundle psu apply6.补丁后验证    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;