패치 환경 설정

export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=$ORACLE_BASE/11.2.0/grid
export DB_HOME=$ORACLE_BASE/product/11.2.0/db_1
chmod 770 $GRID_HOME
[root@oel5 ~]# export ORACLE_BASE=/u01/app/oracle
[root@oel5 ~]# export GRID_HOME=$ORACLE_BASE/11.2.0/grid
[root@oel5 ~]# export DB_HOME=$ORACLE_BASE/product/11.2.0/db_1
[root@oel5 ~]# chmod 770 $GRID_HOME

패치 작업은 root 유저로 진행됩니다.

수월한 작업을 위해 환경 변수를 먼저 설정합니다.

Grid 패치

OPatch 업데이트

cd $GRID_HOME
OPatch/opatch version
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R grid:oinstall OPatch
ll | grep OPatch
OPatch/opatch version
[root@oel5 ~]# cd $GRID_HOME
 
[root@oel5 grid]# OPatch/opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
 
[root@oel5 grid]# mv OPatch OPatch.old
 
[root@oel5 grid]# cp -r /media/sf_oracle/OPatch .
 
[root@oel5 grid]# chown -R grid:oinstall OPatch
 
[root@oel5 grid]# ll | grep OPatch
drwxr-x--- 15 grid oinstall  4096  5월  6 20:40 OPatch
drwxr-xr-x  8 grid oinstall  4096  5월  6 17:25 OPatch.old
[root@oel5 grid]# OPatch/opatch version
OPatch Version: 11.2.0.3.15

OPatch succeeded.

먼저 OPatch 파일을 최신 버전으로 업데이트 합니다.

GI가 설치된 경로에 있는 파일을 먼저 업데이트 합니다.

패치 현황 조사

opatch lsinventory
[grid@oel5 ~]$ opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/11.2.0/grid/cfgtoollogs/opatch/opatch2017-05-06_20-45-13오후_1.log

Lsinventory Output file location : /u01/app/oracle/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-06_20-45-13오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel5
ARU platform id: 46
ARU platform description:: Linux x86

설치된 최상위 레벨 제품(1): 

Oracle Grid Infrastructure 11g                                       11.2.0.4.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded.

패치 현황을 조사합니다.

기본적인 소프트웨어 설치만 진행한 상태라면 아무것도 패치되지 않은 것으로 나옵니다.

Response File 생성

cd $GRID_HOME/OPatch/ocm/bin
./emocmrsp
[grid@oel5 ~]$ cd $GRID_HOME/OPatch/ocm/bin
 
[grid@oel5 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates.  All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
The OCM configuration response file (ocm.rsp) was successfully created.
 
[grid@oel5 bin]$ ls
emocmrsp  ocm.rsp

패치 작업에 필요한 response file을 생성합니다.

패치

export ORACLE_HOME=$GRID_HOME
$GRID_HOME/OPatch/opatch auto /media/sf_oracle/25476126 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@oel5 ~]# export ORACLE_HOME=$GRID_HOME
 
[root@oel5 ~]# $GRID_HOME/OPatch/opatch auto /media/sf_oracle/25476126 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/oracle/11.2.0/grid/perl/bin/perl /u01/app/oracle/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /media/sf_oracle -patchn 25476126 -ocmrf /u01/app/oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/oracle/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/11.2.0/grid/cfgtoollogs/opatchauto2017-05-06_20-52-11.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/11.2.0/grid/cfgtoollogs/opatchauto2017-05-06_20-52-11.report.log

2017-05-06 20:52:11: Starting Oracle Restart Patch Setup
Using configuration parameter file: /u01/app/oracle/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully

patch /media/sf_oracle/25476126/24732075  apply successful for home  /u01/app/oracle/11.2.0/grid 
patch /media/sf_oracle/25476126/23054319  apply successful for home  /u01/app/oracle/11.2.0/grid 
patch /media/sf_oracle/25476126/22502505  apply successful for home  /u01/app/oracle/11.2.0/grid 

Starting CRS...
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

패치 결과

opatch lsinventory
[grid@oel5 ~]$ opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/11.2.0/grid/cfgtoollogs/opatch/opatch2017-05-06_21-09-59오후_1.log

Lsinventory Output file location : /u01/app/oracle/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-06_21-09-59오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel5
ARU platform id: 46
ARU platform description:: Linux x86

설치된 최상위 레벨 제품(1): 

Oracle Grid Infrastructure 11g                                       11.2.0.4.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(3):

Patch  22502505     : applied on Sat May 06 20:59:28 KST 2017
Unique Patch ID:  19945546
Patch description:  "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)"
   Created on 4 Mar 2016, 00:05:12 hrs PST8PDT
   Bugs fixed:
     21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148
     17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796
     18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303
     18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334
     18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946

