IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
I will explain how to patch Oracle 12c RAC database in this post.
I will explain Patch 29141015 – Database Patch Set Update 12.1.0.2.190416 which is released 16-Apr-2019 for Oracle database 12.1.0.2.
You must use the OPatch utility version 12.2.0.1.14 or later to apply Patch 29141015.
Unzip patch file and check prerequirement like following.
[[email protected] ~]$ unzip p29141015_121020_Linux-x86-64.zip [[email protected] ~]$ cd 29141015 [[email protected] 29141015]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Apply 29141015 patch like following.
[[email protected] ~]$ [[email protected] ~]$ cd /u01/app/oracle/patch/29141015/ [[email protected] 29141015]$ [[email protected] 29141015]$ /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.0.2/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2019-05-02_17-56-15PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 24006101 24732082 25171037 25755742 26609783 26713565 26925311 27338041 27547329 28259833 28729169 29141015 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/12.1.0.2/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.sqlplus, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.network.listener, 12.1.0.2.0... Patching component oracle.network.rsf, 12.1.0.2.0... Patching component oracle.rdbms.dv, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.sqlplus.ic, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.rdbms.install.plugins, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Applying sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.sqlplus.ic, 12.1.0.2.0... Patching component oracle.sqlplus, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.ordim.client, 12.1.0.2.0... Patching component oracle.ordim.client, 12.1.0.2.0... Patching component oracle.ordim.jai, 12.1.0.2.0... Patching component oracle.ordim.server, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms.install.plugins, 12.1.0.2.0... Patching component oracle.javavm.containers, 12.1.0.2.0... Applying sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.rsf, 12.1.0.2.0... Patching component oracle.ldap.rsf, 12.1.0.2.0... Patching component oracle.ldap.client, 12.1.0.2.0... Patching component oracle.oracore.rsf, 12.1.0.2.0... Patching component oracle.rdbms.deconfig, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.network.listener, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Applying sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.oracore.rsf, 12.1.0.2.0... Applying sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.ldap.client, 12.1.0.2.0... Patching component oracle.rdbms.crs, 12.1.0.2.0... Patching component oracle.rdbms.deconfig, 12.1.0.2.0... Patching component oracle.xdk, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.xdk.parser.java, 12.1.0.2.0... Patching component oracle.xdk.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Applying sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.network.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Applying sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.rsf, 12.1.0.2.0... Patching component oracle.assistants.server, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.sqlplus.rsf, 12.1.0.2.0... Applying sub-patch '27547329' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.network.rsf, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.ldap.rsf, 12.1.0.2.0... Patching component oracle.ctx.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.oracore.rsf, 12.1.0.2.0... Patching component oracle.ctx, 12.1.0.2.0... Patching component oracle.nlsrtl.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Applying sub-patch '28259833' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.oracore.rsf, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms.crs, 12.1.0.2.0... Applying sub-patch '28729169' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' Patching component oracle.ldap.rsf, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Applying sub-patch '29141015' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1' ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.ldap.rsf, 12.1.0.2.0... Patching component oracle.rdbms.deconfig, 12.1.0.2.0... Patching component oracle.rdbms.rsf, 12.1.0.2.0... Patching component oracle.rdbms.crs, 12.1.0.2.0... Patching component oracle.rdbms, 12.1.0.2.0... Patching component oracle.rdbms.dbscripts, 12.1.0.2.0... Patching component oracle.rdbms.rman, 12.1.0.2.0... Patching component oracle.tfa, 12.1.0.2.0... Composite patch 29141015 successfully applied. Log file location: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2019-05-02_17-56-15PM_1.log OPatch succeeded. [[email protected] 29141015]$
Perform following steps after patch installation. These are Patch Post-Installation Instructions.
[[email protected] ~]$ [[email protected] ~]$ sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 Production on Thu May 2 18:27:19 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. SQL> Connect / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 1.7180E+10 bytes Fixed Size 3731384 bytes Variable Size 3489661000 bytes Database Buffers 1.3623E+10 bytes Redo Buffers 63377408 bytes Database mounted. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options [[email protected] ~]$ [[email protected] ~]$ [[email protected] ~]$ cd $ORACLE_HOME/OPatch [[email protected] OPatch]$ [[email protected] OPatch]$ ./datapatch -verbose SQL Patching tool version 12.1.0.2.0 Production on Thu May 2 18:28:38 2019 Copyright (c) 2012, 2016, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_33163_2019_05_02_18_28_38/sqlpatch_invocation.log Connecting to database...OK [[email protected] OPatch]$
To check list of patch with opatch lsinventory like following.
[[email protected] OPatch]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.0.2/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2019-05-02_17-03-42PM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-05-02_17-03-42PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: MehmetSalih.deveci.local ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 29141015 : applied on Thu May 02 16:51:21 EAT 2019 Unique Patch ID: 22785785 Patch description: "Database Patch Set Update : 12.1.0.2.190416 (29141015)" Created on 7 Mar 2019, 05:42:36 hrs PST8PDT Sub-patch 28729169; "Database Patch Set Update : 12.1.0.2.190115 (28729169)" Sub-patch 28259833; "Database Patch Set Update : 12.1.0.2.181016 (28259833)" Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)" Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)" Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)" Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)" Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)" Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)" Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)" Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)" Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)" Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)" Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)" Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)" Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)" Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)" Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)" Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)" Bugs fixed: 19309466, 19902195, 18250893, 25437699, 19383839, 19781326, 16756406 18456643, 26546664, 22364044, 18845653, 19915271, 20172151, 18417036 19516448, 23713236, 24796092, 23140259, 19243521, 19658708, 18272672 21153266, 19174430, 22243719, 26556014, 20493163, 20688221, 21387964 13542050, 22734547, 22243983, 21623164, 19012119, 19932634, 19869255 22232606, 18681056, 23324000, 25427662, 22068305, 24589081, 19439759 19303936, 22916353, 24835538, 22353346, 21106027, 19790243, 26444887 23088803, 22529728, 26256131, 19134173, 20447445, 21188584, 19390567 26513709, 25780343, 19769480, 21097043, 21225209, 26245237, 20677396 19284031, 19450314, 19016730, 20919320, 22517782, 22075064, 22551446 22721409, 18440095, 22496904, 16439813, 18354830, 20596234, 22022760 20936905, 23197103, 21514877, 21186167, 26111842, 18990023, 13787015 22492533, 20173897, 24624166, 17210525, 21260431, 20181030, 25056052 19370504, 21868720, 23068169, 19124589, 21383171, 19402853, 19888853 24341675, 17722075, 20882568, 25653109, 23026585, 18604692, 20717081 25546608, 27370965, 19081128, 22173980, 23514710, 25722055, 19178851 20951038, 22168163, 25161298, 20569094, 24308635, 19791377, 19050649 20920911, 22475617, 19189525, 19469538, 27052607, 20598042, 22458049 18988834, 23302839, 25307368, 17409174, 22729345, 22842151, 19238590 16941434, 20387265, 24397438, 20673810, 23108128, 20356733, 22380919 18436647, 23065323, 20825533, 19124336, 22294260, 24790914, 20284155 23571055, 25539063, 17365043, 25914276, 20952966, 22961508, 19176223 21300341, 23237313, 18288842, 27223075, 22353199, 20011515, 22083366 25670786, 27634991, 21419850, 26898563, 19577410, 27986817, 26248143 23294548, 24737064, 23101501, 19931709, 25423453, 25547060, 23533807 27726780, 24600330, 25600421, 18122373, 20043616, 23124895, 18856999 21450666, 18893947, 26633558, 20076781, 26029780, 21196809, 21354456 23725036, 20464614, 22533631, 19562381, 27375542, 24808595, 19189317 25669791, 18307021, 21917884, 19708632, 27213224, 25633101, 20711718 29006527, 18973548, 25982666, 19718981, 23567857, 22826718, 25655390 21773465, 20250147, 20144019, 19197175, 26263721, 19597439, 21387128 22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823 20322560, 22228324, 23172924, 22520320, 21575362, 27751755, 25058080 22365117, 22645009, 25165496, 28950969, 18774543, 20124446, 21429602 26153977, 19371175, 21863727, 18940497, 19074147, 22923409, 25489342 21380789, 19154375, 19044962, 19532017, 19662635, 22374754, 20560611 25654936, 21492036, 18705806, 28420042, 19578247, 22024071, 22238921 22809871, 21184223, 19995869, 23089357, 19404068, 18921743, 19065677 19018447, 19018206, 18308268, 19777862, 22223463, 19304354, 29027694 22519146, 27199245, 19445860, 26654363, 22977256, 20890311, 27445727 21142837, 20869721, 24555417, 22179537, 21756699, 20217801, 18819908 22760595, 25483815, 23628685, 23007241, 19593445, 21080143, 27351628 20582405, 20031873, 25489367, 18618122, 24737581, 26784509, 24739928 18966843, 19077215, 20704450, 19068970, 20543011, 19023822, 24713381 20432873, 21756677, 20328248, 18674047, 18849537, 20087383, 25459958 20315311, 22897344, 27534509, 25178179, 19308965, 18948177, 19468991 20868862, 21780146, 23315153, 20466628, 21756661, 20397490, 19706965 20302006, 24831514, 23240358, 22178855, 19032777, 20862087, 19329654 18974476, 20603378, 20859910, 19307662, 21847223, 20281121, 22568797 19075256, 19076343, 18866977, 22808310, 25635149, 20844426, 20904530 20441797, 21442094, 25079710, 24674955, 18840932, 18740837, 20294666 25602488, 21517440, 22062517, 27337759, 19174942, 19180394, 20671094 21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979 25616268, 21625179, 20879709, 23003979, 20165574, 28578164, 19272708 19547370, 22624709, 23084507, 23184263, 20228093, 21281532, 25093872 19805359, 19461270, 26324206, 19434529, 18799063, 20378086, 17008068 21246723, 20831538, 20424899, 20361671, 18674024, 19689979, 24411921 19873610, 16619249, 20562898, 21641414, 21091431, 19440586, 22757364 20001168, 22175564, 20725343, 21241052, 19561643, 20736227, 19399918 19195895, 20830459, 20017509, 18475439, 25790353, 21828126, 21665897 25555252, 20746251, 22568177, 25764020, 25612095, 25357142, 23096938 19067244, 18043064, 21329301, 18885870, 26243698, 26187943, 20324049 19536415, 23709062, 28174827, 20446883, 27314206, 21299490, 25313154 18628388, 21744290, 18254023, 25047724, 20591183, 27847259, 19185876 27207110, 22465352, 24385625, 24326444, 20402832, 19627012, 20468401 27441326, 27620950, 16863642, 19639483, 19315691, 27567477, 21479753 19174521, 20401975, 18306996, 18851894, 27034890, 20581111, 20318889 20936731, 21060755, 25240188, 26828994, 22256560, 19188927, 27229389 20766180, 20229001, 24570598, 25475853, 21172913, 17655240, 21266085 19028800, 19035573, 19366375, 24523374, 25599425, 25034396, 19289642 21502702, 21291274, 18007682, 23521523, 20475845, 22148226, 22528741 29408136, 25417958, 24652769, 26088426, 19326908, 19597583, 17414008 23019710, 20897759, 26822620, 22046677, 19663176, 20938170, 19891090 24825843, 26318627, 21960504, 24509056, 19054077, 26262953, 22657942 20428621, 21899588, 23326313, 19723336, 19835133, 17532734, 19333670 25300427, 21842017, 19285025, 21373473, 23260854, 23061453, 19687159 14643995, 20977794, 20734332, 17551063, 27548131, 21977392, 24461826 19676012, 20588502, 23315889, 19520602, 23053606, 19841800, 20245930 19001359, 21476308, 26546754, 19393542, 23533524, 21099555, 27995248 25429959, 19141838, 19644859, 21915719, 19908836, 21421886, 19358317 19524158, 23548817, 25861398, 20803014, 23025340, 19335438, 19058490 23642282, 19207117, 18799993, 25919622, 26569225, 20835241, 25986062 24662775, 19475971, 18967382, 20347562, 20348653, 19896336, 24812585 20048359, 21896069, 20468490, 19524384, 25392535, 21147908, 20440930 25789277, 19171086, 24718260, 17867700, 19791273, 27397048, 21241829 19591608, 22707244, 18419520, 22296366, 22654475, 18914624, 19571367 28636676, 21522582, 19501299, 19529868, 20425790, 26007010, 19708342 27997875, 16870214, 18202441, 24415926, 18743542, 19001390, 21157728 19332396, 21875360, 25091141, 28000269, 19149990, 20382309, 22855193 16777441, 19606174, 20848335, 25495682, 19382851, 20528052, 22762046 24563422, 23125826, 22503297, 28993590, 25192729, 23338911, 22730454 19176326, 20298413, 19048007, 18849970, 21532755, 20860659, 22905130 26121990, 21263635, 22160989, 18499088, 22894949, 21059919, 18952989 22518784, 27348081, 25856821, 24457597, 25484507, 20794034, 21061354 19468347, 17533661, 19883092, 20657441, 24401351, 21285458, 18051556 25330273, 28023399, 26412540, 19699191, 24437510, 20669434, 16875041 18964978, 22972770, 20828947, 21373076, 25492379, 25551676, 14283239 25766822, 21967197, 22922076, 25575628, 26110259, 20368850, 21239530 20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343 22695831, 24365589, 25634317, 19587324, 20134113, 20273319, 18542562 26758193, 19017309, 21063322, 22062026, 20134339, 22077517, 22815955 23854396, 24690216, 22507210, 16354467, 20101006, 21795111, 27938623 23501901, 18797519, 25879984, 21260397, 25029423, 19354335, 19730508 22366558, 26658759, 25822410, 6599380, 20717359, 24321547, 27097854 21297872, 18964939, 26366517, 21913183, 22366322, 20171986, 20603431 21132297, 25957038, 21542577, 22507234, 23170620, 24719736, 25600342 18868646, 26637824, 20627866, 28587723, 29142109, 18110491, 16923858 24642295, 19518079, 20466322, 19339555, 25823754, 25110233, 24908321 20842388, 17274537, 26575788, 20474192, 21644640, 28849751, 21794615 18899974, 20471920, 22806698, 19052488, 19503821, 24350620, 20074391 19157754, 21220620, 24316947, 19865345, 19065556, 22816287, 25947799 20878790, 23492665, 21322887, 22305887, 20879889, 24350831, 19578350 28022101, 26439748, 21893235, 19363645, 21072646, 20898391, 19291380 27060167, 27086138, 18382302, 22536802, 22087683, 21197626, 21656630 20373598, 19248799, 22707866, 19155797, 19279273, 28432129, 18886413 25490238, 20922010, 19990037, 25150925, 20509482, 27255377, 24717859 20703000, 22862134, 21526048, 28683167, 24929210, 24560906, 20144308 21620471, 19670108, 19068610, 20267166, 25123585, 20476175, 18549238 22950945, 19385656, 23528412, 19684504, 21174504, 20899461, 20557786 21911701, 19143550, 20118035, 19024808, 25760195, 20009833, 19604659 16359751, 26039623, 19928926, 23314180, 20212067, 24737403, 20480209 18904062, 26430737, 29030780, 20856766, 27169796, 21668627, 17258582 20877664, 19487147, 23149541, 24577566, 19430401, 19676905, 20925795 21296029, 21629064, 23229229, 22865673, 20708701, 25353983, 19280225 21315084, 20613079, 19375649, 19213447, 19989009, 18191823, 27314390 26336977, 25775213, 24393981, 25639019, 17319928, 14705949, 19703301 21626377, 20122715, 6418158, 23105538, 26198926, 19258504, 21188532 23151677, 17890099, 21649497, 26446098, 16887946, 26024732, 18791688 19721304, 27012701, 19490948, 19619732, 21164318, 23148260, 18090142 21641760, 19818513, 23002524, 20139391, 24693382, 19978542, 23543183 22165897, 22359063, 19373893, 19409212, 18373438, 23035249, 18990693 20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18742258 18604493, 23008056, 22901797, 18610915, 20978259, 20832516, 24801152 26089440, 20907061, 19523462, 20505778, 19183343, 21787056, 21273804 22782647, 25093739, 17835294, 28708023, 24413809, 18371441, 26714910 24385983, 20413820, 24421668, 25897615, 25643931, 23195445, 21281607 20513399, 20558005, 20093776, 18909599, 20618595, 23572982, 19211433 20331945, 19512341, 22256431, 19637186, 19022470, 18607546, 26875822 24573817, 23115139, 19649152, 19201867, 21294938, 20898997, 18510194 21842740, 22454326, 24683149, 19534363, 25489607 Patch 24701840 : applied on Fri Nov 04 16:52:22 EAT 2016 Unique Patch ID: 20618150 Created on 26 Sep 2016, 01:47:17 hrs PST8PDT Bugs fixed: 24701840 Patch 23054327 : applied on Fri Aug 05 18:30:07 EAT 2016 Unique Patch ID: 20208671 Patch description: "OCW Patch Set Update : 12.1.0.2.160719 (23054327)" Created on 16 Jul 2016, 06:57:02 hrs PST8PDT Bugs fixed: 21339083, 19701617, 18589889, 20768643, 19139608, 19280860, 19061429 21453435, 19133945, 19341538, 19521169, 20011424, 18946768, 19135521 18604143, 19361757, 19187207, 19302350, 19627476, 19130141, 19530755 20568884, 20317221, 19699720, 20177779, 19620918, 19168690, 19266658 18899171, 19244316, 19653795, 18330979, 19027351, 18634372, 19471722 21227730, 18707416, 19536337, 19184188, 19131709, 21113068, 20235486 19925992, 20160490, 20006646, 20995001, 18991776, 18439295, 15922206 21131037, 19380733, 21245437, 18943696, 20552947, 19591984, 19550195 19163425, 18135723, 20014326, 19524857, 18849021, 18890943, 18861196 19154753, 17940721, 18524834, 18748932, 18835283, 19522313, 19184765 19499021, 21639478, 19046190, 20923930, 14851828, 20028666, 19051385 19050688, 19682695, 19831611, 20598625, 19226141, 21607972, 19053891 18871287, 18998228, 18922918, 18980002, 21087799, 18956780, 19683886 19325604, 19682778, 23757020, 19026993, 18777835, 20110156, 17338864 21269977, 18261648, 18362971, 19558324, 22651583, 18945906, 19513650 20185476, 18952577, 19702758, 18882642, 19478119, 19414274, 17447588 19262534, 20752167, 19147513, 21242118, 19514085, 19473088, 20758997 19178517, 18729269, 19529729, 19659885, 19455563, 19319904, 20877072 18703978, 18536826, 20340620, 19700256, 19703246, 19292605, 20467806 22264951, 19192901, 21527118, 20920711, 20660273, 20011635, 17592037 22989069, 19479503, 19147751, 19029647, 19179158, 22302421, 18901356 19140712, 20012766, 21232394, 18964974, 22162062, 18835366, 19184276 19013789, 19207286, 20001507, 20510208, 18950232, 22583325, 19259765 19148791, 19680763, 20079414, 19556820, 16505171, 22135419, 19449737 18962892, 21646169, 19187515, 19513888, 19230771, 14661880, 21519340 20218012, 21222147, 20795241, 19453778, 19853036, 19551830, 19068333 21616278, 18843572, 18520351, 18945435, 19185148, 19232454, 20775015 21220597, 18541110, 19319192, 18834955, 19204743, 19178629, 20839581 19304104, 21694237, 19140891, 18747335, 19284357, 20676340, 19270660 19457575, 20725084, 21297657, 19021575, 19069755, 18715884, 18798573 19584688, 19018001, 19812592, 19325701, 19270956, 19292272, 21967791 20877003, 21794779, 18700893, 19222693, 19662663, 21276514, 18406774 19684131, 20607821, 19010177, 21082737, 19272663, 18910576, 18907170 21694632, 19426384, 9372680, 20115586, 20883009, 19700294, 19164099 20289828, 19331454, 18283792, 20278216, 20827053, 19155350, 20119857 19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346 18798432, 19146822, 19589221, 21123424, 18952857, 19471836, 19537762 20936562, 21152052, 16286734, 18750781, 20669114, 18762843, 18945249 19045143, 19146980, 22483804, 19184799, 19205086, 19601003, 20099624 19351363, 21378016, 20091753, 18862203, 19281106, 19537547, 19031737 19079087, 19148367, 18968981, 19150517, 20231741, 19954372, 19217019 18730096, 18235274, 18975620, 19205617, 19513351, 18843054, 19150313 20219458, 18708349, 19332386, 18953639, 19067804, 21423055, 21259359 19371270, 19203996, 19054979, 19209951, 19318983, 18747382, 20038431 19154673, 18752378, 22905714, 19150088, 19370846, 19013444, 19234177 21053036, 18998379, 20157569, 21357522, 18999857, 19273577, 19075747 19367276, 19632437, 18990354, 19288396, 19874047, 19612597, 19557558 20620581, 19427050, 19127078, 18910443, 20900588, 22088198, 20053557 20033787, 19315567, 19444471, 19148982, 20953798, 18290252, 18813323 19915945, 19777496, 19500293, 20730170, 18643483, 19277814, 19134098 18523468, 20562133, 19071526, 21420753, 18965694, 19226858, 18850051 20433932, 19602208, 19591356, 22884308, 20061168, 18417590, 19370739 18920408, 20822591, 18636884, 19609388, 20136892, 18776786, 18989446 22289350, 19148793, 19043795, 19585454, 20746507, 18260170, 18317489 19955755, 18919682, 19059053, 19807548, 19124972, 18678829, 19147509 18849896, 19617592, 18910748, 18953878, 19273758, 19319357, 19076165 18999195, 19498411, 19704993, 18759724, 21294273, 19459023, 20634511 21474380, 19066844, 21484367, 20276459, 17208793, 19234907, 20290467 13843841, 19538714, 19649640, 19383028, 19062675, 21924910, 19513969 22195657, 18859710, 20862812, 19504641, 19341481, 18304090, 20293730 19986391, 19343245, 19314048, 18834934, 19473851, 19241655, 19458082 18242738, 19470791, 18894342, 20649573, 18372060, 19522067, 18953889 18827679, 19259290, 19023430, 19140711, 19045388, 20186278, 19241857 19522571, 19076778, 18875012, 19709663, 18861564, 19066699, 19273760 19225265, 15885689, 20853464, 18819158, 21696068, 19068003, 18937186 20267877, 19049721, 21394146, 19916737, 19368917, 22393909, 21255373 19635215, 18868829, 19613533, 20579351, 20408163, 20350915, 21327402 21057239, 22024217, 20783416, 19315522, 19141785, 23101338, 19163887 19885321, 19820247, 18715868, 18852058, 20363708, 19538241, 19804032 -------------------------------------------------------------------------------- OPatch succeeded. [[email protected] OPatch]$
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
2,031 views last month, 1 views today
