oracle 打补丁

青旅半醒 2023-06-14 15:58 17阅读 0赞

所需补丁及高版本opatch

![20191120110900323.png][]

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

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 </td> 
 <td> <code>[oracle@localhost OPatch]$ ./opatch version</code> <code>OPatch Version: 11.2.0.3.16</code> <code>&nbsp;</code>&nbsp; <code>OPatch succeeded.</code> </td> 
 </tr> 
 </tbody> 
</table>

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

查看补丁情况

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 </td> 
 <td> <code>12:41:11 SYS@std&gt; col ACTION_TIME </code><code>for</code> <code>a30</code> <code>12:46:03 SYS@std&gt; col COMMENTS </code><code>for</code> <code>a30</code> <code>12:46:07 SYS@std&gt; </code><code>select</code> <code>ACTION_TIME, </code><code>ACTION</code><code>,version, COMMENTS </code><code>from</code> <code>sys.DBA_REGISTRY_HISTORY;</code> <code>&nbsp;</code>&nbsp; <code>ACTION_TIME&nbsp;&nbsp;&nbsp;&nbsp; </code><code>ACTION</code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <code>VERSION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COMMENTS</code> <code>------------------------------ ------------------------------ ------------------------------ ------------------------------</code> <code>24-AUG-13 12.03.45.119862 PM APPLY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11.2.0.4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Patchset 11.2.0.2.0</code> <code>22-MAR-19 12.02.16.970055 PM APPLY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11.2.0.4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Patchset 11.2.0.2.0</code> <code>&nbsp;</code>&nbsp; <code>Elapsed: 00:00:00.01</code> </td> 
 </tr> 
 </tbody> 
</table>

查看无效对象

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 </td> 
 <td> <code>12:46:11 SYS@std&gt; </code><code>select</code> <code>count</code><code>(*) </code><code>from</code> <code>dba_objects </code><code>where</code> <code>status&lt;&gt;</code><code>'VALID'</code><code>;</code> <code>&nbsp;</code>&nbsp; <code>&nbsp;</code><code>COUNT</code><code>(*)</code> <code>----------</code> <code>&nbsp;&nbsp;&nbsp;</code><code>0</code> </td> 
 </tr> 
 </tbody> 
</table>

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

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 </td> 
 <td> <code>[oracle@localhost OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/28689165/ -oh $ORACLE_HOME&nbsp; </code> <code>Oracle Interim Patch Installer version 11.2.0.3.16</code> <code>Copyright (c) 2019, Oracle Corporation. </code><code>All</code> <code>rights reserved.</code> <code>PREREQ session</code> <code>Oracle Home&nbsp; : /u01/app/oracle/product/11.2.0/dbhome_1</code> <code>Central Inventory : /u01/app/oraInventory</code> <code>&nbsp;</code><code>from</code>&nbsp;&nbsp; <code>: /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc</code> <code>OPatch version : 11.2.0.3.16</code> <code>OUI version&nbsp; : 11.2.0.4.0</code> <code>Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45PM_1.log</code> <code>Invoking prereq </code><code>"checkconflictagainstohwithdetail"</code> <code>Prereq </code><code>"checkConflictAgainstOHWithDetail"</code> <code>passed.</code> <code>OPatch succeeded.</code> </td> 
 </tr> 
 </tbody> 
</table>

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

<table> 
 <tbody> 
 <tr> 
 <td> 1 </td> 
 <td> <code>ps -ef|grep -v grep |grep </code><code>LOCAL</code><code>=</code><code>NO</code><code>|awk </code><code>'{print $2}'</code><code>|xargs kill -9</code> </td> 
 </tr> 
 </tbody> 
</table>

停库

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 </td> 
 <td> <code>13:11:12 SYS@std&gt; shutdown immediate;</code> <code>Database</code> <code>closed.</code> <code>Database</code> <code>dismounted.</code> <code>ORACLE instance shut down.</code> <code>13:11:28 SYS@std&gt;</code> </td> 
 </tr> 
 </tbody> 
</table>

停止监听

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 </td> 
 <td> <code>[oracle@localhost OPatch]$ lsnrctl stop</code> <code>LSNRCTL </code><code>for</code> <code>Linux: Version 11.2.0.4.0 - Production </code><code>on</code> <code>22-MAR-2019 13:12:51</code> <code>Copyright (c) 1991, 2013, Oracle. </code><code>All</code> <code>rights reserved.</code> <code>Connecting </code><code>to</code> <code>(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))</code> <code>The command completed successfully</code> <code>[oracle@localhost OPatch]$</code> </td> 
 </tr> 
 </tbody> 