Patch  23054319     : applied on Sat May 06 20:59:04 KST 2017
Unique Patch ID:  20240506
Patch description:  "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
   Created on 16 Jul 2016, 02:33:14 hrs PST8PDT
   Bugs fixed:
     18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
     20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
     17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
     20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
     17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
     17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
     22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
     18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
     18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
     18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
     20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
     18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
     18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
     20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
     18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
     20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
     17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
     17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
     17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
     17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
     17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
     18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
     18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
     17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
     20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
     17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
     17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
     19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
     21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
     16798862, 15920201

Patch  24732075     : applied on Sat May 06 20:57:24 KST 2017
Unique Patch ID:  21176427
Patch description:  "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
   Created on 20 Feb 2017, 02:20:08 hrs PST8PDT
Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
     13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
     17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
     21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
     17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
     22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
     18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
     17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
     21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
     22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
     17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
     14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
     19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
     24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
     22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
     21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
     18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
     17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
     19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
     16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
     17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
     16228604, 20074391, 19972570, 18996843, 19854503, 16042673, 17835627
     20334344, 18000422, 20861693, 17393683, 17551709, 20506699, 19006849
     18456514, 18277454, 17258090, 17174582, 17242746, 16399083, 17824637
     17762296, 17397545, 16450169, 12364061, 20067212, 18856999, 19211724
     19463893, 21343775, 19463897, 17853456, 18673304, 20004021, 21668627
     16194160, 17477958, 16538760, 12982566, 20296213, 18293054, 17610798
     19699191, 18135678, 17311728, 16785708, 10136473, 24560906, 17786518
     18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
     16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
     18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
     18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615
     17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491
     16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542
     18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068
     17165204, 18508861, 21756699, 16901385, 18554763, 18189036, 17443671
     17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456
     16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917
     16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326
     17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380
     18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537
     17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387
     16392068, 17752995, 21051862, 25505382, 17237521, 16863422, 18244962
     19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
     17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
     21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
     19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
     17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
     22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
     25505394, 17265217, 17071721, 16721594, 21756661, 18262334, 15913355
     17891946, 17672719, 17602269, 17239687, 17042658, 17238511, 17811456
     17284817, 17752121, 17394950, 16579084, 17011832, 22195465, 14602788
     18325460, 24476265, 24476274, 12611721, 16903536, 17006570, 16043574
     18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789
     22195477, 17865671, 19013183, 17343514, 18316692, 17325413, 16180763
     17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081
     24316947, 17705023, 17614227, 22195485, 14084247, 13645875, 16777840
     19727057, 14852021, 18744139, 18674047, 17716305, 18482502, 17622427
     19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 19258504
     17786278, 17082983, 21351877, 13498382, 18331812, 16065166, 18031668
     22893153, 16943711, 21517440, 17649265, 13866822, 18094246, 24528741
     14245531, 17783588, 17082359, 20448824, 18280813, 23330119, 16268425
     17302277, 18018515, 17215560, 24411921, 19271443, 17016369, 20777150
     23330124, 20441797, 19769489, 25093656, 17545847, 18260550, 13853126
     23536835, 17227277, 9756271, 18868646, 17614134, 17546973, 19680952
     18704244, 18828868, 18273830, 17050888, 17360606, 16992075, 17375354
     12905058, 18362222, 17571039, 17468141, 18436647, 17235750, 21168487
     16220077, 16929165



--------------------------------------------------------------------------------

OPatch succeeded.

 

DBMS 패치

OPatch 업데이트

cd $DB_HOME
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R oracle:oinstall OPatch
OPatch/opatch version
[root@oel5 ~]# cd $DB_HOME
 
[root@oel5 db_1]# mv OPatch OPatch.old
 
[root@oel5 db_1]# cp -r /media/sf_oracle/OPatch .
 
[root@oel5 db_1]# chown -R oracle:oinstall OPatch
 
[root@oel5 db_1]# OPatch/opatch version
OPatch Version: 11.2.0.3.15

OPatch succeeded.

 

패치 현황 조사

opatch lsinventory
[oracle@oel5 ~]$ opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-06_20-46-49오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-06_20-46-49오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel5
ARU platform id: 46
ARU platform description:: Linux x86

설치된 최상위 레벨 제품(1): 

Oracle Database 11g                                                  11.2.0.4.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded.

 

Response File 생성

cd $DB_HOME/OPatch/ocm/bin
./emocmrsp
[oracle@oel5 ~]$ cd $DB_HOME/OPatch/ocm/bin
 
