Oracle Patch Bundle Update

Oracle Patch Bundle Update I. Introduction to related knowledge I only know CPU (Critical Patch Update) and PSU (Patch Set Update), but I do not know that there is a Bundle Patch, due to a TNS-12531 BUG, you need to install at least Patch bundle 22 on windows. Search through learning: patches in Oracle are divided into the following six types: Oracle Interim patches: A patch that is applied inbetween patchset releases with the Opatch utility. interim patches aresometimes also referred to as patchset exceptions. oracle Merge patches: A type of interim patch thatmerges multiple fixes to ensure that one fix doesn't overwrite the other. mergepatches are typically required when a conflict is detected between Existingpatch and a new patch. oracle Bundle patches: A type of interim patch that contains fixes to manyimportant bugs, though not as defined as a patchset. oracle Critical Patch Update (CPU) patches: A typeof interim patch that contains fixes to critical security bugs delivered on aquarterly basis. patch Set Updates (PSUs): PSUs are proactivecumulative patches containing recommended bug fixes that Are released on aregular and predictable schedule. PSUs are on the same quarterly schedule asthe Critical Patch Updates (CPU), specifically the Tuesday closest to the 15 thof January, yml, July, and October. oracle Patchsets: Software-release mechanic ISMs fordelivering tested and integrated product fixes on a regular basis. some people think that it only exists on windows systems. In fact, this type of patch is also used on UNIX operating systems. There is a reason for this division. on Windows systems, DLL's (Dynamic Linked Libraries) and executable files in the library are different from the library files on other systems, for example, on UNIX, o "the library file at the end of" o ", the working principle of the two is different, when the user performs a patch repair in Windows, the executable file of ORACLE in Oracle HOME will be replaced by the executable file in the patch. The result of this behavior is that old patches will be lost, so some individual bugs cannot be modified on Windows. Instead, many patches form a "Bundle Patch" together ". All bundlepatches on Windows are accumulated, which means that the previous security warning fixes and Bundle Patches will be included. All Patch information for ORACLEDatabase (11.2.0.3.0) will be found in 11.2.0.3 Patch Set-Availability and Known Issues [ID1348336.1. In document ID 161549.1, Patch 16803774 is found as the latest Bundle Patch. II. General steps as the patch is only made on WINDOWS X64 on a single machine, the steps below are as follows: 1. Make sure that the executable PATH of perl is set PATH = % ORACLE_HOME % \ perl \ bin; % PATH % 2. Close the database, make sure that all oracle processes are disabled. 3. SET the ORACLE_HOME environment variable SET ORACLE_HOME = <Oracle Home Path> 4. Go to the download PATH> cd 16803775 5. Make sure that the OPatch execution script is in your Path settings, run the patch application:> opatch apply 6. If an error occurs, check the patch log information under % ORACLE_HOME % \ export toollogs \ opatch. 7. Check the Patch application. Do not forget to pay attention to the Known Issues attached with the Patch. Iii. operation recording C: \ Users \ Administrator> d: D: \> set PATH = % path %; D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ perl \ bin D :\> set PATH = % path %; D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ OPatch D :\> opatch lsinv The Oracle Home D: \ is not OUI basedhome. please give proper Oracle Home. OPatch returns with error code = 1 OPatch succeeded. d: \> set ORACLE_HOME = D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ -- the execution fails. The settings are correct. After ORALCE_HOME: D: \> opatch lsinv Invoking OPatch 11.2.0.1.7 Oracle Intermediate Patch installer version 11.2.0.1.7 Copyright All Rights Reserved (c) 2011, Oracle Corporation. All rights reserved. Oracle Home: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 Central Inventory: C: \ ProgramFiles \ Oracle \ Inventory from: n/a OPatch version: 11.2.0.1.7 OUI version: 11.2.0.3.0 Log file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ export toollogs \ opa tch \ opatch2013-07-17_09-48-20 morning. log Lsinventory Output file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ export toollogs \ opatch \ lsinv \ lsin Ventory2013-07-17_09-48-20at noon. txt has installed the top-level products (1): Oracle Database 11g 11.2.0.3.0 this Oracle Home Directory has installed 1 product. No intermediate patches are installed in this Oracle home directory. OPatch succeeded. -- we can see that the OPatch initialized in 11.2.0.3 is 11.2.0.1.7. The OPatch utility release 11.2.0.1.9 or later. Download The 6880880 OPatch tool. OPatch-related operations can be performed in http://blog.csdn.net/jyjxs/article/details/8983880 Find -- you can see that there is no application Patch in the directory, go to the download Directory D: \> cd D: \ p16803775_112030_MSWIN-x86-64 \ 16803775 D: \ p16803775_112030_MSWIN-x86-64 \ 16803775> opatch apply Oracle Intermediate Patch installer version 11.2.0.3.4 Copyright All Rights Reserved (c) 2012, Oracle Corporation. All rights reserved. Oracle Home: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 Central Inventory: C: \ ProgramFiles \ Oracle \ Inventory from: n/a OPatch version: 11.2.0.3.4 OUI version: 11.2.0.3.0 Log file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ Runtime toollogs \ opa tch \ Runtime \ apply2013-07-17_11-15-45 morning _ 1.log Applying interim patch '000000' to OH 'd: \ app \ Administrator \ product \ 11.2.0 \ db H ome_1 'verifying environment and checking mingprerequisite checks... patch 16803775: Optional component (s) missing: [oracle. precomp. lang, 11.2.0.3. 0], [oracle. rdbms. tg4msql, 11.2.0.3.0], [oracle. rdbms. ic, 11.2.0.3.0], [oracle. has. cvu, 11.2.0.3.0], [oracle. has. crs, 11.2.0.3.0], [oracle. usm, 1 1.2.0.3.0], [oracle. rdbms. tg4db2, 11.2.0.3.0], [oracle. rdbms. tg4ifmx, 11.2. 0.3.0], [Oracle. rdbms. tg4sybs, 11.2.0.3.0], [oracle. rdbms. tg48.0, 11.2.0. 3.0], [oracle. rdbms. schedsed, 11.2.0.3.0] All checks passed. provides an email address to receive notifications about security issues, install Oracle Configuration Manager, and start it. If you use My Oracle Support email address/user name, the operation is simpler. For more information, see http://www.oracle.com/support/policies.html . Email Address/User name: No email address is provided to receive notifications about security issues. Do you want to receive a notification about security issues (Yes [Y], no [N]) [N]: Y. Disable the Oracle instance running outside of ORACLE_HOME on the local system. (Oracle main directory = 'd: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 ') are patches prepared for the local system? [Y | n] Y User Responded with: Y Backing up files... oracle. rdbms, 11.2.0.3.0 patching... oracle. rdbms. rsf, 11.2.0.3.0 patch... oracle. rdbms. plsql, 11.2.0.3.0 patch... oracle. network. rsf, 11.2.0.3.0 patch... oracle. precomp. common, 11.2.0.3.0 patching... oracle. rdbms. rman, 11.2.0.3.0 patch... oracle. rdbms. util, 11.2.0.3.0 patch... oracle. ntoledb. patch odp_net_2, 11.2.0.3.0 ... Oracle. rdbms. dbscripts, 11.2.0.3.0 patch... oracle. xdk. rsf, 11.2.0.3.0 patch... oracle. rdbms. rsf. ic, 11.2.0.3.0 patch... oracle. rdbms. oci, 11.2.0.3.0 patching... oracle. ntoramts, 11.2.0.3.0 patch... oracle. ntoledb, 11.2.0.3.0 patch... oracle. ctx, 11.2.0.3.0 patch... oracle. odbc. ic, 11.2.0.3.0 patch... oracle. has. common. cvu, 11.2.0.3.0 patching... oracle. xdk, 1 1.2.0.3.0 patch... verifying the update... patch 16803775 successfully applied Log file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ Alibaba toollogs \ opat ch \ Alibaba \ apply2013-07-17_11-15-45 morning _ 1.log OPatch succeeded. -- check the updated database patch status. We can see that it is 11.2.0.3.4, indicating that patch bundle 22 belongs to the range of 11.2.0.3.4. D: \ p16803775_112030_MSWIN-x86-64 \ 16803775> opatch lsinv Oracle Intermediate Patch installer version 11.2.0.3.4 All Rights Reserved (C) 2012, Oracle Corporation. All rights reserved. Oracle Home: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 Central Inventory: C: \ ProgramFiles \ Oracle \ Inventory from: n/a OPatch version: 11.2.0.3.4 OUI version: 11.2.0.3.0 Log file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ export toollogs \ opa tch \ opatch2013-07-17_11-25-57 morning _ 1.log Lsinventory Output file location: D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ export toollogs \ opatch \ lsinv \ ls Inventory2013-07-17_11-25-57at noon. txt has installed the top-level products (1): Oracle Database 11g 11.2.0.3.0 this Oracle main directory has installed one product. Intermediate Patch (1): Patch 16803775: applied on Wed Jul17 11:18:00 CST 2013 Unique Patch ID: 16524503 Patch description: "ORACLE 11G 11.2.0.3 PATCH 22 bug forwindows (64-BIT AMD64 and intel EM64)" Created on 01 Jul 2013, 00:06:51 hrs PST8PDT Bugs fixed: 16803775,166 94777, 14467061,165 30565, 14571027,145 12189, 14053457 13857111,138 55490, 13814739,137 24193, 13493847,129 25089, 12912137 12755116,123 95918, 7509451,129 40637, 16747736,143 02813, 14273397 03112, 14459552,167 14985, 16306019,160 61750, 15905421,135 13791364 0853, 13015379,669 74324, 16382448,137 79211, 16555186 16436434,160 77216, 15978267,159 34834, 15920201,159 11134, 15856610 14639385,13936066, 13912274,159 98768, 13899736,140 000095, 16803769 13639436,141 53464, 11866181,165 71785, 16777700,102 55235, 16092378 16594543,126 21588, 16221484,163 56444, 13492916,137 74313, 13651346 12977562,137 94550, 13569591,146 53968, 14393728,146 92460, 15947884 13499412,158 66631, 15867962,117 69185, 16519867,161 95231, 14123213 13625770,138 80758, 15889476,135 83663, 16774393,129 57306, 16223585 12621554,123 25243, 16002686,135 55551, 13789869,135 29386, 13599731 13446912,165 90638, 16245251,125 96686, 16198581,147 81609, 16694441 14000767,165 96183, 16339328,162 20192, 9864697,164 65101, 16578706 16656151,143 83007, 10131881,141 46298, 14222403,141 82835, 16458105 14107333,160 61956, 14657740,134 54409, 13809288,135 96581, 13850256 12951696,160 16455998,907, 16212012,163 3910, 16009158 01888, 14489591,133 15857552,142 76140, 14781524,162 23541, 16178854 35055, 14355991,127 14309223,141 31763, 16219072,163 58012, 16368108 45834, 16382353,102 11715084,130 42202, 13496884,136 98318, 80405, 13812031 13914613,144 listen 47, 16175381,162 listen 99, 16299830,158 80538, 16368002 16268983,127 70551, 16100861,158 83525, 16270093,142 40074, 13931044 9185970,143 40896, 15936160,160 32010, 16206122,159 67792, 16026049 15956068,158 73502, 14589685,138 34436, 16059292,134 81404, 14630325 16042670,130 running 20, 16272008,141 47762, 12974860,127 80510, 12824731 13924311,147 running 52, 13559697,142 20725, 14841812,148 running 58, 13596521 running 47, 13561951,138 68365, 13943175,142 04789, 14535011,127 running 55, 12870400 running 17, 13011182,132 55385, 14048512 13791443,128 79027, 13584130,134 95307, 12594032,137 09220, 13247965 13243072,136 83125, 13652493,129 57127, 10215977,130 14128, 13040331 12857222,129 77501, 12664456,124 05931, 13525554,134 92863, 13573521 13873471,133 66268, 13352423,134 60353, 12709476,136 52088, 13886023 13942723,129 19564, 12894807,128 29021, 12612118,110 63191, 13503598 13482688,133 54082, 13484963,133 95403, 13542159,129 83611, 13718476 12846562,965 9614, 13326736,118 46902, 11665727,132 57247, 13588248 13544396,135 66938, 13615517,134 25727, 13037709,127 30342, 12349553 13502441,132 58062, 13251796,132 47273, 12659561,126 39013, 12594616 11772838,135 70057, 12403721,125 85543, 12784549,128 34800, 12975771 13040171,130 58950, 13063120,130 77335, 13365700,133 82280, 13384397 13440516,134 54210, 13457537,134 77790, 13496250,135 01787, 13505390 13506110,135 24899, 13572659,135 94712, 13617627,133 26289, 13555974 20133, 13035360,134 36331, 13419660,130 20174, 13332439,134 12583826 83969, 13358781,118 67713, 13524237,128 16727, 13328193,135 11865420 59364, 13502183,132 98795, 13371153,129 97902, 13044108 12971242,128 34027, 12620823,134 20516, 12849377,129 75811, 12646784 12829429,125 38907, 12950823,128 48133, 12823838,133 66202, 13002015 01901, 12834777,130 82238, 13017428,130 40910, 12965049,118 12656535 73340, 12617123,130 38841, 12925041,129 66371, 12942119 11877623,128 1000090, 12995950,127 65467, 12934171,130 70939, 12535346 12985184,131 03913, 12765868,126 22441, 12876314,128 20045, 13038806 13090686,129 23168, 13362079,125 91252, 12718090,128 73909, 10350832 39908, 12795861,130 17584, 12976590,130 63435, 12847466 12797765,127 58736, 12878750,128 61463, 13024624,127 64337, 12662040 13068077,129 14824, 13074261,126 68341, 12597906,129 32852, 13045518 12897651,129 60925, 12728585,130 19958, 12902661,128 86827, 12913474 3522216,126 78920, 12885323,133 34158, 12947871,128 96850, 13001955 12784559,128 27166, 9703627,127 72345, 12905058,133 45868, 10357727 12827493,130 04894, 12780983,128 42804, 13146719,126 55301, 12960302 13085732,129 79199, 12638117,133 57509, 12401111,128 57064, 8631856 13035804,133 55963, 12845115,126 95029, 12990582,129 71775, 12867511 12917230,125 82664, 12849688,129 50644, 12588744,130 11520, 12899169,12823 042 -------------------------------------------------------------------------------- OPatch succeeded. d: \ p16803775_112030_MSWIN-x86-64 \ 16803775> opatchls patches 16803775; ORACLE 11G 11.2.0.3 PATCH 22 bug for windows (64-BIT AMD64 and intel em 64)