Oracle 12c RAC Database 29141015 Patch Apply

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.

 

[oracle@MehmetSalih ~]$ unzip p29141015_121020_Linux-x86-64.zip
[oracle@MehmetSalih ~]$ cd 29141015
[oracle@MehmetSalih 29141015]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

 

Apply 29141015 patch like following.








[oracle@MehmetSalih ~]$
[oracle@MehmetSalih ~]$ cd /u01/app/oracle/patch/29141015/
[oracle@MehmetSalih 29141015]$
[oracle@MehmetSalih 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.
[oracle@MehmetSalih 29141015]$

 

 

 

Perform following steps after patch installation. These are Patch Post-Installation Instructions.

[oracle@MehmetSalih ~]$
[oracle@MehmetSalih ~]$ 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
[oracle@MehmetSalih ~]$
[oracle@MehmetSalih ~]$

[oracle@MehmetSalih ~]$ cd $ORACLE_HOME/OPatch
[oracle@MehmetSalih OPatch]$
[oracle@MehmetSalih 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
[oracle@MehmetSalih OPatch]$

 

To check list of patch with opatch lsinventory like following.








[oracle@MehmetSalih 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.
[oracle@MehmetSalih OPatch]$

 


Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.