1. GRID 1번 패치
환경 변수 입력
root 유저로 수행
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
리소스 조회
서비스 상태 조회
$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.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.84.89 10.0.5
.101,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.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
OPatch 업데이트
root 유저로 수행
cd $GRID_HOME OPatch/opatch version mv OPatch OPatch.old cp -r <OPatch 업데이트 압축 해제 경로>/OPatch . chown -R oracle: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.3 OPatch succeeded. [root@rac1 grid]# mv OPatch OPatch.old [root@rac1 grid]# cp -r /media/sf_oracle/OPatch . [root@rac1 grid]# chown -R oracle:oinstall OPatch [root@rac1 grid]# ll | grep OPatch drwxr-x---. 10 oracle oinstall 4096 2017-04-21 08:55 OPatch drwxr-xr-x. 7 oracle oinstall 4096 2017-04-20 21:37 OPatch.old [root@rac1 grid]# OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
패치 현황 조사
grid 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, 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.1.0.1.10 OUI version : 12.1.0.2.0 Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-04-23_19-27-02오후_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_19-27-02오후.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개의 제품이 설치되어 있습니다. 이 Oracle 홈에 설치된 Interim 패치가 없습니다. Patch level status of Cluster nodes : Patching Level Nodes -------------- ----- 0 rac1,rac2 -------------------------------------------------------------------------------- OPatch succeeded.
패치 사전 분석
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -analyze
[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -analyze OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/12.1.0/grid opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_19-27-44_analyze.log NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system. Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful Grid Infrastructure home: /u01/app/12.1.0/grid Analyzing patch(es) on "/u01/app/12.1.0/grid" ... Patch "/media/sf_oracle/24917825/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24732082" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24828633" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24828643" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Apply Summary: Following patch(es) are successfully analyzed: GI Home: /u01/app/12.1.0/grid: 21436941,24732082,24828633,24828643 opatchauto succeeded.
response 파일 생성
grid 유저로 수행
cd $GRID_HOME/OPatch/ocm/bin ./emocmrsp
[root@rac1 ~]# su - grid [grid@+ASM1 ~]$ cd $GRID_HOME/OPatch/ocm/bin [grid@+ASM1 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: Invalid email address. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y The OCM configuration response file (ocm.rsp) was successfully created. [grid@+ASM1 bin]$ ls emocmrsp ocm.rsp
Grid 패치 적용
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/12.1.0/grid opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_19-31-16_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful Grid Infrastructure home: /u01/app/12.1.0/grid Performing prepatch operations on CRS Home... Successful Applying patch(es) to "/u01/app/12.1.0/grid" ... Patch "/media/sf_oracle/24917825/21436941" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24732082" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24828633" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24828643" successfully applied to "/u01/app/12.1.0/grid". Performing postpatch operations on CRS Home... Failed Command "/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/opatchautotemp_rac1/patchwork/crs/install /u01/app/12.1.0/grid/OPatch/opatchautotemp_rac1/patchwork/crs/install/rootcrs.pl -postpatch" execution failed: Died at /u01/app/12.1.0/grid/OPatch/opatchautotemp_rac1/patchwork/crs/install/crspatch.pm line 1028. For more details, please refer to the log file "/u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_19-31-16_deploy.debug.log". Apply Summary: Following patch(es) are successfully installed: GI Home: /u01/app/12.1.0/grid: 21436941,24732082,24828633,24828643 Command failure exception opatchauto failed with error code 2.
패치 결과 조회
grid 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10
Copyright (c) 2017, 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.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-04-23_19-50-05오후_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_19-50-05오후.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 24828643 : applied on Sun Apr 23 19:40:50 KST 2017
Unique Patch ID: 20758350
Patch description: "ACFS Patch Set Update : 12.1.0.2.170117 (24828643)"
Created on 2 Jan 2017, 23:59:16 hrs PST8PDT
Bugs fixed:
19452723, 18900953, 21208140, 19844362, 23639692, 18951113, 19526234
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, 19127216, 20010980
18934139, 22689989, 19335268, 22174238, 21555038, 20681968, 21058846
18851012, 19149476, 20952520, 19526283, 19428756, 19183802, 24760367
19051391, 22846612, 19690653, 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 24828633 : applied on Sun Apr 23 19:38:48 KST 2017
Unique Patch ID: 20758346
Patch description: "OCW Patch Set Update : 12.1.0.2.170117 (24828633)"
Created on 25 Dec 2016, 22:27:14 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, 21607972, 18922918, 21087799, 18956780
19683886, 23757020, 19026993, 20110156, 21269977, 18261648, 18362971
19558324, 22651583, 20185476, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 22475834, 21242118, 19514085, 20758997
19659885, 19319904, 18703978, 23079844, 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
18850051, 20433932, 20061168, 18468128, 19370739, 20822591, 19609388
18776786, 20136892, 18989446, 19148793, 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, 19383028
19513969, 22195657, 23111368, 19986391, 19314048, 18834934, 19473851
19458082, 18894342, 19522067, 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, 18998228, 18980002, 19682778, 19325604, 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, 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
22483804, 19146980, 19601003, 20099624, 21378016, 19537547, 19281106
18862203, 19954372, 18235274, 19205617, 19513351, 20219458, 19150313
18843054, 18708349, 19332386, 18953639, 21423055, 19371270, 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
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 24732082 : applied on Sun Apr 23 19:37:27 KST 2017
Unique Patch ID: 20904347
Patch description: "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Created on 21 Dec 2016, 07:15:01 hrs PST8PDT
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 19908836, 21281532
19238590, 24577566, 21184223, 19134173, 20031873, 20387265, 21575362
19149990, 21263635, 17551063, 18886413, 22160989, 22507210, 19366375
19703301, 19001390, 24285405, 18202441, 20267166, 19358317, 19706965
24739928, 19068970, 18549238, 18797519, 22148226, 20825533, 21196809
19649152, 19670108, 18940497, 18948177, 22496904, 18964978, 19035573
19176326, 20413820, 19176223, 21106027, 20904530, 20134339, 19074147
20868862, 18411216, 21072646, 21322887, 22507234, 20425790, 18966843
21329301, 20562898, 19333670, 20124446, 19468991, 19883092, 18510194
19658708, 19591608, 19402853, 20618595, 21787056, 22380919, 19469538
21266085, 17835294, 19721304, 19791377, 19068610, 22178855, 16777441
22173980, 20048359, 20746251, 21896069, 20898391, 19185876, 20907061
20281121, 6599380, 19577410, 22092979, 19001359, 20603378, 23089357
19490948, 21387964, 22294260, 20832516, 17532734, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
18973548, 21296029, 19303936, 20882568, 19461270, 21479753, 22077517
20936905, 20235511, 21220620, 18964939, 19430401, 22296366, 21153266
19409212, 22657942, 19879746, 20657441, 21294938, 19684504, 24693382
20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
20228093, 20212067, 19065556, 19524384, 17722075, 20446883, 25056052
24523374, 18952989, 16870214, 19928926, 19835133, 21629064, 21354456
20466628, 24386767, 19931709, 19730508, 18819908, 23124895, 23220453
19188927, 20074391, 18307021, 20356733, 14643995, 19547370, 19065677
21960504, 21225209, 20397490, 18967382, 19174430, 21241829, 19536415
19171086, 22465352, 22168163, 19335438, 24397438, 20447445, 18856999
19869255, 20471920, 21620471, 18990693, 17890099, 24812585, 18990023
21300341, 20101006, 20848335, 21744290, 20897759, 21668627, 19304354
19052488, 20794034, 23025340, 23260854, 18681056, 20952966, 19896336
20328248, 18618122, 20440930, 18456643, 19699191, 19201867, 22865673
22022760, 20798891, 18743542, 25161298, 20347562, 19777862, 22551446
19687159, 21373076, 19174942, 20424899, 21899588, 18899974, 21476308
20598042, 24308635, 19032777, 19058490, 22815955, 19399918, 19434529
21273804, 19018447, 22757364, 18851894, 19022470, 19284031, 18043064
20173897, 22062026, 20475845, 17274537, 19440586, 24825843, 18974476
22374754, 16887946, 17319928, 20401975, 20708701, 22809871, 17655240
16439813, 19805359, 19155797, 20859910, 19393542, 17210525, 22024071
21847223, 19189525, 21649497, 19075256, 20315311, 22762046, 22075064
20936731, 19280225, 18845653, 20560611, 19248799, 21756699, 18988834
20245930, 18921743, 18799063, 20373598, 19571367, 20476175, 20925795
25264559, 19018206, 20711718, 20509482, 20181030, 20588502, 18849537
23501901, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
20669434, 22528741, 16863642, 19619732, 18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
19818513, 19450314, 22353346, 20361671, 20009833, 22366558, 20294666
23197103, 18191823, 19195895, 19307662, 19371175, 20043616, 19154375
18914624, 22529728, 20139391, 21291274, 19382851, 19520602, 19174521
21875360, 19676012, 19326908, 20217801, 20093776, 18840932, 21097043
21246723, 20803014, 21665897, 19143550, 20428621, 19627012, 14283239
19518079, 18610915, 18674024, 24413809, 18306996, 19524158, 19915271
20122715, 20284155, 20017509, 22359063, 19363645, 19597439, 21239530
19888853, 21756677, 20880215, 22458049, 19534363, 19354335, 19044962
19639483, 19475971, 22353199, 21060755, 22243719, 22916353, 20378086
24808595, 21260431, 21756661, 22923409, 20877664, 19028800, 21059919
20879889, 21380789, 19723336, 19077215, 19604659, 21421886, 21285458
23533524, 23170620, 22365117, 18288842, 19308965, 19048007, 19689979
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19512341, 19841800
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 18674047
19054077, 20898997, 19708632, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 19468347, 21373473, 16359751, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19873610, 23229229
21517440, 13542050, 19291380, 21915719, 20879709, 20677396, 19076343
19561643, 19990037, 19487147, 18909599, 20831538, 18250893, 19016730
16619249, 18354830, 18254023, 21188584, 19989009, 17414008, 20688221
20704450, 20441797, 19157754, 24437510, 18885870, 21785691, 18893947
21450666, 18705806, 22223463, 16923858, 18417036, 23314180, 20919320
20474192, 22046677, 19385656, 19501299, 20920911, 20899461, 21315084
21387128, 18122373, 20581111, 19606174, 24690216, 18436647, 19023822
19178851, 19124589, 19597583, 18499088, 19050649
Patch 21436941 : applied on Sun Apr 23 19:35:58 KST 2017
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
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
0 rac2
150157942 rac1
--------------------------------------------------------------------------------
OPatch succeeded.
2. GRID 2번 패치
환경 변수 입력
root 유저로 수행
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@rac2 ~]# export ORACLE_BASE=/u01/app/oracle [root@rac2 ~]# export GRID_HOME=/u01/app/12.1.0/grid [root@rac2 ~]# export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
OPatch 업데이트
root 유저로 수행
cd $GRID_HOME OPatch/opatch version mv OPatch OPatch.old cp -r <OPatch 업데이트 압축 해제 경로>/OPatch . chown -R oracle:oinstall OPatch ll | grep OPatch OPatch/opatch version
[root@rac2 ~]# cd $GRID_HOME [root@rac2 grid]# OPatch/opatch version OPatch Version: 12.1.0.1.3 OPatch succeeded. [root@rac2 grid]# mv OPatch OPatch.old [root@rac2 grid]# cp -r /media/sf_oracle/OPatch . [root@rac2 grid]# chown -R oracle:oinstall OPatch [root@rac2 grid]# ll | grep OPatch drwxr-x---. 10 oracle oinstall 4096 2017-04-21 09:34 OPatch drwxr-xr-x. 7 oracle oinstall 4096 2017-04-20 21:40 OPatch.old [root@rac2 grid]# OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
패치 현황 조회
grid 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, 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.1.0.1.10 OUI version : 12.1.0.2.0 Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-04-23_19-27-13오후_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_19-27-13오후.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개의 제품이 설치되어 있습니다. 이 Oracle 홈에 설치된 Interim 패치가 없습니다. Patch level status of Cluster nodes : Patching Level Nodes -------------- ----- 0 rac2 150157942 rac1 -------------------------------------------------------------------------------- OPatch succeeded.
사전 패치 분석
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -analyze
[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -analyze OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/12.1.0/grid opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_19-28-30_analyze.log NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system. Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful Grid Infrastructure home: /u01/app/12.1.0/grid Analyzing patch(es) on "/u01/app/12.1.0/grid" ... Patch "/media/sf_oracle/24917825/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24732082" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24828633" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/24917825/24828643" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Apply Summary: Following patch(es) are successfully analyzed: GI Home: /u01/app/12.1.0/grid: 21436941,24732082,24828633,24828643 opatchauto succeeded.
response 파일 생성
grid 유저로 수행
cd $GRID_HOME/OPatch/ocm/bin ./emocmrsp
[grid@+ASM2 ~]$ cd $GRID_HOME/OPatch/ocm/bin [grid@+ASM2 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y The OCM configuration response file (ocm.rsp) was successfully created. [grid@+ASM2 bin]$ ls emocmrsp ocm.rsp
Grid 패치 적용
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/12.1.0/grid opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_19-50-48_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful Grid Infrastructure home: /u01/app/12.1.0/grid Performing prepatch operations on CRS Home... Successful Applying patch(es) to "/u01/app/12.1.0/grid" ... Patch "/media/sf_oracle/24917825/21436941" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24732082" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24828633" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/24917825/24828643" successfully applied to "/u01/app/12.1.0/grid". Performing postpatch operations on CRS Home... Successful Apply Summary: Following patch(es) are successfully installed: GI Home: /u01/app/12.1.0/grid: 21436941,24732082,24828633,24828643 opatchauto succeeded.
Grid 패치 결과 확인
root 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[oracle@racdb2 ~]$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10
Copyright (c) 2017, 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.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-04-23_20-05-00오후_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_20-05-00오후.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 24828643 : applied on Sun Apr 23 19:59:55 KST 2017
Unique Patch ID: 20758350
Patch description: "ACFS Patch Set Update : 12.1.0.2.170117 (24828643)"
Created on 2 Jan 2017, 23:59:16 hrs PST8PDT
Bugs fixed:
19452723, 18900953, 21208140, 19844362, 23639692, 18951113, 19526234
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, 19127216, 20010980
18934139, 22689989, 19335268, 22174238, 21555038, 20681968, 21058846
18851012, 19149476, 20952520, 19526283, 19428756, 19183802, 24760367
19051391, 22846612, 19690653, 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 24828633 : applied on Sun Apr 23 19:58:04 KST 2017
Unique Patch ID: 20758346
Patch description: "OCW Patch Set Update : 12.1.0.2.170117 (24828633)"
Created on 25 Dec 2016, 22:27:14 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, 21607972, 18922918, 21087799, 18956780
19683886, 23757020, 19026993, 20110156, 21269977, 18261648, 18362971
19558324, 22651583, 20185476, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 22475834, 21242118, 19514085, 20758997
19659885, 19319904, 18703978, 23079844, 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
18850051, 20433932, 20061168, 18468128, 19370739, 20822591, 19609388
18776786, 20136892, 18989446, 19148793, 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, 19383028
19513969, 22195657, 23111368, 19986391, 19314048, 18834934, 19473851
19458082, 18894342, 19522067, 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, 18998228, 18980002, 19682778, 19325604, 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, 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
22483804, 19146980, 19601003, 20099624, 21378016, 19537547, 19281106
18862203, 19954372, 18235274, 19205617, 19513351, 20219458, 19150313
18843054, 18708349, 19332386, 18953639, 21423055, 19371270, 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
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 24732082 : applied on Sun Apr 23 19:56:52 KST 2017
Unique Patch ID: 20904347
Patch description: "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Created on 21 Dec 2016, 07:15:01 hrs PST8PDT
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 19908836, 21281532
19238590, 24577566, 21184223, 19134173, 20031873, 20387265, 21575362
19149990, 21263635, 17551063, 18886413, 22160989, 22507210, 19366375
19703301, 19001390, 24285405, 18202441, 20267166, 19358317, 19706965
24739928, 19068970, 18549238, 18797519, 22148226, 20825533, 21196809
19649152, 19670108, 18940497, 18948177, 22496904, 18964978, 19035573
19176326, 20413820, 19176223, 21106027, 20904530, 20134339, 19074147
20868862, 18411216, 21072646, 21322887, 22507234, 20425790, 18966843
21329301, 20562898, 19333670, 20124446, 19468991, 19883092, 18510194
19658708, 19591608, 19402853, 20618595, 21787056, 22380919, 19469538
21266085, 17835294, 19721304, 19791377, 19068610, 22178855, 16777441
22173980, 20048359, 20746251, 21896069, 20898391, 19185876, 20907061
20281121, 6599380, 19577410, 22092979, 19001359, 20603378, 23089357
19490948, 21387964, 22294260, 20832516, 17532734, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
18973548, 21296029, 19303936, 20882568, 19461270, 21479753, 22077517
20936905, 20235511, 21220620, 18964939, 19430401, 22296366, 21153266
19409212, 22657942, 19879746, 20657441, 21294938, 19684504, 24693382
20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
20228093, 20212067, 19065556, 19524384, 17722075, 20446883, 25056052
24523374, 18952989, 16870214, 19928926, 19835133, 21629064, 21354456
20466628, 24386767, 19931709, 19730508, 18819908, 23124895, 23220453
19188927, 20074391, 18307021, 20356733, 14643995, 19547370, 19065677
21960504, 21225209, 20397490, 18967382, 19174430, 21241829, 19536415
19171086, 22465352, 22168163, 19335438, 24397438, 20447445, 18856999
19869255, 20471920, 21620471, 18990693, 17890099, 24812585, 18990023
21300341, 20101006, 20848335, 21744290, 20897759, 21668627, 19304354
19052488, 20794034, 23025340, 23260854, 18681056, 20952966, 19896336
20328248, 18618122, 20440930, 18456643, 19699191, 19201867, 22865673
22022760, 20798891, 18743542, 25161298, 20347562, 19777862, 22551446
19687159, 21373076, 19174942, 20424899, 21899588, 18899974, 21476308
20598042, 24308635, 19032777, 19058490, 22815955, 19399918, 19434529
21273804, 19018447, 22757364, 18851894, 19022470, 19284031, 18043064
20173897, 22062026, 20475845, 17274537, 19440586, 24825843, 18974476
22374754, 16887946, 17319928, 20401975, 20708701, 22809871, 17655240
16439813, 19805359, 19155797, 20859910, 19393542, 17210525, 22024071
21847223, 19189525, 21649497, 19075256, 20315311, 22762046, 22075064
20936731, 19280225, 18845653, 20560611, 19248799, 21756699, 18988834
20245930, 18921743, 18799063, 20373598, 19571367, 20476175, 20925795
25264559, 19018206, 20711718, 20509482, 20181030, 20588502, 18849537
23501901, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
20669434, 22528741, 16863642, 19619732, 18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
19818513, 19450314, 22353346, 20361671, 20009833, 22366558, 20294666
23197103, 18191823, 19195895, 19307662, 19371175, 20043616, 19154375
18914624, 22529728, 20139391, 21291274, 19382851, 19520602, 19174521
21875360, 19676012, 19326908, 20217801, 20093776, 18840932, 21097043
21246723, 20803014, 21665897, 19143550, 20428621, 19627012, 14283239
19518079, 18610915, 18674024, 24413809, 18306996, 19524158, 19915271
20122715, 20284155, 20017509, 22359063, 19363645, 19597439, 21239530
19888853, 21756677, 20880215, 22458049, 19534363, 19354335, 19044962
19639483, 19475971, 22353199, 21060755, 22243719, 22916353, 20378086
24808595, 21260431, 21756661, 22923409, 20877664, 19028800, 21059919
20879889, 21380789, 19723336, 19077215, 19604659, 21421886, 21285458
23533524, 23170620, 22365117, 18288842, 19308965, 19048007, 19689979
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19512341, 19841800
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 18674047
19054077, 20898997, 19708632, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 19468347, 21373473, 16359751, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19873610, 23229229
21517440, 13542050, 19291380, 21915719, 20879709, 20677396, 19076343
19561643, 19990037, 19487147, 18909599, 20831538, 18250893, 19016730
16619249, 18354830, 18254023, 21188584, 19989009, 17414008, 20688221
20704450, 20441797, 19157754, 24437510, 18885870, 21785691, 18893947
21450666, 18705806, 22223463, 16923858, 18417036, 23314180, 20919320
20474192, 22046677, 19385656, 19501299, 20920911, 20899461, 21315084
21387128, 18122373, 20581111, 19606174, 24690216, 18436647, 19023822
19178851, 19124589, 19597583, 18499088, 19050649
Patch 21436941 : applied on Sun Apr 23 19:55:31 KST 2017
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
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
150157942 rac1,rac2
--------------------------------------------------------------------------------
OPatch succeeded.
3. DBMS 1번 패치
OPatch 업데이트
oracle 유저로 수행
cd $DB_HOME mv OPatch OPatch.old cp -r <OPatch 업데이트 압축 해제 경로>/OPatch . chown -R oracle:oinstall OPatch OPatch/opatch version
[oracle@rac1 ~]$ cd $DB_HOME [oracle@racdb1 db_1]$ mv OPatch OPatch.old [oracle@racdb1 db_1]$ cp -r /media/sf_oracle/OPatch . [oracle@racdb1 db_1]$ chown -R oracle:oinstall OPatch [oracle@racdb1 db_1]$ OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
패치 현황 파악
oracle 유저로 수행
$DB_HOME/OPatch/opatch lsinventory -oh $DB_HOME
[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch lsinventory -oh $DB_HOME Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, 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.1.0.1.10 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-04-23_19-56-28오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_19-56-28오후.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개의 제품이 설치되어 있습니다. 이 Oracle 홈에 설치된 Interim 패치가 없습니다. 여러 노드를 구성하는 RAC 시스템 Local node = rac1 Remote node = rac2 -------------------------------------------------------------------------------- OPatch succeeded.
response 파일 생성
oracle 유저로 수행
cd $DB_HOME/OPatch/ocm/bin ./emocmrsp
[oracle@racdb1 ~]$ cd $DB_HOME/OPatch/ocm/bin [oracle@racdb1 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y The OCM configuration response file (ocm.rsp) was successfully created. [oracle@racdb1 bin]$ ls emocmrsp ocm.rsp
패치 사전 분석
root 유저로 수행
$DB_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -analyze -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -analyze -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/oracle/product/12.1.0/db_1 opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_20-07-16_analyze.log NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system. OCM RSP file has been ignored in analyze mode. Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful User specified the following DB home(s) for this session: /u01/app/oracle/product/12.1.0/db_1 Analyzing patch(es) on "/u01/app/oracle/product/12.1.0/db_1" ... Patch "/media/sf_oracle/24917825/24732082" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply. Patch "/media/sf_oracle/24917825/24828633" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply. [WARNING] The local database(s) on "/u01/app/oracle/product/12.1.0/db_1" is not running. SQL changes, if any, cannot be analyzed. Apply Summary: Following patch(es) are successfully analyzed: DB Home: /u01/app/oracle/product/12.1.0/db_1: 24732082,24828633 opatchauto succeeded.
DBMS 패치 적용
oracle 유저로 수행
$DB_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/oracle/product/12.1.0/db_1 opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_20-24-48_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful User specified the following DB home(s) for this session: /u01/app/oracle/product/12.1.0/db_1 Performing prepatch operations on RAC Home (/u01/app/oracle/product/12.1.0/db_1) ... Successful Applying patch(es) to "/u01/app/oracle/product/12.1.0/db_1" ... Patch "/media/sf_oracle/24917825/24732082" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Patch "/media/sf_oracle/24917825/24828633" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Performing postpatch operations on RAC Home (/u01/app/oracle/product/12.1.0/db_1) ... Successful [WARNING] The local database(s) on "/u01/app/oracle/product/12.1.0/db_1" is not running. SQL changes, if any, cannot be applied. Apply Summary: Following patch(es) are successfully installed: DB Home: /u01/app/oracle/product/12.1.0/db_1: 24732082,24828633 opatchauto succeeded.
패치 결과 확인
oracle 유저로 수행
opatch lsinventory
[oracle@racdb1 ~]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10
Copyright (c) 2017, 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.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-04-23_20-35-55오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_20-35-55오후.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 24828633 : applied on Sun Apr 23 20:28:57 KST 2017
Unique Patch ID: 20758346
Patch description: "OCW Patch Set Update : 12.1.0.2.170117 (24828633)"
Created on 25 Dec 2016, 22:27:14 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, 21607972, 18922918, 21087799, 18956780
19683886, 23757020, 19026993, 20110156, 21269977, 18261648, 18362971
19558324, 22651583, 20185476, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 22475834, 21242118, 19514085, 20758997
19659885, 19319904, 18703978, 23079844, 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
18850051, 20433932, 20061168, 18468128, 19370739, 20822591, 19609388
18776786, 20136892, 18989446, 19148793, 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, 19383028
19513969, 22195657, 23111368, 19986391, 19314048, 18834934, 19473851
19458082, 18894342, 19522067, 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, 18998228, 18980002, 19682778, 19325604, 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, 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
22483804, 19146980, 19601003, 20099624, 21378016, 19537547, 19281106
18862203, 19954372, 18235274, 19205617, 19513351, 20219458, 19150313
18843054, 18708349, 19332386, 18953639, 21423055, 19371270, 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
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 24732082 : applied on Sun Apr 23 20:28:42 KST 2017
Unique Patch ID: 20904347
Patch description: "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Created on 21 Dec 2016, 07:15:01 hrs PST8PDT
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 19908836, 21281532
19238590, 24577566, 21184223, 19134173, 20031873, 20387265, 21575362
19149990, 21263635, 17551063, 18886413, 22160989, 22507210, 19366375
19703301, 19001390, 24285405, 18202441, 20267166, 19358317, 19706965
24739928, 19068970, 18549238, 18797519, 22148226, 20825533, 21196809
19649152, 19670108, 18940497, 18948177, 22496904, 18964978, 19035573
19176326, 20413820, 19176223, 21106027, 20904530, 20134339, 19074147
20868862, 18411216, 21072646, 21322887, 22507234, 20425790, 18966843
21329301, 20562898, 19333670, 20124446, 19468991, 19883092, 18510194
19658708, 19591608, 19402853, 20618595, 21787056, 22380919, 19469538
21266085, 17835294, 19721304, 19791377, 19068610, 22178855, 16777441
22173980, 20048359, 20746251, 21896069, 20898391, 19185876, 20907061
20281121, 6599380, 19577410, 22092979, 19001359, 20603378, 23089357
19490948, 21387964, 22294260, 20832516, 17532734, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
18973548, 21296029, 19303936, 20882568, 19461270, 21479753, 22077517
20936905, 20235511, 21220620, 18964939, 19430401, 22296366, 21153266
19409212, 22657942, 19879746, 20657441, 21294938, 19684504, 24693382
20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
20228093, 20212067, 19065556, 19524384, 17722075, 20446883, 25056052
24523374, 18952989, 16870214, 19928926, 19835133, 21629064, 21354456
20466628, 24386767, 19931709, 19730508, 18819908, 23124895, 23220453
19188927, 20074391, 18307021, 20356733, 14643995, 19547370, 19065677
21960504, 21225209, 20397490, 18967382, 19174430, 21241829, 19536415
19171086, 22465352, 22168163, 19335438, 24397438, 20447445, 18856999
19869255, 20471920, 21620471, 18990693, 17890099, 24812585, 18990023
21300341, 20101006, 20848335, 21744290, 20897759, 21668627, 19304354
19052488, 20794034, 23025340, 23260854, 18681056, 20952966, 19896336
20328248, 18618122, 20440930, 18456643, 19699191, 19201867, 22865673
22022760, 20798891, 18743542, 25161298, 20347562, 19777862, 22551446
19687159, 21373076, 19174942, 20424899, 21899588, 18899974, 21476308
20598042, 24308635, 19032777, 19058490, 22815955, 19399918, 19434529
21273804, 19018447, 22757364, 18851894, 19022470, 19284031, 18043064
20173897, 22062026, 20475845, 17274537, 19440586, 24825843, 18974476
22374754, 16887946, 17319928, 20401975, 20708701, 22809871, 17655240
16439813, 19805359, 19155797, 20859910, 19393542, 17210525, 22024071
21847223, 19189525, 21649497, 19075256, 20315311, 22762046, 22075064
20936731, 19280225, 18845653, 20560611, 19248799, 21756699, 18988834
20245930, 18921743, 18799063, 20373598, 19571367, 20476175, 20925795
25264559, 19018206, 20711718, 20509482, 20181030, 20588502, 18849537
23501901, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
20669434, 22528741, 16863642, 19619732, 18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
19818513, 19450314, 22353346, 20361671, 20009833, 22366558, 20294666
23197103, 18191823, 19195895, 19307662, 19371175, 20043616, 19154375
18914624, 22529728, 20139391, 21291274, 19382851, 19520602, 19174521
21875360, 19676012, 19326908, 20217801, 20093776, 18840932, 21097043
21246723, 20803014, 21665897, 19143550, 20428621, 19627012, 14283239
19518079, 18610915, 18674024, 24413809, 18306996, 19524158, 19915271
20122715, 20284155, 20017509, 22359063, 19363645, 19597439, 21239530
19888853, 21756677, 20880215, 22458049, 19534363, 19354335, 19044962
19639483, 19475971, 22353199, 21060755, 22243719, 22916353, 20378086
24808595, 21260431, 21756661, 22923409, 20877664, 19028800, 21059919
20879889, 21380789, 19723336, 19077215, 19604659, 21421886, 21285458
23533524, 23170620, 22365117, 18288842, 19308965, 19048007, 19689979
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19512341, 19841800
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 18674047
19054077, 20898997, 19708632, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 19468347, 21373473, 16359751, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19873610, 23229229
21517440, 13542050, 19291380, 21915719, 20879709, 20677396, 19076343
19561643, 19990037, 19487147, 18909599, 20831538, 18250893, 19016730
16619249, 18354830, 18254023, 21188584, 19989009, 17414008, 20688221
20704450, 20441797, 19157754, 24437510, 18885870, 21785691, 18893947
21450666, 18705806, 22223463, 16923858, 18417036, 23314180, 20919320
20474192, 22046677, 19385656, 19501299, 20920911, 20899461, 21315084
21387128, 18122373, 20581111, 19606174, 24690216, 18436647, 19023822
19178851, 19124589, 19597583, 18499088, 19050649
여러 노드를 구성하는 RAC 시스템
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
4. DBMS 2번 패치
OPatch 업데이트
oracle 유저로 수행
cd $DB_HOME mv OPatch OPatch.old cp -r <OPatch 업데이트 압축 해제 경로>/OPatch . chown -R oracle:oinstall OPatch OPatch/opatch version
[oracle@racdb2 ~]$ cd $DB_HOME [oracle@racdb2 db_1]$ mv OPatch OPatch.old [oracle@racdb2 db_1]$ cp -r /media/sf_oracle/OPatch . [oracle@racdb2 db_1]$ chown -R oracle:oinstall OPatch [oracle@racdb2 db_1]$ OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
패치 현황 파악
oracle 유저로 수행
$DB_HOME/OPatch/opatch lsinventory -oh $DB_HOME
[oracle@racdb2 db_1]$ $DB_HOME/OPatch/opatch lsinventory -oh $DB_HOME Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, 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.1.0.1.10 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-04-23_20-37-26오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_20-37-26오후.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개의 제품이 설치되어 있습니다. 이 Oracle 홈에 설치된 Interim 패치가 없습니다. 여러 노드를 구성하는 RAC 시스템 Local node = rac2 Remote node = rac1 -------------------------------------------------------------------------------- OPatch succeeded.
response 파일 생성
oracle 유저로 수행
cd $DB_HOME/OPatch/ocm/bin ./emocmrsp
[oracle@racdb2 ~]$ cd $DB_HOME/OPatch/ocm/bin [oracle@racdb2 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y The OCM configuration response file (ocm.rsp) was successfully created. [oracle@racdb2 bin]$ ls emocmrsp ocm.rsp
패치 사전 분석
root 유저로 수행
$DB_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -analyze -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -analyze -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/oracle/product/12.1.0/db_1 opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_20-38-12_analyze.log NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system. OCM RSP file has been ignored in analyze mode. Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful User specified the following DB home(s) for this session: /u01/app/oracle/product/12.1.0/db_1 Analyzing patch(es) on "/u01/app/oracle/product/12.1.0/db_1" ... Patch "/media/sf_oracle/24917825/24732082" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply. Patch "/media/sf_oracle/24917825/24828633" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply. [WARNING] The local database(s) on "/u01/app/oracle/product/12.1.0/db_1" is not running. SQL changes, if any, cannot be analyzed. Apply Summary: Following patch(es) are successfully analyzed: DB Home: /u01/app/oracle/product/12.1.0/db_1: 24732082,24828633 opatchauto succeeded.
DBMS 패치 적용
oracle 유저로 수행
$DB_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/24917825 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /u01/app/oracle/product/12.1.0/db_1 opatchauto log file: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/24917825/opatch_gi_2017-04-23_20-50-23_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/24917825 Grid Infrastructure Patch(es): 21436941 24732082 24828633 24828643 DB Patch(es): 24732082 24828633 Patch Validation: Successful User specified the following DB home(s) for this session: /u01/app/oracle/product/12.1.0/db_1 Performing prepatch operations on RAC Home (/u01/app/oracle/product/12.1.0/db_1) ... Successful Applying patch(es) to "/u01/app/oracle/product/12.1.0/db_1" ... Patch "/media/sf_oracle/24917825/24732082" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Patch "/media/sf_oracle/24917825/24828633" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Performing postpatch operations on RAC Home (/u01/app/oracle/product/12.1.0/db_1) ... Successful [WARNING] The local database(s) on "/u01/app/oracle/product/12.1.0/db_1" is not running. SQL changes, if any, cannot be applied. Apply Summary: Following patch(es) are successfully installed: DB Home: /u01/app/oracle/product/12.1.0/db_1: 24732082,24828633 opatchauto succeeded.
패치 결과 확인
oracle 유저로 수행
opatch lsinventory
[oracle@racdb2 ~]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10
Copyright (c) 2017, 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.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-04-23_20-56-28오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-23_20-56-28오후.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 24828633 : applied on Sun Apr 23 20:54:40 KST 2017
Unique Patch ID: 20758346
Patch description: "OCW Patch Set Update : 12.1.0.2.170117 (24828633)"
Created on 25 Dec 2016, 22:27:14 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, 21607972, 18922918, 21087799, 18956780
19683886, 23757020, 19026993, 20110156, 21269977, 18261648, 18362971
19558324, 22651583, 20185476, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 22475834, 21242118, 19514085, 20758997
19659885, 19319904, 18703978, 23079844, 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
18850051, 20433932, 20061168, 18468128, 19370739, 20822591, 19609388
18776786, 20136892, 18989446, 19148793, 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, 19383028
19513969, 22195657, 23111368, 19986391, 19314048, 18834934, 19473851
19458082, 18894342, 19522067, 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, 18998228, 18980002, 19682778, 19325604, 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, 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
22483804, 19146980, 19601003, 20099624, 21378016, 19537547, 19281106
18862203, 19954372, 18235274, 19205617, 19513351, 20219458, 19150313
18843054, 18708349, 19332386, 18953639, 21423055, 19371270, 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
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 24732082 : applied on Sun Apr 23 20:54:17 KST 2017
Unique Patch ID: 20904347
Patch description: "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Created on 21 Dec 2016, 07:15:01 hrs PST8PDT
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 19908836, 21281532
19238590, 24577566, 21184223, 19134173, 20031873, 20387265, 21575362
19149990, 21263635, 17551063, 18886413, 22160989, 22507210, 19366375
19703301, 19001390, 24285405, 18202441, 20267166, 19358317, 19706965
24739928, 19068970, 18549238, 18797519, 22148226, 20825533, 21196809
19649152, 19670108, 18940497, 18948177, 22496904, 18964978, 19035573
19176326, 20413820, 19176223, 21106027, 20904530, 20134339, 19074147
20868862, 18411216, 21072646, 21322887, 22507234, 20425790, 18966843
21329301, 20562898, 19333670, 20124446, 19468991, 19883092, 18510194
19658708, 19591608, 19402853, 20618595, 21787056, 22380919, 19469538
21266085, 17835294, 19721304, 19791377, 19068610, 22178855, 16777441
22173980, 20048359, 20746251, 21896069, 20898391, 19185876, 20907061
20281121, 6599380, 19577410, 22092979, 19001359, 20603378, 23089357
19490948, 21387964, 22294260, 20832516, 17532734, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
18973548, 21296029, 19303936, 20882568, 19461270, 21479753, 22077517
20936905, 20235511, 21220620, 18964939, 19430401, 22296366, 21153266
19409212, 22657942, 19879746, 20657441, 21294938, 19684504, 24693382
20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
20228093, 20212067, 19065556, 19524384, 17722075, 20446883, 25056052
24523374, 18952989, 16870214, 19928926, 19835133, 21629064, 21354456
20466628, 24386767, 19931709, 19730508, 18819908, 23124895, 23220453
19188927, 20074391, 18307021, 20356733, 14643995, 19547370, 19065677
21960504, 21225209, 20397490, 18967382, 19174430, 21241829, 19536415
19171086, 22465352, 22168163, 19335438, 24397438, 20447445, 18856999
19869255, 20471920, 21620471, 18990693, 17890099, 24812585, 18990023
21300341, 20101006, 20848335, 21744290, 20897759, 21668627, 19304354
19052488, 20794034, 23025340, 23260854, 18681056, 20952966, 19896336
20328248, 18618122, 20440930, 18456643, 19699191, 19201867, 22865673
22022760, 20798891, 18743542, 25161298, 20347562, 19777862, 22551446
19687159, 21373076, 19174942, 20424899, 21899588, 18899974, 21476308
20598042, 24308635, 19032777, 19058490, 22815955, 19399918, 19434529
21273804, 19018447, 22757364, 18851894, 19022470, 19284031, 18043064
20173897, 22062026, 20475845, 17274537, 19440586, 24825843, 18974476
22374754, 16887946, 17319928, 20401975, 20708701, 22809871, 17655240
16439813, 19805359, 19155797, 20859910, 19393542, 17210525, 22024071
21847223, 19189525, 21649497, 19075256, 20315311, 22762046, 22075064
20936731, 19280225, 18845653, 20560611, 19248799, 21756699, 18988834
20245930, 18921743, 18799063, 20373598, 19571367, 20476175, 20925795
25264559, 19018206, 20711718, 20509482, 20181030, 20588502, 18849537
23501901, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
20669434, 22528741, 16863642, 19619732, 18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
19818513, 19450314, 22353346, 20361671, 20009833, 22366558, 20294666
23197103, 18191823, 19195895, 19307662, 19371175, 20043616, 19154375
18914624, 22529728, 20139391, 21291274, 19382851, 19520602, 19174521
21875360, 19676012, 19326908, 20217801, 20093776, 18840932, 21097043
21246723, 20803014, 21665897, 19143550, 20428621, 19627012, 14283239
19518079, 18610915, 18674024, 24413809, 18306996, 19524158, 19915271
20122715, 20284155, 20017509, 22359063, 19363645, 19597439, 21239530
19888853, 21756677, 20880215, 22458049, 19534363, 19354335, 19044962
19639483, 19475971, 22353199, 21060755, 22243719, 22916353, 20378086
24808595, 21260431, 21756661, 22923409, 20877664, 19028800, 21059919
20879889, 21380789, 19723336, 19077215, 19604659, 21421886, 21285458
23533524, 23170620, 22365117, 18288842, 19308965, 19048007, 19689979
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19512341, 19841800
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 18674047
19054077, 20898997, 19708632, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 19468347, 21373473, 16359751, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19873610, 23229229
21517440, 13542050, 19291380, 21915719, 20879709, 20677396, 19076343
19561643, 19990037, 19487147, 18909599, 20831538, 18250893, 19016730
16619249, 18354830, 18254023, 21188584, 19989009, 17414008, 20688221
20704450, 20441797, 19157754, 24437510, 18885870, 21785691, 18893947
21450666, 18705806, 22223463, 16923858, 18417036, 23314180, 20919320
20474192, 22046677, 19385656, 19501299, 20920911, 20899461, 21315084
21387128, 18122373, 20581111, 19606174, 24690216, 18436647, 19023822
19178851, 19124589, 19597583, 18499088, 19050649
여러 노드를 구성하는 RAC 시스템
Local node = rac2
Remote node = rac1
--------------------------------------------------------------------------------
OPatch succeeded.