</table>

查看是否停干净

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 </td> 
 <td> <code>[oracle@localhost OPatch]$ ps -ef |grep ora_|grep -v grep</code> <code>[oracle@localhost OPatch]$ netstat -an |grep 1158</code> <code>[oracle@localhost OPatch]$ netstat -an|grep 1521</code> <code>[oracle@localhost OPatch]$</code> </td> 
 </tr> 
 </tbody> 
</table>

正式打补丁

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 </td> 
 <td> <code>[oracle@localhost OPatch]$ ./opatch lsinventory</code> <code>Oracle Interim Patch Installer version 11.2.0.3.16</code> <code>Copyright (c) 2019, Oracle Corporation. </code><code>All</code> <code>rights reserved.</code> <code>Oracle Home&nbsp; : /u01/app/oracle/product/11.2.0/dbhome_1</code> <code>Central Inventory : /u01/app/oraInventory</code> <code>&nbsp;</code><code>from</code>&nbsp;&nbsp; <code>: /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc</code> <code>OPatch version : 11.2.0.3.16</code> <code>OUI version&nbsp; : 11.2.0.4.0</code> <code>Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35AM_1.log</code> <code>Lsinventory </code><code>Output</code> <code>file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35AM.txt</code> <code>--------------------------------------------------------------------------------</code> <code>Local</code> <code>Machine Information::</code> <code>Hostname: localhost</code> <code>ARU platform id: 226</code> <code>ARU platform description:: Linux x86-64</code> <code>Installed </code><code>Top</code><code>-</code><code>level</code> <code>Products (1):</code> <code>Oracle </code><code>Database</code> <code>11g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11.2.0.4.0</code> <code>There are 1 products installed </code><code>in</code> <code>this Oracle Home.</code> <code>There are </code><code>no</code> <code>Interim patches installed </code><code>in</code> <code>this Oracle Home.</code> <code>--------------------------------------------------------------------------------</code> <code>OPatch succeeded.</code> <code>[oracle@localhost OPatch]$</code> &nbsp; <code>./opatch napply -oh $ORACLE_HOME -</code><code>local</code> <code>/home/oracle/28689165</code> <code>many more lines compressed..</code> <code>+ 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/ </code><code>'_LIBNAME_LIBS=$(libnmcfhcLIBS)'</code> <code>'_LIBNAME_EXTRALIBS=$(libnmcfhcEXTRALIBS)'</code> <code>+ PATH=/bin:/usr/bin:/usr/ccs/bin</code> <code>+ export PATH</code> <code>+ lib=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so</code> <code>+ makefile=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk</code> <code>+ so_ext=so</code> <code>+ target=new_ld_shlib</code> <code>+ var=</code> <code>++ basename /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so .so</code> <code>+ libname=libnmcfsga</code> <code>++ dirname /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so</code> <code>+ dir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib</code> <code>+ </code><code>'['</code> <code>var = new_ld_shlib </code><code>']'</code> <code>+ </code><code>'['</code> <code>-f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.a </code><code>']'</code> <code>+ dir2=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/</code> <code>+ </code><code>'['</code> <code>''</code> <code>'!='</code> <code>''</code> <code>']'</code> <code>+ 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/ </code><code>'_LIBNAME_LIBS=$(libnmcfsgaLIBS)'</code> <code>'_LIBNAME_EXTRALIBS=$(libnmcfsgaEXTRALIBS)'</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>/bin/ld: warning: -z lazyload ignored.</code> <code>/bin/ld: warning: -z nolazyload ignored.</code> <code>Composite patch 28204707 successfully applied.</code> <code>Patch 28440700 successfully applied.</code> <code>OPatch Session completed </code><code>with</code> <code>warnings.</code> <code>Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-50-02AM_1.log</code> <code>&nbsp;</code>&nbsp; <code>OPatch completed </code><code>with</code> <code>warnings.</code> &nbsp; <code>[oracle@localhost OPatch]$ ./opatch lsinventory</code> <code>Oracle Interim Patch Installer version 11.2.0.3.16</code> <code>Copyright (c) 2019, Oracle Corporation. </code><code>All</code> <code>rights reserved.</code> <code>Oracle Home&nbsp; : /u01/app/oracle/product/11.2.0/dbhome_1</code> <code>Central Inventory : /u01/app/oraInventory</code> <code>&nbsp;</code><code>from</code>&nbsp;&nbsp; <code>: /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc</code> <code>OPatch version : 11.2.0.3.16</code> <code>OUI version&nbsp; : 11.2.0.4.0</code> <code>Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_09-02-42AM_1.log</code> <code>Lsinventory </code><code>Output</code> <code>file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_09-02-42AM.txt</code> <code>--------------------------------------------------------------------------------</code> <code>Local</code> <code>Machine Information::</code> <code>Hostname: localhost</code> <code>ARU platform id: 226</code> <code>ARU platform description:: Linux x86-64</code> <code>Installed </code><code>Top</code><code>-</code><code>level</code> <code>Products (1):</code> <code>Oracle </code><code>Database</code> <code>11g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11.2.0.4.0</code> <code>There are 1 products installed </code><code>in</code> <code>this Oracle Home.</code> <code>Interim patches (2) :</code> <code>Patch 28440700&nbsp; : applied </code><code>on</code> <code>Mon Mar 25 08:54:00 CST 2019</code> <code>Unique</code> <code>Patch ID: 22461927</code> <code>Patch description: </code><code>"OJVM PATCH SET UPDATE 11.2.0.4.181016"</code> <code>&nbsp;</code><code>Created </code><code>on</code> <code>15 Oct 2018, 08:12:17 hrs PST8PDT</code> <code>&nbsp;</code><code>Bugs fixed:</code> <code>&nbsp;&nbsp;</code><code>18933818, 19176885, 17201047, 25649873, 25067795, 28502128, 27952577</code> <code>&nbsp;&nbsp;</code><code>14774730, 27461842, 19153980, 21911849, 23727132, 18166577, 27000663</code> <code>&nbsp;&nbsp;</code><code>24448240, 17056813, 21811517, 19909862, 25494379, 22675136, 24534298</code> <code>&nbsp;&nbsp;</code><code>19895326, 22253904, 17804361, 19231857, 27642235, 26023002, 17528315</code> <code>&nbsp;&nbsp;</code><code>19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988</code> <code>&nbsp;&nbsp;</code><code>23265914, 19699946, 19006757, 19374518, 19223010, 25076732, 22118835</code> <code>&nbsp;&nbsp;</code><code>26637592, 19852360, 20408829, 21047766, 21566944</code> <code>Patch 28204707&nbsp; : applied </code><code>on</code> <code>Mon Mar 25 08:53:49 CST 2019</code> <code>Unique</code> <code>Patch ID: 22491169</code> <code>Patch description: </code><code>"Database Patch Set Update : 11.2.0.4.181016 (28204707)"</code> <code>&nbsp;</code><code>Created </code><code>on</code> <code>19 Sep 2018, 03:24:06 hrs PST8PDT</code> <code>Sub-patch 27734982; </code><code>"Database Patch Set Update : 11.2.0.4.180717 (27734982)"</code> <code>Sub-patch 27338049; </code><code>"Database Patch Set Update : 11.2.0.4.180417 (27338049)"</code> <code>Sub-patch 26925576; </code><code>"Database Patch Set Update : 11.2.0.4.180116 (26925576)"</code> <code>Sub-patch 26392168; </code><code>"Database Patch Set Update : 11.2.0.4.171017 (26392168)"</code> <code>Sub-patch 26609445; </code><code>"Database Patch Set Update : 11.2.0.4.170814 (26609445)"</code> <code>Sub-patch 25869727; </code><code>"Database Patch Set Update : 11.2.0.4.170718 (25869727)"</code> <code>Sub-patch 24732075; </code><code>"Database Patch Set Update : 11.2.0.4.170418 (24732075)"</code> <code>Sub-patch 24006111; </code><code>"Database Patch Set Update : 11.2.0.4.161018 (24006111)"</code> <code>Sub-patch 23054359; </code><code>"Database Patch Set Update : 11.2.0.4.160719 (23054359)"</code> <code>Sub-patch 22502456; </code><code>"Database Patch Set Update : 11.2.0.4.160419 (22502456)"</code> <code>Sub-patch 21948347; </code><code>"Database Patch Set Update : 11.2.0.4.160119 (21948347)"</code> <code>Sub-patch 21352635; </code><code>"Database Patch Set Update : 11.2.0.4.8 (21352635)"</code> <code>Sub-patch 20760982; </code><code>"Database Patch Set Update : 11.2.0.4.7 (20760982)"</code> <code>Sub-patch 20299013; </code><code>"Database Patch Set Update : 11.2.0.4.6 (20299013)"</code> <code>Sub-patch 19769489; </code><code>"Database Patch Set Update : 11.2.0.4.5 (19769489)"</code> <code>Sub-patch 19121551; </code><code>"Database Patch Set Update : 11.2.0.4.4 (19121551)"</code> <code>Sub-patch 18522509; </code><code>"Database Patch Set Update : 11.2.0.4.3 (18522509)"</code> <code>Sub-patch 18031668; </code><code>"Database Patch Set Update : 11.2.0.4.2 (18031668)"</code> <code>Sub-patch 17478514; </code><code>"Database Patch Set Update : 11.2.0.4.1 (17478514)"</code> <code>&nbsp;</code><code>Bugs fixed:</code> <code>&nbsp;&nbsp;</code><code>21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965</code> <code>&nbsp;&nbsp;</code><code>20671094, 16731148, 16314254, 13837378, 18441944, 17291347, 17835048</code> <code>&nbsp;&nbsp;</code><code>28254374, 21656630, 21842740, 13558557, 17008068, 17201159, 25427662</code> <code>&nbsp;&nbsp;</code><code>17853498, 20717359, 17246576, 18356166, 18681862, 18440047, 20569094</code> <code>&nbsp;&nbsp;</code><code>20031873, 16875449, 20387265, 19788842, 17296856, 21330264, 14010183</code> <code>&nbsp;&nbsp;</code><code>17648596, 17551063, 17025461, 24719736, 21063322, 17267114, 22507210</code> <code>&nbsp;&nbsp;</code><code>17912217, 17889583, 18202441, 17040764, 17478145, 16524926, 25655390</code> <code>&nbsp;&nbsp;</code><code>19358317, 22730454, 22148226, 18747196, 26544823, 18641419, 17036973</code> <code>&nbsp;&nbsp;</code><code>18948177, 17811789, 16542886, 14285317, 18009564, 17359610, 16618694</code> <code>&nbsp;&nbsp;</code><code>8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092</code> <code>&nbsp;&nbsp;</code><code>24624166, 26631046, 19429927, 24348685, 17848897, 17441661, 14034426</code> <code>&nbsp;&nbsp;</code><code>17465741, 20273319, 19207156, 16596890, 17437634, 21343897, 20506706</code> <code>&nbsp;&nbsp;</code><code>21453153, 18339044, 17951233, 22321741, 21795111, 18430495, 21787056</code> <code>&nbsp;&nbsp;</code><code>22380919, 19692824, 19469538, 20506715, 17811429, 19721304, 17903598</code> <code>&nbsp;&nbsp;</code><code>18230522, 19554106, 19458377, 21281607, 17612828, 6599380, 22092979</code> <code>&nbsp;&nbsp;</code><code>17040527, 22321756, 17811438, 18641461, 18682983, 25635149, 14657740</code> <code>&nbsp;&nbsp;</code><code>13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390</code> <code>&nbsp;&nbsp;</code><code>26474853, 18849970, 17889549, 19309466, 16472716, 25775213, 20596234</code> <code>&nbsp;&nbsp;</code><code>18331850, 18641451, 17019356, 17344412, 19461270, 21179898, 17546761</code> <code>&nbsp;&nbsp;</code><code>24842886, 17231779, 14521849, 18203835, 18203838, 18964939, 18203837</code> <code>&nbsp;&nbsp;</code><code>17313525, 22195457, 18139690, 16837842, 22296366, 14106803, 17842825</code> <code>&nbsp;&nbsp;</code><code>21352646, 22657942, 22594718, 16360112, 20657441, 22195441, 17389192</code> <code>&nbsp;&nbsp;</code><code>26198926, 14565184, 17019345, 17205719, 18740837, 18440095, 14764829</code> <code>&nbsp;&nbsp;</code><code>22195448, 14354737, 17019086, 13944971, 16571443, 21868720, 17186905</code> <code>&nbsp;&nbsp;</code><code>17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568</code> <code>&nbsp;&nbsp;</code><code>20144308, 19972566, 17282229, 19972564, 16870214, 16410570, 21629064</code> <code>&nbsp;&nbsp;</code><code>19615136, 26039623, 21354456, 17390431, 18762750, 23007241, 16613964</code> <code>&nbsp;&nbsp;</code><code>17957017, 18098207, 17484762, 18471685, 19730508, 21538485, 18264060</code> <code>&nbsp;&nbsp;</code><code>17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 18166013</code> <code>&nbsp;&nbsp;</code><code>17655634, 16228604, 27053456, 20074391, 24790914, 19972570, 20856766</code> <code>&nbsp;&nbsp;</code><code>19891090, 18090142, 18996843, 19854503, 16042673, 22901797, 17835627</code> <code>&nbsp;&nbsp;</code><code>20334344, 17393683, 20861693, 18000422, 17551709, 26575788, 23315889</code> <code>&nbsp;&nbsp;</code><code>20506699, 19006849, 18277454, 18456514, 19174430, 17258090, 17174582</code> <code>&nbsp;&nbsp;</code><code>25654936, 17242746, 16399083, 17824637, 21132297, 22465352, 17762296</code> <code>&nbsp;&nbsp;</code><code>22168163, 18604692, 17397545, 16450169, 12364061, 20067212, 18856999</code> <code>&nbsp;&nbsp;</code><code>19211724, 19463893, 19463897, 21343775, 17853456, 18673304, 20004021</code> <code>&nbsp;&nbsp;</code><code>26030218, 21668627, 16194160, 17477958, 23140259, 16538760, 12982566</code> <code>&nbsp;&nbsp;</code><code>24570598, 20828947, 18259031, 20296213, 18293054, 17610798, 19699191</code> <code>&nbsp;&nbsp;</code><code>23065323, 17311728, 18135678, 18774543, 23294548, 16785708, 10136473</code> <code>&nbsp;&nbsp;</code><code>24560906, 22551446, 19777862, 17786518, 25879984, 18315328, 18334586</code> <code>&nbsp;&nbsp;</code><code>12747740, 18096714, 19032867, 21641760, 17390160, 18899974, 17232014</code> <code>&nbsp;&nbsp;</code><code>16354467, 26245237, 26679352, 20598042, 17484731, 18673325, 16422541</code> <code>&nbsp;&nbsp;</code><code>18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648</code> <code>&nbsp;&nbsp;</code><code>18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292</code> <code>&nbsp;&nbsp;</code><code>16668584, 21343838, 20299015, 17446237, 18093615, 18043064, 23713236</code> <code>&nbsp;&nbsp;</code><code>17694209, 17288409, 18308268, 20475845, 17274537, 13955826, 16934803</code> <code>&nbsp;&nbsp;</code><code>17634921, 17501491, 16315398, 22683212, 23725036, 17006183, 13829543</code> <code>&nbsp;&nbsp;</code><code>18191164, 17655240, 22809871, 26746894, 18384391, 19393542, 21538567</code> <code>&nbsp;&nbsp;</code><code>16198143, 21847223, 25823754, 17892268, 20142975, 19584068, 17165204</code> <code>&nbsp;&nbsp;</code><code>25165496, 18604493, 21756699, 18508861, 16901385, 18554763, 21532755</code> <code>&nbsp;&nbsp;</code><code>18189036, 17443671, 17385178, 14829250, 17936109, 20925795, 20509482</code> <code>&nbsp;&nbsp;</code><code>17478514, 27441326, 16850630, 13951456, 16595641, 14054676, 15861775</code> <code>&nbsp;&nbsp;</code><code>21142837, 16912439, 17299889, 17297939, 23003979, 18619917, 16833527</code> <code>&nbsp;&nbsp;</code><code>17798953, 17816865, 25914276, 18607546, 17571306, 21286665, 17341326</code> <code>&nbsp;&nbsp;</code><code>26910644, 17851160, 20558005, 17586955, 19049453, 21051840, 17587063</code> <code>&nbsp;&nbsp;</code><code>16956380, 18328509, 25423453, 14133975, 19718981, 18061914, 17518652</code> <code>&nbsp;&nbsp;</code><code>18522509, 21051833, 20294666, 18765602, 20860659, 18272672, 20324049</code> <code>&nbsp;&nbsp;</code><code>18199537, 17332800, 13609098, 22502493, 18384537, 14338435, 17945983</code> <code>&nbsp;&nbsp;</code><code>16392068, 21067387, 17752995, 21051862, 16863422, 17237521, 25505382</code> <code>&nbsp;&nbsp;</code><code>18244962, 19544839, 24433711, 24717859, 17156148, 18973907, 23026585</code> <code>&nbsp;&nbsp;</code><code>17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 21422580</code> <code>&nbsp;&nbsp;</code><code>19466309, 11733603, 25505371, 18610915, 21051858, 18084625, 26243698</code> <code>&nbsp;&nbsp;</code><code>18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259</code> <code>&nbsp;&nbsp;</code><code>18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762</code> <code>&nbsp;&nbsp;</code><code>18614015, 17346091, 18228645, 17721717, 13960236, 18685892, 18436307</code> <code>&nbsp;&nbsp;</code><code>21756677, 19888853, 11883252, 17891943, 19475971, 22353199, 16384983</code> <code>&nbsp;&nbsp;</code><code>19121551, 25634317, 27825893, 12816846, 17982555, 17761775, 22243719</code> <code>&nbsp;&nbsp;</code><code>17265217, 25505394, 17071721, 16721594, 18262334, 21756661, 17891946</code> <code>&nbsp;&nbsp;</code><code>15913355, 17672719, 17602269, 25555252, 17239687, 17042658, 17238511</code> <code>&nbsp;&nbsp;</code><code>17811456, 17284817, 17752121, 20879889, 21380789, 17394950, 17011832</code> <code>&nbsp;&nbsp;</code><code>16579084, 22195465, 14602788, 18325460, 24476265, 26569225, 24476274</code> <code>&nbsp;&nbsp;</code><code>12611721, 18674465, 16903536, 17006570, 19689979, 16043574, 18783224</code> <code>&nbsp;&nbsp;</code><code>24662775, 16494615, 21526048, 17392698, 19197175, 16069901, 17811447</code> <code>&nbsp;&nbsp;</code><code>27870645, 17308789, 22195477, 24835538, 17865671, 17343514, 19013183</code> <code>&nbsp;&nbsp;</code><code>17325413, 18316692, 16180763, 17348614, 14368995, 21983325, 17393915</code> <code>&nbsp;&nbsp;</code><code>16285691, 19211433, 20331945, 17883081, 17705023, 24316947, 17614227</code> <code>&nbsp;&nbsp;</code><code>19578350, 22195485, 24975421, 14084247, 26078387, 23115139, 13645875</code> <code>&nbsp;&nbsp;</code><code>16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 19285025</code> <code>&nbsp;&nbsp;</code><code>18482502, 17622427, 19289642, 27534509, 22195492, 25947799, 14458214</code> <code>&nbsp;&nbsp;</code><code>20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504</code> <code>&nbsp;&nbsp;</code><code>17082983, 21351877, 17365043, 13498382, 18331812, 16065166, 25489607</code> <code>&nbsp;&nbsp;</code><code>16685417, 18031668, 22893153, 17551674, 16943711, 19272701, 21517440</code> <code>&nbsp;&nbsp;</code><code>25897615, 17649265, 13866822, 18094246, 24528741, 17783588, 14245531</code> <code>&nbsp;&nbsp;</code><code>17082359, 18280813, 20448824, 23330119, 16268425, 19487147, 25600421</code> <code>&nbsp;&nbsp;</code><code>18018515, 17302277, 17215560, 24411921, 19271443, 14176370, 25764020</code> <code>&nbsp;&nbsp;</code><code>17016369, 20777150, 23330124, 16756406, 20441797, 19769489, 28100487</code> <code>&nbsp;&nbsp;</code><code>17545847, 25093656, 18260550, 13853126, 17551699, 17227277, 23536835</code> <code>&nbsp;&nbsp;</code><code>25957038, 24652769, 20725343, 19207117, 9756271, 18868646, 17614134</code> <code>&nbsp;&nbsp;</code><code>26667023, 17546973, 18704244, 19680952, 26667015, 17050888, 18828868</code> <code>&nbsp;&nbsp;</code><code>18273830, 17360606, 16992075, 24563422, 17375354, 12905058, 18362222</code> <code>&nbsp;&nbsp;</code><code>21429602, 28364007, 26667032, 27086138, 17571039, 17468141, 18436647</code> <code>&nbsp;&nbsp;</code><code>17570606, 17235750, 21168487, 17279227, 16220077, 16929165</code> <code>--------------------------------------------------------------------------------</code> <code>OPatch succeeded.</code> </td> 
 </tr> 
 </tbody> 
