소스 보기

패치 전 주의사항

패치 파일을 다운로드 받아 압축을 해제하면 파일 안에 README.html 파일이 존재합니다.

해당 파일에는 패치 방법이나 주의 사항과 관련된 자세한 안내가 기록되어 있습니다.

이를 반드시 읽고 테스트를 한 후에 적용해야 합니다.

패치 사전 준비

환경 변수 입력

root 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.1.0/grid
export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1

[root@rac1 ~]# export ORACLE_BASE=/u01/app/oracle
[root@rac1 ~]# export GRID_HOME=/u01/app/12.1.0/grid
[root@rac1 ~]# export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1

서비스 상태 조회

RAC가 정상적으로 기동중인지 확인합니다.

서비스를 수동으로 중단하지 않고, 패치를 진행할 수 있습니다.

$GRID_HOME/bin/crsctl stat res -t

[root@rac1 ~]# $GRID_HOME/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.asm
               ONLINE  ONLINE       rac1                     Started,STABLE
               ONLINE  ONLINE       rac2                     Started,STABLE
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       rac1                     169.254.237.180 10.0
                                                             .5.102,STABLE
ora.cvu
      1        ONLINE  ONLINE       rac1                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       rac1                     Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac1       .vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac2       .vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open,STABLE
      2        ONLINE  ONLINE       rac2                     Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
--------------------------------------------------------------------------------

GRID_HOME의 OPatch 업데이트

root 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

cd $GRID_HOME
OPatch/opatch version
mv OPatch OPatch.bak
cp -r <압축 해제 경로>/OPatch .
chown -R grid:oinstall OPatch
ll | grep OPatch
OPatch/opatch version

[root@rac1 ~]# cd $GRID_HOME
 
[root@rac1 grid]# OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.
 
[root@rac1 grid]# mv OPatch OPatch.bak
 
[root@rac1 grid]# cp -r /media/sf_oracle/OPatch .
 
[root@rac1 grid]# chown -R grid:oinstall OPatch
 
[root@-rac1 grid]# ll | grep OPatch
drwxr-x---. 14 grid oinstall  4096 2018-02-05 08:36 OPatch
drwxr-x---. 11 grid oinstall  4096 2018-02-02 13:15 OPatch.bak
drwxr-xr-x.  7 grid oinstall  4096 2018-01-31 13:33 OPatch.old
 