[oracle@oel5 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates.  All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
The OCM configuration response file (ocm.rsp) was successfully created.
 
[oracle@oel5 bin]$ ls
emocmrsp  ocm.rsp

 

패치 적용

export ORACLE_HOME=$DB_HOME
$DB_HOME/OPatch/opatch auto /media/sf_oracle/25476126 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@oel5 ~]# export ORACLE_HOME=$DB_HOME
 
[root@oel5 ~]# $DB_HOME/OPatch/opatch auto /media/sf_oracle/25476126 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/oracle/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /media/sf_oracle -patchn 25476126 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/oracle/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2017-05-06_21-04-56.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2017-05-06_21-04-56.report.log

2017-05-06 21:04:56: Starting Oracle Restart Patch Setup
Using configuration parameter file: /u01/app/oracle/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /media/sf_oracle/25476126/24732075  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch /media/sf_oracle/25476126/23054319/custom/server/23054319  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

response file을 사용하여 패치를 진행합니다.

패치 결과

opatch lsinventory
[oracle@oel5 ~]$ opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-06_21-10-26오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-06_21-10-26오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel5
ARU platform id: 46
ARU platform description:: Linux x86

설치된 최상위 레벨 제품(1): 

Oracle Database 11g                                                  11.2.0.4.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(2):

Patch  23054319     : applied on Sat May 06 21:08:42 KST 2017
Unique Patch ID:  20240506
Patch description:  "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
   Created on 16 Jul 2016, 02:33:05 hrs PST8PDT
   Bugs fixed:
     18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
     20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
     17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
     20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
     17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
     17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
     22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
     18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
     18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
     18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
     20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
     18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
     18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
     20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
     18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
     20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
     17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
     17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
     17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
     17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
     17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
     18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
     18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
     17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
     20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
     17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
     17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
     19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
     21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
     16798862, 15920201

Patch  24732075     : applied on Sat May 06 21:07:31 KST 2017
Unique Patch ID:  21176427
Patch description:  "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
   Created on 20 Feb 2017, 02:20:08 hrs PST8PDT
Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
     13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
     17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
     21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
     17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
     22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
     18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
     17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
     21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
     22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
     17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
     14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
     19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
     24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
     22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
     21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
     18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
     17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
     19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
     16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
     17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
     16228604, 20074391, 19972570, 18996843, 19854503, 16042673, 17835627
     20334344, 18000422, 20861693, 17393683, 17551709, 20506699, 19006849
     18456514, 18277454, 17258090, 17174582, 17242746, 16399083, 17824637
     17762296, 17397545, 16450169, 12364061, 20067212, 18856999, 19211724
     19463893, 21343775, 19463897, 17853456, 18673304, 20004021, 21668627
     16194160, 17477958, 16538760, 12982566, 20296213, 18293054, 17610798
     19699191, 18135678, 17311728, 16785708, 10136473, 24560906, 17786518
     18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
     16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
     18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
     18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615
     17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491
     16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542
     18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068
     17165204, 18508861, 21756699, 16901385, 18554763, 18189036, 17443671
     17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456
     16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917
     16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326
     17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380
     18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537
     17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387
     16392068, 17752995, 21051862, 25505382, 17237521, 16863422, 18244962
     19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
     17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
     21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
     19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
     17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
     22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
     25505394, 17265217, 17071721, 16721594, 21756661, 18262334, 15913355
     17891946, 17672719, 17602269, 17239687, 17042658, 17238511, 17811456
     17284817, 17752121, 17394950, 16579084, 17011832, 22195465, 14602788
     18325460, 24476265, 24476274, 12611721, 16903536, 17006570, 16043574
     18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789
     22195477, 17865671, 19013183, 17343514, 18316692, 17325413, 16180763
     17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081
     24316947, 17705023, 17614227, 22195485, 14084247, 13645875, 16777840
     19727057, 14852021, 18744139, 18674047, 17716305, 18482502, 17622427
     19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 19258504
     17786278, 17082983, 21351877, 13498382, 18331812, 16065166, 18031668
     22893153, 16943711, 21517440, 17649265, 13866822, 18094246, 24528741
     14245531, 17783588, 17082359, 20448824, 18280813, 23330119, 16268425
     17302277, 18018515, 17215560, 24411921, 19271443, 17016369, 20777150
     23330124, 20441797, 19769489, 25093656, 17545847, 18260550, 13853126
     23536835, 17227277, 9756271, 18868646, 17614134, 17546973, 19680952
     18704244, 18828868, 18273830, 17050888, 17360606, 16992075, 17375354
     12905058, 18362222, 17571039, 17468141, 18436647, 17235750, 21168487
     16220077, 16929165



--------------------------------------------------------------------------------

OPatch succeeded.