</table>

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

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 </td> 
 <td> <code>[oracle@localhost 28689165]$ cd $ORACLE_HOME/rdbms/admin</code> <code>[oracle@localhost admin]$ sql</code> <code>SQL*Plus: Release 11.2.0.4.0 Production </code><code>on</code> <code>Mon Mar 25 11:10:53 2019</code> <code>Copyright (c) 1982, 2013, Oracle. </code><code>All</code> <code>rights reserved.</code> <code>Connected </code><code>to</code><code>:</code> <code>Oracle </code><code>Database</code> <code>11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production</code> <code>With</code> <code>the Partitioning, OLAP, Data Mining </code><code>and</code> <code>Real</code> <code>Application Testing options</code> <code>11:10:53 SYS@std&gt; @catbundle.sql psu apply</code> <code>PL/SQL </code><code>procedure</code> <code>successfully completed.</code> <code>Elapsed: 00:00:00.00</code> <code>Function</code> <code>created.</code> <code>Elapsed: 00:00:00.14</code> <code>Function</code> <code>created.</code> <code>many more lines compressed</code> </td> 
 </tr> 
 </tbody> 
</table>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMzQ5NTQ_size_16_color_FFFFFF_t_70][]

[20191120110900323.png]: https://img-blog.csdnimg.cn/20191120110900323.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMzQ5NTQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191120111107830.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMzQ5NTQ=,size_16,color_FFFFFF,t_70