[root@rac1 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

[root@rac2 ~]# cd $GRID_HOME
 
[root@rac2 grid]# OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.
 
[root@rac2 grid]# mv OPatch OPatch.bak
 
[root@rac2 grid]# cp -r /media/sf_oracle/OPatch .
 
[root@rac2 grid]# chown -R grid:oinstall OPatch
 
[root@rac2 grid]# ll | grep OPatch
drwxr-x---. 14 grid oinstall  4096 2018-02-05 08:37 OPatch
drwxr-x---. 11 grid oinstall  4096 2018-02-02 13:59 OPatch.bak
drwxr-xr-x.  7 grid oinstall  4096 2018-01-31 14:09 OPatch.old
 
[root@rac2 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

ORACLE_HOME의 OPatch 업데이트

root 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

cd $DB_HOME
OPatch/opatch version
mv OPatch OPatch.bak
cp -r <압축 해제 경로>/OPatch .
chown -R oracle:oinstall OPatch
ll | grep OPatch
OPatch/opatch version

[root@rac1 ~]# cd $DB_HOME
 
[root@rac1 db_1]# OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.
 
[root@rac1 db_1]# mv OPatch OPatch.bak
 
[root@rac1 db_1]# cp -r /media/sf_oracle/OPatch .
 
[root@rac1 db_1]# chown -R oracle:oinstall OPatch
 
[root@rac1 db_1]# ll | grep OPatch
drwxr-x---. 14 oracle oinstall  4096 2018-02-05 08:38 OPatch
drwxr-x---. 10 oracle oinstall  4096 2018-02-01 12:07 OPatch.bak
drwxr-xr-x.  7 oracle oinstall  4096 2018-01-31 14:09 OPatch.old
 
[root@rac1 db_1]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

[root@rac2 ~]# cd $DB_HOME
 
[root@rac2 db_1]# OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.
 
[root@rac2 db_1]# mv OPatch OPatch.bak
 
[root@rac2 db_1]# cp -r /media/sf_oracle/OPatch .
 
[root@rac2 db_1]# chown -R oracle:oinstall OPatch
 
[root@rac2 db_1]# ll | grep OPatch
drwxr-x---. 14 oracle oinstall  4096 2018-02-05 08:39 OPatch
drwxr-x---. 10 oracle oinstall  4096 2018-02-01 12:25 OPatch.bak
drwxr-xr-x.  7 oracle oinstall  4096 2018-01-31 14:12 OPatch.old
 
[root@rac2 db_1]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

패치 검증

GRID의 패치 내역 확인

grid 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

$GRID_HOME/OPatch/opatch lsinventory

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch lsinventory

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


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-40-36오전_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-05_08-40-36오전.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

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

Oracle Grid Infrastructure 12c                                       12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(4):

Patch  25363750     : applied on Fri Feb 02 13:22:14 KST 2018
Unique Patch ID:  20990700
Patch description:  "ACFS Patch Set Update : 12.1.0.2.170418 (25363750)"
   Created on 2 Feb 2017, 23:57:22 hrs PST8PDT
   Bugs fixed:
     19452723, 18900953, 21208140, 19844362, 23639692, 18951113, 19526234
     21815339, 18899600, 22810422, 20923224, 19434261, 23252830, 19517835
     18185024, 19273271, 19013966, 19195735, 19001684, 19509898, 23112252
     19053182, 22087780, 20438706, 19593769, 19610001, 19475588, 19811784
     18957085, 19279106, 19184398, 20098064, 22222222, 22198405, 22910118
     20140148, 21519796, 23100705, 19450090, 19502657, 19859183, 18877486
     18915417, 21231953, 19060056, 18955907, 19078259, 19919907, 25078431
     19127216, 20010980, 18934139, 22689989, 19335268, 22174238, 21555038
     20681968, 21058846, 18851012, 19149476, 20952520, 19526283, 19428756
     19183802, 24760367, 19051391, 22846612, 19690653, 25375360, 22613250
     19355146, 21077218, 20314907, 20402287, 22661787, 19644505, 22198176
     22975177, 19353057, 19201087, 19270227, 21233961, 21124596, 19901825
     19610022, 19446719, 22241945, 19649858, 22472364, 24325972, 24609301
     18321597, 19557156, 22319558, 21076821, 19469788, 18510745, 19528981
     21369858, 23321114, 23557970, 19134464

Patch  25363740     : applied on Fri Feb 02 13:21:20 KST 2018
Unique Patch ID:  20990699
Patch description:  "OCW Patch Set Update : 12.1.0.2.170418 (25363740)"
   Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
   Bugs fixed:
     21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
     20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 21441387
     19028836, 19699720, 19620918, 19168690, 18899171, 17005215, 19244316
     19653795, 18634372, 19471722, 19536337, 19184188, 19131709, 20160490
     20995001, 21131037, 19380733, 20985167, 18943696, 20552947, 19591984
     18135723, 18461246, 20014326, 19524857, 25250824, 18890943, 19154753
     19499021, 25206628, 19046190, 20923930, 20028666, 24451580, 19051385
     19050688, 19682695, 19831611, 22891868, 21607972, 18922918, 21087799
     18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
     18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
     17447588, 19262534, 20752167, 19147513, 22475834, 18893463, 21242118
     19514085, 20758997, 19659885, 19319904, 18703978, 23079844, 24796183
     19700256, 19703246, 20467806, 19192901, 21527118, 19479503, 19147751
     18901356, 21232394, 18964974, 22162062, 18835366, 19013789, 19207286
     18950232, 22583325, 19148791, 19556820, 16505171, 21228405, 22261732
     22135419, 19449737, 21878613, 21646169, 19187515, 19230771, 20795241
     19453778, 19853036, 18843572, 18520351, 21430567, 19185148, 19232454
     21220597, 18541110, 18834955, 19204743, 20175174, 19140891, 18747335
     20676340, 19270660, 19325701, 20877003, 19222693, 19662663, 19684131
     19010177, 19272663, 18910576, 18907170, 19426384, 9372680, 20737462
     19700294, 20289828, 19331454, 22568500, 20278216, 20827053, 20119857
     19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
     19589221, 18952857, 19537762, 21152052, 16286734, 20669114, 18762843
     18945249, 19184799, 19205086, 19351363, 20091753, 19031737, 19079087
     19148367, 18968981, 19150517, 20231741, 19217019, 18730096, 18975620
     19067804, 21259359, 19054979, 19209951, 19318983, 18747382, 19154673
     18752378, 22905714, 19150088, 19013444, 19234177, 18999857, 19075747
     19367276, 19612597, 19874047, 19677813, 23049292, 19427050, 18910443
     20033787, 19148982, 19777496, 20730170, 24362631, 18523468, 19277814
     20562133, 19071526, 21420753, 25537905, 18850051, 20433932, 20061168
     18468128, 19370739, 20822591, 19609388, 18776786, 20136892, 18989446
     19148793, 22904978, 19585454, 18317489, 19955755, 19059053, 19807548
     19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
     22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
     21229744, 19516572, 21474380, 21484367, 20276459, 21550724, 17208793
     19234907, 20007009, 19538714, 22867050, 22728264, 19383028, 19513969
     22195657, 23111368, 19986391, 19314048, 18834934, 19473851, 19458082
     18894342, 19522067, 23618734, 18116578, 19241857, 19076778, 19066699
     25206563, 19068003, 18937186, 20267877, 19916737, 19770543, 22863466
     19635215, 19613533, 21057239, 20783416, 19315522, 19141785, 19163887
     19885321, 25233268, 18715868, 18852058, 19701617, 19280860, 19139608
     21453435, 18946768, 19135521, 18604143, 23150001, 19627476, 20568884
     20317221, 20177779, 19266658, 19491996, 24522717, 18330979, 19027351
     21227730, 18707416, 21118157, 21113068, 19925992, 20235486, 20006646
     15922206, 18439295, 18991776, 21245437, 23170839, 19163425, 19550195
     20389257, 18849021, 18861196, 17940721, 18524834, 19287706, 19522313
     18835283, 18748932, 19184765, 21639478, 14851828, 20598625, 19226141
     19053891, 18871287, 25371730, 18998228, 18980002, 19682778, 19325604
     8934841, 18777835, 17338864, 18945906, 19513650, 19702758, 18952577
     19473088, 19178517, 18729269, 19529729, 19455563, 20877072, 23275930
     20340620, 18536826, 19292605, 22264951, 20920711, 20660273, 20011635
     17592037, 18935857, 22989069, 19029647, 19179158, 22302421, 23076471
     19140712, 20012766, 23049301, 19184276, 25206643, 20510208, 20001507
     20079414, 19680763, 19259765, 18962892, 19513888, 14661880, 21519340
     21222147, 20218012, 19551830, 21616278, 19068333, 18945435, 20775015
     19319192, 20839581, 19178629, 18774591, 21694237, 19304104, 19284357
     22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
     19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
     21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
     21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
     19155350, 19884033, 19146822, 18798432, 21123424, 24356071, 19471836
     20936562, 18750781, 19045143, 20559126, 22483804, 19146980, 19601003
     20099624, 21378016, 19537547, 19281106, 18862203, 19954372, 18235274
     19205617, 19513351, 20219458, 19150313, 18843054, 18708349, 19332386
     18953639, 21423055, 19371270, 25221056, 19203996, 20038431, 19370846
     21053036, 18998379, 20157569, 21357522, 19273577, 24709351, 25206634
     22113170, 19632437, 18990354, 19288396, 20620581, 19557558, 19127078
     22548137, 21792881, 20900588, 20053557, 22088198, 22664609, 19315567
     19444471, 19154933, 20953798, 18290252, 18813323, 19915945, 19500293
     18643483, 19134098, 23034352, 25206614, 18965694, 19226858, 19591356
     19602208, 22884308, 20069197, 18417590, 18920408, 18263259, 18636884
     22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
     19273758, 18953878, 18999195, 24314323, 18759724, 20458032, 19066844
     13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
     20862812, 19504641, 23101611, 19341481, 20293730, 19343245, 18304090
     19241655, 19470791, 18242738, 20649573, 18372060, 18953889, 18827679
     19140711, 19023430, 19259290, 19045388, 20186278, 25197395, 19522571
     19709663, 18875012, 18861564, 21075392, 19273760, 19225265, 15885689
     20853464, 21696068, 18819158, 21394146, 19049721, 19368917, 25206650
     21255373, 22393909, 20408163, 20579351, 18868829, 20350915, 21327402
     22024217, 23101338, 19820247, 25206585, 20363708, 19538241, 19804032

Patch  25171037     : applied on Fri Feb 02 13:20:39 KST 2018
Unique Patch ID:  21099266
Patch description:  "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
   Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
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, 21172913, 19902195, 18250893, 25475853, 17655240, 19383839
     21266085, 19028800, 19035573, 16756406, 19366375, 18456643, 24523374
     19289642, 18845653, 19915271, 21291274, 18417036, 20475845, 22148226
     22528741, 19243521, 19658708, 21153266, 19326908, 19597583, 17414008
     20897759, 19174430, 22046677, 22243719, 24825843, 21960504, 19054077
     22657942, 20688221, 20428621, 21899588, 21387964, 13542050, 19723336
     19835133, 17532734, 19333670, 21373473, 23260854, 19687159, 14643995
     20977794, 20734332, 19012119, 19869255, 17551063, 18681056, 21977392
     23324000, 19676012, 20588502, 19520602, 19841800, 19439759, 20245930
     19303936, 19001359, 21476308, 22916353, 19393542, 23533524, 21099555
     22353346, 19141838, 19644859, 21106027, 21915719, 19908836, 21421886
     22529728, 19358317, 19134173, 19524158, 20447445, 20803014, 23025340
     21188584, 19335438, 19390567, 19058490, 18799993, 19769480, 19475971
     21097043, 21225209, 20677396, 19284031, 19450314, 19016730, 18967382
     20919320, 22075064, 20347562, 20348653, 22551446, 19896336, 24812585
     20048359, 21896069, 22496904, 19524384, 18440095, 16439813, 18354830
     20596234, 20440930, 22022760, 20936905, 19171086, 23197103, 17867700
     19791273, 18990023, 21241829, 19591608, 22296366, 20173897, 17210525
     18914624, 19571367, 21260431, 19501299, 20181030, 25056052, 20425790
     21868720, 19124589, 19402853, 19888853, 16870214, 17722075, 18202441
     18743542, 19001390, 20882568, 25546608, 19081128, 22173980, 21875360
     19178851, 19149990, 20951038, 22168163, 16777441, 25161298, 19606174
     24308635, 20848335, 20569094, 19791377, 19050649, 19382851, 20920911
     20528052, 22762046, 19189525, 19469538, 20598042, 22458049, 18988834
     19176326, 19048007, 22905130, 19238590, 20387265, 16941434, 21263635
     24397438, 20673810, 22160989, 20356733, 22380919, 18499088, 18436647
     21059919, 20825533, 18952989, 19124336, 22294260, 20794034, 19468347
     20284155, 19883092, 20657441, 17365043, 25539063, 21285458, 20952966
     25330273, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
     22083366, 21419850, 20669434, 18964978, 19577410, 21373076, 14283239
     19931709, 20368850, 21239530, 20880215, 20798891, 18122373, 20043616
     23124895, 19013183, 18856999, 21450666, 21133343, 22695831, 18893947
     21196809, 21354456, 19587324, 20464614, 24808595, 22062026, 19189317
     18307021, 21917884, 19708632, 20711718, 20134339, 22077517, 22815955
     24690216, 18973548, 22507210, 20101006, 20250147, 19197175, 23501901
     18797519, 19597439, 21387128, 19180770, 19879746, 19354335, 21785691
     19730508, 22366558, 24285405, 6599380, 21297872, 20322560, 18964939
     22520320, 21575362, 20171986, 22365117, 21542577, 22507234, 23170620
     20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
     19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
     19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
     20471920, 19052488, 22024071, 19503821, 22809871, 20074391, 21184223
     23089357, 19157754, 21220620, 24316947, 18921743, 19865345, 19065677
     19065556, 19018447, 19018206, 19777862, 22223463, 19304354, 20878790
     21322887, 20879889, 20890311, 24350831, 19578350, 20869721, 21142837
     21756699, 20217801, 18819908, 19363645, 25483815, 21072646, 20898391
     19291380, 19593445, 20373598, 19248799, 20031873, 19155797, 19279273
     18886413, 18618122, 25490238, 20922010, 19990037, 20509482, 24739928
     18966843, 19077215, 20703000, 21526048, 20704450, 19068970, 21620471
     19023822, 20543011, 19670108, 19068610, 20267166, 21756677, 20476175
     18549238, 20328248, 18674047, 19385656, 18849537, 19684504, 20315311
     20899461, 19308965, 19143550, 21911701, 19024808, 18948177, 19468991
     20009833, 20868862, 20466628, 21756661, 20397490, 19706965, 22178855
     19604659, 16359751, 19032777, 19329654, 20862087, 19928926, 18974476
     23314180, 20212067, 20603378, 20859910, 19307662, 21847223, 21668627
     20281121, 19075256, 20877664, 19487147, 19076343, 24577566, 19430401
     19676905, 20844426, 20904530, 20925795, 20441797, 21296029, 21629064
     21442094, 23229229, 22865673, 20708701, 25079710, 19280225, 21315084
     18840932, 19213447, 18740837, 20294666, 19989009, 18191823, 21517440
     22062517, 19174942, 17319928, 21889720, 19703301, 20122715, 18411216
     20117253, 19258504, 21188532, 24386767, 17890099, 21649497, 16887946
     25264559, 18791688, 19721304, 22092979, 19490948, 19619732, 21164318
     20879709, 20165574, 19272708, 19818513, 19547370, 20139391, 24693382
     20228093, 21281532, 19978542, 22165897, 22359063, 19409212, 19805359
     19461270, 19434529, 18799063, 18990693, 20378086, 21246723, 17008068
     21422580, 21632821, 20831538, 20424899, 22351572, 20361671, 18674024
     19689979, 20235511, 23220453, 19873610, 16619249, 24411921, 20562898
     21091431, 19440586, 22757364, 18610915, 22175564, 19561643, 19399918
     19195895, 20832516, 20017509, 20907061, 21665897, 20746251, 19183343
     21787056, 23096938, 21273804, 19067244, 18043064, 21329301, 18885870
     19536415, 17835294, 25093739, 20446883, 21299490, 24413809, 21744290
     18254023, 20591183, 20413820, 19185876, 22465352, 20558005, 20402832
     19627012, 20093776, 18909599, 20618595, 16863642, 19639483, 19315691
     20331945, 19512341, 21479753, 19637186, 19174521, 19022470, 18607546
     20401975, 18306996, 18851894, 19649152, 20581111, 19201867, 20318889
     20936731, 21060755, 21294938, 20898997, 18510194, 19534363, 19188927

Patch  21436941     : applied on Fri Feb 02 13:19:39 KST 2018
Unique Patch ID:  19245012
Patch description:  "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
   Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
   Bugs fixed:
     20075154, 20641027, 20548410, 19016964, 19582630



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

OPatch succeeded.

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch lsinventory

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


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-41-52오전_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-05_08-41-52오전.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2
ARU platform id: 226
ARU platform description:: Linux x86-64

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

Oracle Grid Infrastructure 12c                                       12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(4):

Patch  25363750     : applied on Fri Feb 02 13:36:10 KST 2018
Unique Patch ID:  20990700
Patch description:  "ACFS Patch Set Update : 12.1.0.2.170418 (25363750)"
   Created on 2 Feb 2017, 23:57:22 hrs PST8PDT
   Bugs fixed:
     19452723, 18900953, 21208140, 19844362, 23639692, 18951113, 19526234
     21815339, 18899600, 22810422, 20923224, 19434261, 23252830, 19517835
     18185024, 19273271, 19013966, 19195735, 19001684, 19509898, 23112252
     19053182, 22087780, 20438706, 19593769, 19610001, 19475588, 19811784
     18957085, 19279106, 19184398, 20098064, 22222222, 22198405, 22910118
     20140148, 21519796, 23100705, 19450090, 19502657, 19859183, 18877486
     18915417, 21231953, 19060056, 18955907, 19078259, 19919907, 25078431
     19127216, 20010980, 18934139, 22689989, 19335268, 22174238, 21555038
     20681968, 21058846, 18851012, 19149476, 20952520, 19526283, 19428756
     19183802, 24760367, 19051391, 22846612, 19690653, 25375360, 22613250
     19355146, 21077218, 20314907, 20402287, 22661787, 19644505, 22198176
     22975177, 19353057, 19201087, 19270227, 21233961, 21124596, 19901825
     19610022, 19446719, 22241945, 19649858, 22472364, 24325972, 24609301
     18321597, 19557156, 22319558, 21076821, 19469788, 18510745, 19528981
     21369858, 23321114, 23557970, 19134464

Patch  25363740     : applied on Fri Feb 02 13:35:15 KST 2018
Unique Patch ID:  20990699
Patch description:  "OCW Patch Set Update : 12.1.0.2.170418 (25363740)"
   Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
   Bugs fixed:
     21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
     20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 21441387
     19028836, 19699720, 19620918, 19168690, 18899171, 17005215, 19244316
     19653795, 18634372, 19471722, 19536337, 19184188, 19131709, 20160490
     20995001, 21131037, 19380733, 20985167, 18943696, 20552947, 19591984
     18135723, 18461246, 20014326, 19524857, 25250824, 18890943, 19154753
     19499021, 25206628, 19046190, 20923930, 20028666, 24451580, 19051385
     19050688, 19682695, 19831611, 22891868, 21607972, 18922918, 21087799
     18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
     18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
     17447588, 19262534, 20752167, 19147513, 22475834, 18893463, 21242118
     19514085, 20758997, 19659885, 19319904, 18703978, 23079844, 24796183
     19700256, 19703246, 20467806, 19192901, 21527118, 19479503, 19147751
     18901356, 21232394, 18964974, 22162062, 18835366, 19013789, 19207286
     18950232, 22583325, 19148791, 19556820, 16505171, 21228405, 22261732
     22135419, 19449737, 21878613, 21646169, 19187515, 19230771, 20795241
     19453778, 19853036, 18843572, 18520351, 21430567, 19185148, 19232454
     21220597, 18541110, 18834955, 19204743, 20175174, 19140891, 18747335
     20676340, 19270660, 19325701, 20877003, 19222693, 19662663, 19684131
     19010177, 19272663, 18910576, 18907170, 19426384, 9372680, 20737462
     19700294, 20289828, 19331454, 22568500, 20278216, 20827053, 20119857
     19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
     19589221, 18952857, 19537762, 21152052, 16286734, 20669114, 18762843
     18945249, 19184799, 19205086, 19351363, 20091753, 19031737, 19079087
     19148367, 18968981, 19150517, 20231741, 19217019, 18730096, 18975620
     19067804, 21259359, 19054979, 19209951, 19318983, 18747382, 19154673
     18752378, 22905714, 19150088, 19013444, 19234177, 18999857, 19075747
     19367276, 19612597, 19874047, 19677813, 23049292, 19427050, 18910443
     20033787, 19148982, 19777496, 20730170, 24362631, 18523468, 19277814
     20562133, 19071526, 21420753, 25537905, 18850051, 20433932, 20061168
     18468128, 19370739, 20822591, 19609388, 18776786, 20136892, 18989446
     19148793, 22904978, 19585454, 18317489, 19955755, 19059053, 19807548
     19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
     22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
     21229744, 19516572, 21474380, 21484367, 20276459, 21550724, 17208793
     19234907, 20007009, 19538714, 22867050, 22728264, 19383028, 19513969
     22195657, 23111368, 19986391, 19314048, 18834934, 19473851, 19458082
     18894342, 19522067, 23618734, 18116578, 19241857, 19076778, 19066699
     25206563, 19068003, 18937186, 20267877, 19916737, 19770543, 22863466
     19635215, 19613533, 21057239, 20783416, 19315522, 19141785, 19163887
     19885321, 25233268, 18715868, 18852058, 19701617, 19280860, 19139608
     21453435, 18946768, 19135521, 18604143, 23150001, 19627476, 20568884
     20317221, 20177779, 19266658, 19491996, 24522717, 18330979, 19027351
     21227730, 18707416, 21118157, 21113068, 19925992, 20235486, 20006646
     15922206, 18439295, 18991776, 21245437, 23170839, 19163425, 19550195
     20389257, 18849021, 18861196, 17940721, 18524834, 19287706, 19522313
     18835283, 18748932, 19184765, 21639478, 14851828, 20598625, 19226141
     19053891, 18871287, 25371730, 18998228, 18980002, 19682778, 19325604
     8934841, 18777835, 17338864, 18945906, 19513650, 19702758, 18952577
     19473088, 19178517, 18729269, 19529729, 19455563, 20877072, 23275930
     20340620, 18536826, 19292605, 22264951, 20920711, 20660273, 20011635
     17592037, 18935857, 22989069, 19029647, 19179158, 22302421, 23076471
     19140712, 20012766, 23049301, 19184276, 25206643, 20510208, 20001507
     20079414, 19680763, 19259765, 18962892, 19513888, 14661880, 21519340
     21222147, 20218012, 19551830, 21616278, 19068333, 18945435, 20775015
     19319192, 20839581, 19178629, 18774591, 21694237, 19304104, 19284357
     22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
     19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
     21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
     21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
     19155350, 19884033, 19146822, 18798432, 21123424, 24356071, 19471836
     20936562, 18750781, 19045143, 20559126, 22483804, 19146980, 19601003
     20099624, 21378016, 19537547, 19281106, 18862203, 19954372, 18235274
     19205617, 19513351, 20219458, 19150313, 18843054, 18708349, 19332386
     18953639, 21423055, 19371270, 25221056, 19203996, 20038431, 19370846
     21053036, 18998379, 20157569, 21357522, 19273577, 24709351, 25206634
     22113170, 19632437, 18990354, 19288396, 20620581, 19557558, 19127078
     22548137, 21792881, 20900588, 20053557, 22088198, 22664609, 19315567
     19444471, 19154933, 20953798, 18290252, 18813323, 19915945, 19500293
     18643483, 19134098, 23034352, 25206614, 18965694, 19226858, 19591356
     19602208, 22884308, 20069197, 18417590, 18920408, 18263259, 18636884
     22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
     19273758, 18953878, 18999195, 24314323, 18759724, 20458032, 19066844
     13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
     20862812, 19504641, 23101611, 19341481, 20293730, 19343245, 18304090
     19241655, 19470791, 18242738, 20649573, 18372060, 18953889, 18827679
     19140711, 19023430, 19259290, 19045388, 20186278, 25197395, 19522571
     19709663, 18875012, 18861564, 21075392, 19273760, 19225265, 15885689
     20853464, 21696068, 18819158, 21394146, 19049721, 19368917, 25206650
     21255373, 22393909, 20408163, 20579351, 18868829, 20350915, 21327402
     22024217, 23101338, 19820247, 25206585, 20363708, 19538241, 19804032

Patch  25171037     : applied on Fri Feb 02 13:34:31 KST 2018
Unique Patch ID:  21099266
Patch description:  "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
   Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
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, 21172913, 19902195, 18250893, 25475853, 17655240, 19383839
     21266085, 19028800, 19035573, 16756406, 19366375, 18456643, 24523374
     19289642, 18845653, 19915271, 21291274, 18417036, 20475845, 22148226
     22528741, 19243521, 19658708, 21153266, 19326908, 19597583, 17414008
     20897759, 19174430, 22046677, 22243719, 24825843, 21960504, 19054077
     22657942, 20688221, 20428621, 21899588, 21387964, 13542050, 19723336
     19835133, 17532734, 19333670, 21373473, 23260854, 19687159, 14643995
     20977794, 20734332, 19012119, 19869255, 17551063, 18681056, 21977392
     23324000, 19676012, 20588502, 19520602, 19841800, 19439759, 20245930
     19303936, 19001359, 21476308, 22916353, 19393542, 23533524, 21099555
     22353346, 19141838, 19644859, 21106027, 21915719, 19908836, 21421886
     22529728, 19358317, 19134173, 19524158, 20447445, 20803014, 23025340
     21188584, 19335438, 19390567, 19058490, 18799993, 19769480, 19475971
     21097043, 21225209, 20677396, 19284031, 19450314, 19016730, 18967382
     20919320, 22075064, 20347562, 20348653, 22551446, 19896336, 24812585
     20048359, 21896069, 22496904, 19524384, 18440095, 16439813, 18354830
     20596234, 20440930, 22022760, 20936905, 19171086, 23197103, 17867700
     19791273, 18990023, 21241829, 19591608, 22296366, 20173897, 17210525
     18914624, 19571367, 21260431, 19501299, 20181030, 25056052, 20425790
     21868720, 19124589, 19402853, 19888853, 16870214, 17722075, 18202441
     18743542, 19001390, 20882568, 25546608, 19081128, 22173980, 21875360
     19178851, 19149990, 20951038, 22168163, 16777441, 25161298, 19606174
     24308635, 20848335, 20569094, 19791377, 19050649, 19382851, 20920911
     20528052, 22762046, 19189525, 19469538, 20598042, 22458049, 18988834
     19176326, 19048007, 22905130, 19238590, 20387265, 16941434, 21263635
     24397438, 20673810, 22160989, 20356733, 22380919, 18499088, 18436647
     21059919, 20825533, 18952989, 19124336, 22294260, 20794034, 19468347
     20284155, 19883092, 20657441, 17365043, 25539063, 21285458, 20952966
     25330273, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
     22083366, 21419850, 20669434, 18964978, 19577410, 21373076, 14283239
     19931709, 20368850, 21239530, 20880215, 20798891, 18122373, 20043616
     23124895, 19013183, 18856999, 21450666, 21133343, 22695831, 18893947
     21196809, 21354456, 19587324, 20464614, 24808595, 22062026, 19189317
     18307021, 21917884, 19708632, 20711718, 20134339, 22077517, 22815955
     24690216, 18973548, 22507210, 20101006, 20250147, 19197175, 23501901
     18797519, 19597439, 21387128, 19180770, 19879746, 19354335, 21785691
     19730508, 22366558, 24285405, 6599380, 21297872, 20322560, 18964939
     22520320, 21575362, 20171986, 22365117, 21542577, 22507234, 23170620
     20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
     19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
     19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
     20471920, 19052488, 22024071, 19503821, 22809871, 20074391, 21184223
     23089357, 19157754, 21220620, 24316947, 18921743, 19865345, 19065677
     19065556, 19018447, 19018206, 19777862, 22223463, 19304354, 20878790
     21322887, 20879889, 20890311, 24350831, 19578350, 20869721, 21142837
     21756699, 20217801, 18819908, 19363645, 25483815, 21072646, 20898391
     19291380, 19593445, 20373598, 19248799, 20031873, 19155797, 19279273
     18886413, 18618122, 25490238, 20922010, 19990037, 20509482, 24739928
     18966843, 19077215, 20703000, 21526048, 20704450, 19068970, 21620471
     19023822, 20543011, 19670108, 19068610, 20267166, 21756677, 20476175
     18549238, 20328248, 18674047, 19385656, 18849537, 19684504, 20315311
     20899461, 19308965, 19143550, 21911701, 19024808, 18948177, 19468991
     20009833, 20868862, 20466628, 21756661, 20397490, 19706965, 22178855
     19604659, 16359751, 19032777, 19329654, 20862087, 19928926, 18974476
     23314180, 20212067, 20603378, 20859910, 19307662, 21847223, 21668627
     20281121, 19075256, 20877664, 19487147, 19076343, 24577566, 19430401
     19676905, 20844426, 20904530, 20925795, 20441797, 21296029, 21629064
     21442094, 23229229, 22865673, 20708701, 25079710, 19280225, 21315084
     18840932, 19213447, 18740837, 20294666, 19989009, 18191823, 21517440
     22062517, 19174942, 17319928, 21889720, 19703301, 20122715, 18411216
     20117253, 19258504, 21188532, 24386767, 17890099, 21649497, 16887946
     25264559, 18791688, 19721304, 22092979, 19490948, 19619732, 21164318
     20879709, 20165574, 19272708, 19818513, 19547370, 20139391, 24693382
     20228093, 21281532, 19978542, 22165897, 22359063, 19409212, 19805359
     19461270, 19434529, 18799063, 18990693, 20378086, 21246723, 17008068
     21422580, 21632821, 20831538, 20424899, 22351572, 20361671, 18674024
     19689979, 20235511, 23220453, 19873610, 16619249, 24411921, 20562898
     21091431, 19440586, 22757364, 18610915, 22175564, 19561643, 19399918
     19195895, 20832516, 20017509, 20907061, 21665897, 20746251, 19183343
     21787056, 23096938, 21273804, 19067244, 18043064, 21329301, 18885870
     19536415, 17835294, 25093739, 20446883, 21299490, 24413809, 21744290
     18254023, 20591183, 20413820, 19185876, 22465352, 20558005, 20402832
     19627012, 20093776, 18909599, 20618595, 16863642, 19639483, 19315691
     20331945, 19512341, 21479753, 19637186, 19174521, 19022470, 18607546
     20401975, 18306996, 18851894, 19649152, 20581111, 19201867, 20318889
     20936731, 21060755, 21294938, 20898997, 18510194, 19534363, 19188927

Patch  21436941     : applied on Fri Feb 02 13:33:30 KST 2018
Unique Patch ID:  19245012
Patch description:  "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
   Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
   Bugs fixed:
     20075154, 20641027, 20548410, 19016964, 19582630



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

OPatch succeeded.

GRID 패치 충돌 여부 검증

grid 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

pass되지 않은 항목이 있다면 oracle에 기술 지원을 요청해야 합니다. (기존 패치의 rollback 등의 작업이 필요할 수 있으므로 반드시 가이드를 받고 진행합니다.)

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26925263
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26925218
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26910974
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26983807

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-41-11오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-41-19오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-41-22오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-41-27오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-42-41오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-42-49오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-42-52오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807

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

PREREQ session

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-42-57오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

GRID 패치 디스크 용량 확인

GRID 패치를 위해 충분한 디스크 용량이 확보되어 있는지 검사합니다.

적용할 패치 파일의 디렉토리 경로를 텍스트 파일에 저장하고, opatch의 CheckSystemSpace 옵션을 이용하여 디스크 공간을 검사합니다.

vi /tmp/patch_list_gihome.txt
# cat /tmp/patch_list_gihome.txt
$GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

[grid@+ASM1 ~]$ vi /tmp/patch_list_gihome.txt
[grid@+ASM1 ~]$ cat /tmp/patch_list_gihome.txt
/media/sf_oracle/27010930/26983807
/media/sf_oracle/27010930/26910974
/media/sf_oracle/27010930/26925218
/media/sf_oracle/27010930/26925263
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

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

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-43-55오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

[grid@+ASM2 ~]$ vi /tmp/patch_list_gihome.txt

[grid@+ASM2 ~]$ cat /tmp/patch_list_gihome.txt
/media/sf_oracle/27010930/26983807
/media/sf_oracle/27010930/26910974
/media/sf_oracle/27010930/26925218
/media/sf_oracle/27010930/26925263

[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

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

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-05_08-45-01오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

Database의 패치 내역 확인

oracle 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

$DB_HOME/OPatch/opatch lsinventory

[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch lsinventory

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


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-45-50오전_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-05_08-45-50오전.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

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

Oracle Database 12c                                                  12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(2):

Patch  25363740     : applied on Fri Feb 02 13:58:20 KST 2018
Unique Patch ID:  20990699
Patch description:  "OCW Patch Set Update : 12.1.0.2.170418 (25363740)"
   Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
   Bugs fixed:
     21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
     20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 21441387
     19028836, 19699720, 19620918, 19168690, 18899171, 17005215, 19244316
     19653795, 18634372, 19471722, 19536337, 19184188, 19131709, 20160490
     20995001, 21131037, 19380733, 20985167, 18943696, 20552947, 19591984
     18135723, 18461246, 20014326, 19524857, 25250824, 18890943, 19154753
     19499021, 25206628, 19046190, 20923930, 20028666, 24451580, 19051385
     19050688, 19682695, 19831611, 22891868, 21607972, 18922918, 21087799
     18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
     18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
     17447588, 19262534, 20752167, 19147513, 22475834, 18893463, 21242118
     19514085, 20758997, 19659885, 19319904, 18703978, 23079844, 24796183
     19700256, 19703246, 20467806, 19192901, 21527118, 19479503, 19147751
     18901356, 21232394, 18964974, 22162062, 18835366, 19013789, 19207286
     18950232, 22583325, 19148791, 19556820, 16505171, 21228405, 22261732
     22135419, 19449737, 21878613, 21646169, 19187515, 19230771, 20795241
     19453778, 19853036, 18843572, 18520351, 21430567, 19185148, 19232454
     21220597, 18541110, 18834955, 19204743, 20175174, 19140891, 18747335
     20676340, 19270660, 19325701, 20877003, 19222693, 19662663, 19684131
     19010177, 19272663, 18910576, 18907170, 19426384, 9372680, 20737462
     19700294, 20289828, 19331454, 22568500, 20278216, 20827053, 20119857
     19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
     19589221, 18952857, 19537762, 21152052, 16286734, 20669114, 18762843
     18945249, 19184799, 19205086, 19351363, 20091753, 19031737, 19079087
     19148367, 18968981, 19150517, 20231741, 19217019, 18730096, 18975620
     19067804, 21259359, 19054979, 19209951, 19318983, 18747382, 19154673
     18752378, 22905714, 19150088, 19013444, 19234177, 18999857, 19075747
     19367276, 19612597, 19874047, 19677813, 23049292, 19427050, 18910443
     20033787, 19148982, 19777496, 20730170, 24362631, 18523468, 19277814
     20562133, 19071526, 21420753, 25537905, 18850051, 20433932, 20061168
     18468128, 19370739, 20822591, 19609388, 18776786, 20136892, 18989446
     19148793, 22904978, 19585454, 18317489, 19955755, 19059053, 19807548
     19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
     22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
     21229744, 19516572, 21474380, 21484367, 20276459, 21550724, 17208793
     19234907, 20007009, 19538714, 22867050, 22728264, 19383028, 19513969
     22195657, 23111368, 19986391, 19314048, 18834934, 19473851, 19458082
     18894342, 19522067, 23618734, 18116578, 19241857, 19076778, 19066699
     25206563, 19068003, 18937186, 20267877, 19916737, 19770543, 22863466
     19635215, 19613533, 21057239, 20783416, 19315522, 19141785, 19163887
     19885321, 25233268, 18715868, 18852058, 19701617, 19280860, 19139608
     21453435, 18946768, 19135521, 18604143, 23150001, 19627476, 20568884
     20317221, 20177779, 19266658, 19491996, 24522717, 18330979, 19027351
     21227730, 18707416, 21118157, 21113068, 19925992, 20235486, 20006646
     15922206, 18439295, 18991776, 21245437, 23170839, 19163425, 19550195
     20389257, 18849021, 18861196, 17940721, 18524834, 19287706, 19522313
     18835283, 18748932, 19184765, 21639478, 14851828, 20598625, 19226141
     19053891, 18871287, 25371730, 18998228, 18980002, 19682778, 19325604
     8934841, 18777835, 17338864, 18945906, 19513650, 19702758, 18952577
     19473088, 19178517, 18729269, 19529729, 19455563, 20877072, 23275930
     20340620, 18536826, 19292605, 22264951, 20920711, 20660273, 20011635
     17592037, 18935857, 22989069, 19029647, 19179158, 22302421, 23076471
     19140712, 20012766, 23049301, 19184276, 25206643, 20510208, 20001507
     20079414, 19680763, 19259765, 18962892, 19513888, 14661880, 21519340
     21222147, 20218012, 19551830, 21616278, 19068333, 18945435, 20775015
     19319192, 20839581, 19178629, 18774591, 21694237, 19304104, 19284357
     22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
     19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
     21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
     21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
     19155350, 19884033, 19146822, 18798432, 21123424, 24356071, 19471836
     20936562, 18750781, 19045143, 20559126, 22483804, 19146980, 19601003
     20099624, 21378016, 19537547, 19281106, 18862203, 19954372, 18235274
     19205617, 19513351, 20219458, 19150313, 18843054, 18708349, 19332386
     18953639, 21423055, 19371270, 25221056, 19203996, 20038431, 19370846
     21053036, 18998379, 20157569, 21357522, 19273577, 24709351, 25206634
     22113170, 19632437, 18990354, 19288396, 20620581, 19557558, 19127078
     22548137, 21792881, 20900588, 20053557, 22088198, 22664609, 19315567
     19444471, 19154933, 20953798, 18290252, 18813323, 19915945, 19500293
     18643483, 19134098, 23034352, 25206614, 18965694, 19226858, 19591356
     19602208, 22884308, 20069197, 18417590, 18920408, 18263259, 18636884
     22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
     19273758, 18953878, 18999195, 24314323, 18759724, 20458032, 19066844
     13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
     20862812, 19504641, 23101611, 19341481, 20293730, 19343245, 18304090
     19241655, 19470791, 18242738, 20649573, 18372060, 18953889, 18827679
     19140711, 19023430, 19259290, 19045388, 20186278, 25197395, 19522571
     19709663, 18875012, 18861564, 21075392, 19273760, 19225265, 15885689
     20853464, 21696068, 18819158, 21394146, 19049721, 19368917, 25206650
     21255373, 22393909, 20408163, 20579351, 18868829, 20350915, 21327402
     22024217, 23101338, 19820247, 25206585, 20363708, 19538241, 19804032

Patch  25171037     : applied on Fri Feb 02 13:58:14 KST 2018
Unique Patch ID:  21099266
Patch description:  "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
   Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
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, 21172913, 19902195, 18250893, 25475853, 17655240, 19383839
     21266085, 19028800, 19035573, 16756406, 19366375, 18456643, 24523374
     19289642, 18845653, 19915271, 21291274, 18417036, 20475845, 22148226
     22528741, 19243521, 19658708, 21153266, 19326908, 19597583, 17414008
     20897759, 19174430, 22046677, 22243719, 24825843, 21960504, 19054077
     22657942, 20688221, 20428621, 21899588, 21387964, 13542050, 19723336
     19835133, 17532734, 19333670, 21373473, 23260854, 19687159, 14643995
     20977794, 20734332, 19012119, 19869255, 17551063, 18681056, 21977392
     23324000, 19676012, 20588502, 19520602, 19841800, 19439759, 20245930
     19303936, 19001359, 21476308, 22916353, 19393542, 23533524, 21099555
     22353346, 19141838, 19644859, 21106027, 21915719, 19908836, 21421886
     22529728, 19358317, 19134173, 19524158, 20447445, 20803014, 23025340
     21188584, 19335438, 19390567, 19058490, 18799993, 19769480, 19475971
     21097043, 21225209, 20677396, 19284031, 19450314, 19016730, 18967382
     20919320, 22075064, 20347562, 20348653, 22551446, 19896336, 24812585
     20048359, 21896069, 22496904, 19524384, 18440095, 16439813, 18354830
     20596234, 20440930, 22022760, 20936905, 19171086, 23197103, 17867700
     19791273, 18990023, 21241829, 19591608, 22296366, 20173897, 17210525
     18914624, 19571367, 21260431, 19501299, 20181030, 25056052, 20425790
     21868720, 19124589, 19402853, 19888853, 16870214, 17722075, 18202441
     18743542, 19001390, 20882568, 25546608, 19081128, 22173980, 21875360
     19178851, 19149990, 20951038, 22168163, 16777441, 25161298, 19606174
     24308635, 20848335, 20569094, 19791377, 19050649, 19382851, 20920911
     20528052, 22762046, 19189525, 19469538, 20598042, 22458049, 18988834
     19176326, 19048007, 22905130, 19238590, 20387265, 16941434, 21263635
     24397438, 20673810, 22160989, 20356733, 22380919, 18499088, 18436647
     21059919, 20825533, 18952989, 19124336, 22294260, 20794034, 19468347
     20284155, 19883092, 20657441, 17365043, 25539063, 21285458, 20952966
     25330273, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
     22083366, 21419850, 20669434, 18964978, 19577410, 21373076, 14283239
     19931709, 20368850, 21239530, 20880215, 20798891, 18122373, 20043616
     23124895, 19013183, 18856999, 21450666, 21133343, 22695831, 18893947
     21196809, 21354456, 19587324, 20464614, 24808595, 22062026, 19189317
     18307021, 21917884, 19708632, 20711718, 20134339, 22077517, 22815955
     24690216, 18973548, 22507210, 20101006, 20250147, 19197175, 23501901
     18797519, 19597439, 21387128, 19180770, 19879746, 19354335, 21785691
     19730508, 22366558, 24285405, 6599380, 21297872, 20322560, 18964939
     22520320, 21575362, 20171986, 22365117, 21542577, 22507234, 23170620
     20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
     19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
     19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
     20471920, 19052488, 22024071, 19503821, 22809871, 20074391, 21184223
     23089357, 19157754, 21220620, 24316947, 18921743, 19865345, 19065677
     19065556, 19018447, 19018206, 19777862, 22223463, 19304354, 20878790
     21322887, 20879889, 20890311, 24350831, 19578350, 20869721, 21142837
     21756699, 20217801, 18819908, 19363645, 25483815, 21072646, 20898391
     19291380, 19593445, 20373598, 19248799, 20031873, 19155797, 19279273
     18886413, 18618122, 25490238, 20922010, 19990037, 20509482, 24739928
     18966843, 19077215, 20703000, 21526048, 20704450, 19068970, 21620471
     19023822, 20543011, 19670108, 19068610, 20267166, 21756677, 20476175
     18549238, 20328248, 18674047, 19385656, 18849537, 19684504, 20315311
     20899461, 19308965, 19143550, 21911701, 19024808, 18948177, 19468991
     20009833, 20868862, 20466628, 21756661, 20397490, 19706965, 22178855
     19604659, 16359751, 19032777, 19329654, 20862087, 19928926, 18974476
     23314180, 20212067, 20603378, 20859910, 19307662, 21847223, 21668627
     20281121, 19075256, 20877664, 19487147, 19076343, 24577566, 19430401
     19676905, 20844426, 20904530, 20925795, 20441797, 21296029, 21629064
     21442094, 23229229, 22865673, 20708701, 25079710, 19280225, 21315084
     18840932, 19213447, 18740837, 20294666, 19989009, 18191823, 21517440
     22062517, 19174942, 17319928, 21889720, 19703301, 20122715, 18411216
     20117253, 19258504, 21188532, 24386767, 17890099, 21649497, 16887946
     25264559, 18791688, 19721304, 22092979, 19490948, 19619732, 21164318
     20879709, 20165574, 19272708, 19818513, 19547370, 20139391, 24693382
     20228093, 21281532, 19978542, 22165897, 22359063, 19409212, 19805359
     19461270, 19434529, 18799063, 18990693, 20378086, 21246723, 17008068
     21422580, 21632821, 20831538, 20424899, 22351572, 20361671, 18674024
     19689979, 20235511, 23220453, 19873610, 16619249, 24411921, 20562898
     21091431, 19440586, 22757364, 18610915, 22175564, 19561643, 19399918
     19195895, 20832516, 20017509, 20907061, 21665897, 20746251, 19183343
     21787056, 23096938, 21273804, 19067244, 18043064, 21329301, 18885870
     19536415, 17835294, 25093739, 20446883, 21299490, 24413809, 21744290
     18254023, 20591183, 20413820, 19185876, 22465352, 20558005, 20402832
     19627012, 20093776, 18909599, 20618595, 16863642, 19639483, 19315691
     20331945, 19512341, 21479753, 19637186, 19174521, 19022470, 18607546
     20401975, 18306996, 18851894, 19649152, 20581111, 19201867, 20318889
     20936731, 21060755, 21294938, 20898997, 18510194, 19534363, 19188927



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

OPatch succeeded.

[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch lsinventory

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


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-45-54오전_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-05_08-45-54오전.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2
ARU platform id: 226
ARU platform description:: Linux x86-64

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

Oracle Database 12c                                                  12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


Interim 패치(2):

Patch  25363740     : applied on Fri Feb 02 14:03:28 KST 2018
Unique Patch ID:  20990699
Patch description:  "OCW Patch Set Update : 12.1.0.2.170418 (25363740)"
   Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
   Bugs fixed:
     21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
     20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 21441387
     19028836, 19699720, 19620918, 19168690, 18899171, 17005215, 19244316
     19653795, 18634372, 19471722, 19536337, 19184188, 19131709, 20160490
     20995001, 21131037, 19380733, 20985167, 18943696, 20552947, 19591984
     18135723, 18461246, 20014326, 19524857, 25250824, 18890943, 19154753
     19499021, 25206628, 19046190, 20923930, 20028666, 24451580, 19051385
     19050688, 19682695, 19831611, 22891868, 21607972, 18922918, 21087799
     18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
     18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
     17447588, 19262534, 20752167, 19147513, 22475834, 18893463, 21242118
     19514085, 20758997, 19659885, 19319904, 18703978, 23079844, 24796183
     19700256, 19703246, 20467806, 19192901, 21527118, 19479503, 19147751
     18901356, 21232394, 18964974, 22162062, 18835366, 19013789, 19207286
     18950232, 22583325, 19148791, 19556820, 16505171, 21228405, 22261732
     22135419, 19449737, 21878613, 21646169, 19187515, 19230771, 20795241
     19453778, 19853036, 18843572, 18520351, 21430567, 19185148, 19232454
     21220597, 18541110, 18834955, 19204743, 20175174, 19140891, 18747335
     20676340, 19270660, 19325701, 20877003, 19222693, 19662663, 19684131
     19010177, 19272663, 18910576, 18907170, 19426384, 9372680, 20737462
     19700294, 20289828, 19331454, 22568500, 20278216, 20827053, 20119857
     19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
     19589221, 18952857, 19537762, 21152052, 16286734, 20669114, 18762843
     18945249, 19184799, 19205086, 19351363, 20091753, 19031737, 19079087
     19148367, 18968981, 19150517, 20231741, 19217019, 18730096, 18975620
     19067804, 21259359, 19054979, 19209951, 19318983, 18747382, 19154673
     18752378, 22905714, 19150088, 19013444, 19234177, 18999857, 19075747
     19367276, 19612597, 19874047, 19677813, 23049292, 19427050, 18910443
     20033787, 19148982, 19777496, 20730170, 24362631, 18523468, 19277814
     20562133, 19071526, 21420753, 25537905, 18850051, 20433932, 20061168
     18468128, 19370739, 20822591, 19609388, 18776786, 20136892, 18989446
     19148793, 22904978, 19585454, 18317489, 19955755, 19059053, 19807548
     19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
     22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
     21229744, 19516572, 21474380, 21484367, 20276459, 21550724, 17208793
     19234907, 20007009, 19538714, 22867050, 22728264, 19383028, 19513969
     22195657, 23111368, 19986391, 19314048, 18834934, 19473851, 19458082
     18894342, 19522067, 23618734, 18116578, 19241857, 19076778, 19066699
     25206563, 19068003, 18937186, 20267877, 19916737, 19770543, 22863466
     19635215, 19613533, 21057239, 20783416, 19315522, 19141785, 19163887
     19885321, 25233268, 18715868, 18852058, 19701617, 19280860, 19139608
     21453435, 18946768, 19135521, 18604143, 23150001, 19627476, 20568884
     20317221, 20177779, 19266658, 19491996, 24522717, 18330979, 19027351
     21227730, 18707416, 21118157, 21113068, 19925992, 20235486, 20006646
     15922206, 18439295, 18991776, 21245437, 23170839, 19163425, 19550195
     20389257, 18849021, 18861196, 17940721, 18524834, 19287706, 19522313
     18835283, 18748932, 19184765, 21639478, 14851828, 20598625, 19226141
     19053891, 18871287, 25371730, 18998228, 18980002, 19682778, 19325604
     8934841, 18777835, 17338864, 18945906, 19513650, 19702758, 18952577
     19473088, 19178517, 18729269, 19529729, 19455563, 20877072, 23275930
     20340620, 18536826, 19292605, 22264951, 20920711, 20660273, 20011635
     17592037, 18935857, 22989069, 19029647, 19179158, 22302421, 23076471
     19140712, 20012766, 23049301, 19184276, 25206643, 20510208, 20001507
     20079414, 19680763, 19259765, 18962892, 19513888, 14661880, 21519340
     21222147, 20218012, 19551830, 21616278, 19068333, 18945435, 20775015
     19319192, 20839581, 19178629, 18774591, 21694237, 19304104, 19284357
     22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
     19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
     21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
     21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
     19155350, 19884033, 19146822, 18798432, 21123424, 24356071, 19471836
     20936562, 18750781, 19045143, 20559126, 22483804, 19146980, 19601003
     20099624, 21378016, 19537547, 19281106, 18862203, 19954372, 18235274
     19205617, 19513351, 20219458, 19150313, 18843054, 18708349, 19332386
     18953639, 21423055, 19371270, 25221056, 19203996, 20038431, 19370846
     21053036, 18998379, 20157569, 21357522, 19273577, 24709351, 25206634
     22113170, 19632437, 18990354, 19288396, 20620581, 19557558, 19127078
     22548137, 21792881, 20900588, 20053557, 22088198, 22664609, 19315567
     19444471, 19154933, 20953798, 18290252, 18813323, 19915945, 19500293
     18643483, 19134098, 23034352, 25206614, 18965694, 19226858, 19591356
     19602208, 22884308, 20069197, 18417590, 18920408, 18263259, 18636884
     22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
     19273758, 18953878, 18999195, 24314323, 18759724, 20458032, 19066844
     13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
     20862812, 19504641, 23101611, 19341481, 20293730, 19343245, 18304090
     19241655, 19470791, 18242738, 20649573, 18372060, 18953889, 18827679
     19140711, 19023430, 19259290, 19045388, 20186278, 25197395, 19522571
     19709663, 18875012, 18861564, 21075392, 19273760, 19225265, 15885689
     20853464, 21696068, 18819158, 21394146, 19049721, 19368917, 25206650
     21255373, 22393909, 20408163, 20579351, 18868829, 20350915, 21327402
     22024217, 23101338, 19820247, 25206585, 20363708, 19538241, 19804032

Patch  25171037     : applied on Fri Feb 02 14:03:22 KST 2018
Unique Patch ID:  21099266
Patch description:  "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
   Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
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, 21172913, 19902195, 18250893, 25475853, 17655240, 19383839
     21266085, 19028800, 19035573, 16756406, 19366375, 18456643, 24523374
     19289642, 18845653, 19915271, 21291274, 18417036, 20475845, 22148226
     22528741, 19243521, 19658708, 21153266, 19326908, 19597583, 17414008
     20897759, 19174430, 22046677, 22243719, 24825843, 21960504, 19054077
     22657942, 20688221, 20428621, 21899588, 21387964, 13542050, 19723336
     19835133, 17532734, 19333670, 21373473, 23260854, 19687159, 14643995
     20977794, 20734332, 19012119, 19869255, 17551063, 18681056, 21977392
     23324000, 19676012, 20588502, 19520602, 19841800, 19439759, 20245930
     19303936, 19001359, 21476308, 22916353, 19393542, 23533524, 21099555
     22353346, 19141838, 19644859, 21106027, 21915719, 19908836, 21421886
     22529728, 19358317, 19134173, 19524158, 20447445, 20803014, 23025340
     21188584, 19335438, 19390567, 19058490, 18799993, 19769480, 19475971
     21097043, 21225209, 20677396, 19284031, 19450314, 19016730, 18967382
     20919320, 22075064, 20347562, 20348653, 22551446, 19896336, 24812585
     20048359, 21896069, 22496904, 19524384, 18440095, 16439813, 18354830
     20596234, 20440930, 22022760, 20936905, 19171086, 23197103, 17867700
     19791273, 18990023, 21241829, 19591608, 22296366, 20173897, 17210525
     18914624, 19571367, 21260431, 19501299, 20181030, 25056052, 20425790
     21868720, 19124589, 19402853, 19888853, 16870214, 17722075, 18202441
     18743542, 19001390, 20882568, 25546608, 19081128, 22173980, 21875360
     19178851, 19149990, 20951038, 22168163, 16777441, 25161298, 19606174
     24308635, 20848335, 20569094, 19791377, 19050649, 19382851, 20920911
     20528052, 22762046, 19189525, 19469538, 20598042, 22458049, 18988834
     19176326, 19048007, 22905130, 19238590, 20387265, 16941434, 21263635
     24397438, 20673810, 22160989, 20356733, 22380919, 18499088, 18436647
     21059919, 20825533, 18952989, 19124336, 22294260, 20794034, 19468347
     20284155, 19883092, 20657441, 17365043, 25539063, 21285458, 20952966
     25330273, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
     22083366, 21419850, 20669434, 18964978, 19577410, 21373076, 14283239
     19931709, 20368850, 21239530, 20880215, 20798891, 18122373, 20043616
     23124895, 19013183, 18856999, 21450666, 21133343, 22695831, 18893947
     21196809, 21354456, 19587324, 20464614, 24808595, 22062026, 19189317
     18307021, 21917884, 19708632, 20711718, 20134339, 22077517, 22815955
     24690216, 18973548, 22507210, 20101006, 20250147, 19197175, 23501901
     18797519, 19597439, 21387128, 19180770, 19879746, 19354335, 21785691
     19730508, 22366558, 24285405, 6599380, 21297872, 20322560, 18964939
     22520320, 21575362, 20171986, 22365117, 21542577, 22507234, 23170620
     20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
     19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
     19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
     20471920, 19052488, 22024071, 19503821, 22809871, 20074391, 21184223
     23089357, 19157754, 21220620, 24316947, 18921743, 19865345, 19065677
     19065556, 19018447, 19018206, 19777862, 22223463, 19304354, 20878790
     21322887, 20879889, 20890311, 24350831, 19578350, 20869721, 21142837
     21756699, 20217801, 18819908, 19363645, 25483815, 21072646, 20898391
     19291380, 19593445, 20373598, 19248799, 20031873, 19155797, 19279273
     18886413, 18618122, 25490238, 20922010, 19990037, 20509482, 24739928
     18966843, 19077215, 20703000, 21526048, 20704450, 19068970, 21620471
     19023822, 20543011, 19670108, 19068610, 20267166, 21756677, 20476175
     18549238, 20328248, 18674047, 19385656, 18849537, 19684504, 20315311
     20899461, 19308965, 19143550, 21911701, 19024808, 18948177, 19468991
     20009833, 20868862, 20466628, 21756661, 20397490, 19706965, 22178855
     19604659, 16359751, 19032777, 19329654, 20862087, 19928926, 18974476
     23314180, 20212067, 20603378, 20859910, 19307662, 21847223, 21668627
     20281121, 19075256, 20877664, 19487147, 19076343, 24577566, 19430401
     19676905, 20844426, 20904530, 20925795, 20441797, 21296029, 21629064
     21442094, 23229229, 22865673, 20708701, 25079710, 19280225, 21315084
     18840932, 19213447, 18740837, 20294666, 19989009, 18191823, 21517440
     22062517, 19174942, 17319928, 21889720, 19703301, 20122715, 18411216
     20117253, 19258504, 21188532, 24386767, 17890099, 21649497, 16887946
     25264559, 18791688, 19721304, 22092979, 19490948, 19619732, 21164318
     20879709, 20165574, 19272708, 19818513, 19547370, 20139391, 24693382
     20228093, 21281532, 19978542, 22165897, 22359063, 19409212, 19805359
     19461270, 19434529, 18799063, 18990693, 20378086, 21246723, 17008068
     21422580, 21632821, 20831538, 20424899, 22351572, 20361671, 18674024
     19689979, 20235511, 23220453, 19873610, 16619249, 24411921, 20562898
     21091431, 19440586, 22757364, 18610915, 22175564, 19561643, 19399918
     19195895, 20832516, 20017509, 20907061, 21665897, 20746251, 19183343
     21787056, 23096938, 21273804, 19067244, 18043064, 21329301, 18885870
     19536415, 17835294, 25093739, 20446883, 21299490, 24413809, 21744290
     18254023, 20591183, 20413820, 19185876, 22465352, 20558005, 20402832
     19627012, 20093776, 18909599, 20618595, 16863642, 19639483, 19315691
     20331945, 19512341, 21479753, 19637186, 19174521, 19022470, 18607546
     20401975, 18306996, 18851894, 19649152, 20581111, 19201867, 20318889
     20936731, 21060755, 21294938, 20898997, 18510194, 19534363, 19188927



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

OPatch succeeded.

Database 패치 충돌 여부 검증

oracle 유저로 1번과 2번 노드에 접속하여 양쪽에서 모두 실행합니다.

pass되지 않은 항목이 있다면 oracle에 기술 지원을 요청해야 합니다. (기존 패치의 rollback 등의 작업이 필요할 수 있으므로 반드시 가이드를 받고 진행합니다.)

$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26925263
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 압축 해제 경로>/27010930/26925218

[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-46-36오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-46-44오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-46-50오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-46-58오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Database 패치 디스크 용량 확인

Database 패치를 위해 충분한 디스크 용량이 확보되어 있는지 검사합니다.

적용할 패치 파일의 디렉토리 경로를 텍스트 파일에 저장하고, opatch의 CheckSystemSpace 옵션을 이용하여 디스크 공간을 검사합니다.

vi /tmp/patch_list_dbhome.txt
# cat /tmp/patch_list_dbhome.txt
$DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

[oracle@racdb1 ~]$ vi /tmp/patch_list_dbhome.txt
[oracle@racdb1 ~]$ cat /tmp/patch_list_dbhome.txt
/media/sf_oracle/27010930/26925218
/media/sf_oracle/27010930/26925263
[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-48-02오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

[oracle@racdb2 ~]$ vi /tmp/patch_list_dbhome.txt

[oracle@racdb2 ~]$ cat /tmp/patch_list_dbhome.txt
/media/sf_oracle/27010930/26925218
/media/sf_oracle/27010930/26925263

[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-05_08-48-15오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

자동 패치 : 동시에 Grid 및 DBMS 패치 적용

자동 패치를 수행할 경우 opatchauto 툴을 통해 grid와 database를 동시에 패치할 수 있습니다.

패치 방법은 간단하지만, 패치 과정 중 이슈가 발생하였을 때 분석하기 까다롭습니다.

자동 또는 수동 패치 중에 한가지 방식을 선택하여 패치를 진행하기 바랍니다.

패치 사전 검증

패치를 적용하기 전에 사전 검증하는 단계입니다.

기존 패치와의 충돌 여부와 함께 진행되는 다른 작업들에 이상이 있는지를 사전에 검증합니다.

운영기 적용시에는 가급적 패치를 적용하기 전에 검증을 수행하고 진행하는 것이 좋습니다.

opatchauto apply <패치 압축 해제 경로>/27010930 -analyze

[root@rac1 ~]# opatchauto apply /stage/27010930 -analyze

OPatchauto session is initiated at Mon Feb  5 07:55:31 2018

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-05_07-55-38AM.log.

세션 로그 파일은 /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-05_07-56-24AM.log입니다.
이 세션의 ID는 9V4E입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac1
RAC Home:/u01/app/oracle/product/12.1.0/db_1


==Following patches were SKIPPED:

Patch: /stage/27010930/26910974
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/27010930/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/27010930/26925218
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log

Patch: /stage/27010930/26925263
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log


Host:rac1
CRS Home:/u01/app/12.1.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/27010930/26910974
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log

Patch: /stage/27010930/26925218
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log

Patch: /stage/27010930/26925263
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log

Patch: /stage/27010930/26983807
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_07-56-45오전_1.log



OPatchauto session completed at Mon Feb  5 08:04:16 2018
Time taken to complete the session 8 minutes, 45 seconds

[root@rac2 ~]# opatchauto apply /stage/27010930 -analyze

OPatchauto session is initiated at Mon Feb  5 08:04:35 2018

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-05_08-04-41AM.log.

세션 로그 파일은 /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-05_08-05-04AM.log입니다.
이 세션의 ID는 YIC7입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac2
RAC Home:/u01/app/oracle/product/12.1.0/db_1


==Following patches were SKIPPED:

Patch: /stage/27010930/26910974
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/27010930/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/27010930/26925218
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log

Patch: /stage/27010930/26925263
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log


Host:rac2
CRS Home:/u01/app/12.1.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/27010930/26910974
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log

Patch: /stage/27010930/26925218
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log

Patch: /stage/27010930/26925263
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log

Patch: /stage/27010930/26983807
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_08-05-25오전_1.log



OPatchauto session completed at Mon Feb  5 08:12:08 2018
Time taken to complete the session 7 minutes, 33 seconds

opatchauto 수행하기

root 유저로 실행하며, 한 노드의 작업이 모두 완료된 후에 다른 노드에 작업을 수행합니다.

opatchauto apply <패치 압축 해제 경로>/27010930

1번 노드에서 실패 메시지가 발생할 수 있으나, 무시하고 2번 노드에 패치를 적용합니다.

[root@rac1 ~]# opatchauto apply /media/sf_oracle/27010930

OPatchauto session is initiated at Mon Feb 5 08:49:10 2018

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-05_08-49-47AM.log.

세션 로그 파일은 /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-05_08-50-34AM.log입니다.
이 세션의 ID는 WJNL입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0/db_1 to bring down database service

Bringing down CRS service on home /u01/app/12.1.0/grid
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_rac1_2018-02-05_08-59-39AM.log
CRS service brought down successfully on home /u01/app/12.1.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.1.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1

Start applying binary patch on home /u01/app/oracle/product/12.1.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1

Performing postpatch operation on home /u01/app/oracle/product/12.1.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1

Start applying binary patch on home /u01/app/12.1.0/grid
Binary patch applied successfully on home /u01/app/12.1.0/grid

Starting CRS service on home /u01/app/12.1.0/grid
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_rac1_2018-02-05_09-21-27AM.log
Failed to start CRS service on home /u01/app/12.1.0/grid

[GIStartupAction] 패치 작업 실행을 실패했습니다. 자세한 내용은 로그를 확인하십시오. 실패:
Patch Target : rac1->/u01/app/12.1.0/grid 유형[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.1.0/grid, host: rac1.
Command failed: /u01/app/12.1.0/grid/perl/bin/perl -I/u01/app/12.1.0/grid/perl/lib -I/u01/app/12.1.0/grid/OPatch/auto/dbtmp/bootstrap_rac1/patchwork/crs/install /u01/app/12.1.0/grid/OPatch/auto/dbtmp/bootstrap_rac1/patchwork/crs/install/rootcrs.pl -postpatch
Command failure output:
Using configuration parameter file: /u01/app/12.1.0/grid/OPatch/auto/dbtmp/bootstrap_rac1/patchwork/crs/install/crsconfig_params
2018/02/05 09:21:34 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2018/02/05 09:22:11 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

2018/02/05 09:22:14 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'

CRS-4123: Oracle 고가용성 서비스가 시작되었습니다.
CRS-2791: 'rac1'에서 Oracle 고가용성 서비스가 관리하는 리소스의 종료 시작 중
CRS-2673: 'ora.drivers.acfs'을(를) 'rac1'에서 정지하려고 시도하는 중입니다.
CRS-2677: 'ora.drivers.acfs' 정지('rac1')가 성공했습니다.
CRS-2793: 'rac1'에서 Oracle 고가용성 서비스가 관리하는 리소스 종료가 완료되었습니다.
CRS-4133: Oracle 고가용성 서비스가 정지되었습니다.
CRS-4123: Oracle 고가용성 서비스가 관리하는 리소스를 시작하는 중
CRS-2672: 'ora.mdnsd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2672: 'ora.evmd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.evmd' 시작('rac1')이 성공했습니다.
CRS-2676: 'ora.mdnsd' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.gpnpd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.gpnpd' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.gipcd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.gipcd' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.cssdmonitor'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.cssdmonitor' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.cssd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2672: 'ora.diskmon'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.diskmon' 시작('rac1')이 성공했습니다.
CRS-2676: 'ora.cssd' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.cluster_interconnect.haip'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2672: 'ora.ctssd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.ctssd' 시작('rac1')이 성공했습니다.
CRS-2676: 'ora.cluster_interconnect.haip' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.asm'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.asm' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.storage'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.storage' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.crf'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.crf' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.crsd'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.crsd' 시작('rac1')이 성공했습니다.
CRS-6017: 서버에 대한 리소스 자동 시작을 처리하는 중: rac1
CRS-2672: 'ora.net1.network'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.net1.network' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.ons'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2673: 'ora.rac1.vip'을(를) 'rac2'에서 정지하려고 시도하는 중입니다.
CRS-2677: 'ora.rac1.vip' 정지('rac2')가 성공했습니다.
CRS-2672: 'ora.rac1.vip'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.ons' 시작('rac1')이 성공했습니다.
CRS-2676: 'ora.rac1.vip' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.LISTENER.lsnr'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.LISTENER.lsnr' 시작('rac1')이 성공했습니다.
CRS-2672: 'ora.racdb.db'을(를) 'rac1'에서 시작하려고 시도하는 중입니다.
CRS-2676: 'ora.racdb.db' 시작('rac1')이 성공했습니다.
CRS-6016: rac1 서버에 대한 리소스 자동 시작이 완료되었습니다.
CRS-6024: Oracle Cluster Ready Services가 관리하는 리소스의 시작을 완료했습니다.
CRS-4123: Oracle 고가용성 서비스가 시작되었습니다.
클러스터의 Oracle Clusterware 활성 버전이 [12.1.0.2.0]입니다. 클러스터 업그레이드 상태는 [ROLLING PATCH], 클러스터 활성 패치 레벨은 [3924561976]입니다.
SQL Patching tool version 12.1.0.2.0 Production on Mon Feb 5 09:25:51 2018
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED RAC_SCAN
The following patches will be rolled back:
25171037 (DATABASE PATCH SET UPDATE 12.1.0.2.170418)
The following patches will be applied:
26925263 (DATABASE BUNDLE PATCH 12.1.0.2.180116)

Installing patches...
Patch installation complete. Total patches installed: 6

Validating logfiles...
Patch 25171037 rollback (pdb CDB$ROOT): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_CDBROOT_20182월 05_09_26_45.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_CDBROOT_20182월 05_09_26_45.log
Patch 26925263 apply (pdb CDB$ROOT): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_CDBROOT_20182월 05_09_26_45.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_CDBROOT_20182월 05_09_26_45.log
Patch 25171037 rollback (pdb PDB$SEED): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_PDBSEED_20182월 05_09_29_03.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_PDBSEED_20182월 05_09_29_03.log
Patch 26925263 apply (pdb PDB$SEED): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_PDBSEED_20182월 05_09_29_04.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_PDBSEED_20182월 05_09_29_04.log
Patch 25171037 rollback (pdb RAC_SCAN): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_RAC_SCAN_20182월 05_09_29_03.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_rollback__MGMTDB_RAC_SCAN_20182월 05_09_29_03.log
Patch 26925263 apply (pdb RAC_SCAN): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_RAC_SCAN_20182월 05_09_29_04.log (errors)
Error at line 0: Could not open logfile /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460/26925263_apply__MGMTDB_RAC_SCAN_20182월 05_09_29_04.log

Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17401_2018_02_05_09_25_51/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Mon Feb 5 09:31:59 2018
2018/02/05 09:31:59 CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: 조정 엔진을 실패했습니다.
OPATCHAUTO-68061: 반환 코드 1과(와) 함께 조정 엔진이 실패했습니다.
OPATCHAUTO-68061: 자세한 내용은 로그를 확인하십시오.
OPatchAuto를 실패했습니다.

OPatchauto session completed at Mon Feb 5 09:32:01 2018
Time taken to complete the session 42 minutes, 51 seconds

opatchauto failed with error code 42

[root@rac2 ~]# opatchauto apply /media/sf_oracle/27010930

OPatchauto session is initiated at Mon Feb  5 09:47:28 2018

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-05_09-48-09AM.log.

세션 로그 파일은 /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-05_09-48-31AM.log입니다.
이 세션의 ID는 YXBE입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0/db_1 to bring down database service


Bringing down CRS service on home /u01/app/12.1.0/grid
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_rac2_2018-02-05_09-56-23AM.log
CRS service brought down successfully on home /u01/app/12.1.0/grid


Performing prepatch operation on home /u01/app/oracle/product/12.1.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1


Start applying binary patch on home /u01/app/oracle/product/12.1.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/12.1.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1


Start applying binary patch on home /u01/app/12.1.0/grid
Binary patch applied successfully on home /u01/app/12.1.0/grid


Starting CRS service on home /u01/app/12.1.0/grid
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_rac2_2018-02-05_10-18-11AM.log
CRS service started successfully on home /u01/app/12.1.0/grid


Preparing home /u01/app/oracle/product/12.1.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/db_1
"/bin/sh -c 'cd /u01/app/oracle/product/12.1.0/db_1;ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 ORACLE_SID=racdb2 /u01/app/oracle/product/12.1.0/db_1/OPatch/datapatch -verbose'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command.

SQL patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
RAC Home:/u01/app/oracle/product/12.1.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27010930/26910974
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27010930/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27010930/26925218
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_09-57-29오전_1.log

Patch: /media/sf_oracle/27010930/26925263
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_09-57-29오전_1.log


Host:rac2
CRS Home:/u01/app/12.1.0/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27010930/26910974
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_10-04-54오전_1.log

Patch: /media/sf_oracle/27010930/26925218
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_10-04-54오전_1.log

Patch: /media/sf_oracle/27010930/26925263
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_10-04-54오전_1.log

Patch: /media/sf_oracle/27010930/26983807
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-05_10-04-54오전_1.log



OPatchauto session completed at Mon Feb  5 10:32:17 2018
Time taken to complete the session 44 minutes, 49 seconds

수동 패치 : 개별적으로 Grid와 DBMS에 적용

수동 패치를 수행할 경우 opatch 툴을 통해 grid와 database를 각각 패치하게 됩니다.

단계별로 패치를 진행하게 되므로 이슈가 발생할 경우 트러블슈팅이 덜 까다롭습니다.

자동 또는 수동 패치 중에 한가지 방식을 선택하여 패치를 진행하기 바랍니다.

1번 노드 : 패치 사전 검증

1번 노드에 패치를 적용하기 전에 패치에 대한 사전 검증을 수행합니다.

운영계에 적용하려면 반드시 사전 검증을 통해 패치가 정상 적용이 되는지 확인하고 패치를 진행해야 합니다.

먼저 Grid 패치에 대한 검증을 grid 유저에서 수행합니다.

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local <패치 압축 해제 경로>/27010930/26925218 -analyze
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local <패치 압축 해제 경로>/27010930/26910974 -analyze
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local <패치 압축 해제 경로>/27010930/26983807 -analyze
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local <패치 압축 해제 경로>/27010930/26925263 -analyze

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /stage/27010930/26925218 -analyze

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

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-50-51오전_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26925218

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/12.1.0/grid')

로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26925218' to OH '/u01/app/12.1.0/grid'
Users request no RAC file generation. Do not create MP files.

oracle.crs, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.has.db, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.has.common, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

ApplySession에서 인벤토리 갱신을 건너 뛰는 중입니다.
Patch 26925218 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-50-51오전_1.log

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /stage/27010930/26910974 -analyze

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

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-56-22오전_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26910974

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/12.1.0/grid')

로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26910974' to OH '/u01/app/12.1.0/grid'
Users request no RAC file generation. Do not create MP files.

oracle.usm, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

ApplySession에서 인벤토리 갱신을 건너 뛰는 중입니다.
Patch 26910974 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-56-22오전_1.log

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /stage/27010930/26983807 -analyze

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

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-58-26오전_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26983807

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/12.1.0/grid')

로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26983807' to OH '/u01/app/12.1.0/grid'
Users request no RAC file generation. Do not create MP files.

oracle.wlm.dbwlm, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

ApplySession에서 인벤토리 갱신을 건너 뛰는 중입니다.
Patch 26983807 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_10-58-26오전_1.log

OPatch succeeded.

[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /stage/27010930/26925263 -analyze

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

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-07_11-00-00오전_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 20243804 20415006 20594149 20788771 20950328 21125181 21359749 21527488 21694919 21949015 22806133 23144544 24340679 24732088 25397136 25869760 26609798 26717470 26925263

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/12.1.0/grid')

로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '20243804' to OH '/u01/app/12.1.0/grid'
ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.oraolap, 12.1.0.2.0 ] , [ oracle.xdk, 12.1.0.2.0 ] 이(가) 없거나 상위 버전이 발견되었습니다.
Users request no RAC file generation. Do not create MP files.

oracle.rdbms.deconfig, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.tfa, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.util, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.has.crs, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.has.deconfig, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.xdk.parser.java, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.xdk.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.ctx.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.rman, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.network.client, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.crs, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.nlsrtl.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.rsf.ic, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.ldap.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.ldap.rsf.ic, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

ApplySession에서 인벤토리 갱신을 건너 뛰는 중입니다.
Applying sub-patch '20415006' to OH '/u01/app/12.1.0/grid'
ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.oraolap, 12.1.0.2.0 ] 이(가) 없거나 상위 버전이 발견되었습니다.
Users request no RAC file generation. Do not create MP files.

oracle.network.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.deconfig, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.has.crs, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.hadoopcore, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.rdbms.rman, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

ApplySession에서 인벤토리 갱신을 건너 뛰는 중입니다.
Applying sub-patch '20594149' to OH '/u01/app/12.1.0/grid'
ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.rdbms.dv, 12.1.0.2.0 ] 이(가) 없거나 상위 버전이 발견되었습니다.
Users request no RAC file generation. Do not create MP files.

oracle.tfa, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.

oracle.oracore.rsf, 12.1.0.2.0 구성 요소 및 해당 작업에 대한 패치 적용을 건너 뜁니다.
이 작업은 여기에서 보고되지만 수행되지는 않습니다.