1. 패치 전 주의사항
패치 파일을 다운로드 받아 압축을 해제하면 파일 안에 README.html 파일이 존재합니다.
해당 파일에는 패치 방법이나 주의 사항과 관련된 자세한 안내가 기록되어 있습니다.
이를 반드시 읽고 테스트를 한 후에 적용해야 합니다.
2. 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 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.3 OPatch succeeded. [root@rac1 grid]# mv OPatch OPatch.old [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---. 10 grid oinstall 4096 2017-05-01 18:05 OPatch drwxr-xr-x. 7 grid oinstall 4096 2017-05-01 14:36 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-05-01_18-07-31오후_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_18-07-31오후.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 <패치 파일 압축 해제 경로>/25434003 -analyze
[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/25434003 -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/25434003/opatch_gi_2017-05-01_18-09-24_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/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/21436941" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/25434003/25171037" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/25434003/25363740" successfully analyzed on "/u01/app/12.1.0/grid" for apply. Patch "/media/sf_oracle/25434003/25363750" 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,25171037,25363740,25363750 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 <패치 파일 압축 해제 경로>/25434003 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/25434003 -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/25434003/opatch_gi_2017-05-01_18-13-29_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/21436941" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25171037" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25363740" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25363750" 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/25434003/opatch_gi_2017-05-01_18-13-29_deploy.debug.log". Apply Summary: Following patch(es) are successfully installed: GI Home: /u01/app/12.1.0/grid: 21436941,25171037,25363740,25363750 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-05-01_18-31-27오후_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_18-31-27오후.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 Mon May 01 18:23:03 KST 2017
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 Mon May 01 18:21:08 KST 2017
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 Mon May 01 18:19:57 KST 2017
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 17008068, 19908836
21281532, 19238590, 24577566, 21184223, 19134173, 20569094, 20031873
20322560, 20387265, 21575362, 19149990, 21263635, 17551063, 18886413
22160989, 22507210, 19366375, 19703301, 19001390, 24285405, 18202441
20267166, 19358317, 19706965, 19068970, 18549238, 24739928, 18797519
22148226, 20825533, 21196809, 19649152, 19670108, 18940497, 18948177
22496904, 18964978, 19176326, 19035573, 20413820, 19176223, 21106027
20904530, 20134339, 19074147, 20868862, 18411216, 25475853, 21322887
21072646, 22507234, 20425790, 20862087, 18966843, 21329301, 20562898
19333670, 20124446, 19468991, 19883092, 20878790, 18510194, 19658708
19591608, 19402853, 20618595, 21787056, 22380919, 19469538, 21266085
17835294, 19721304, 19068610, 19791377, 22178855, 16777441, 22173980
20048359, 20746251, 21896069, 19185876, 20898391, 20907061, 20281121
6599380, 19577410, 22092979, 19001359, 20603378, 23089357, 21387964
19490948, 22294260, 17532734, 20832516, 22351572, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
20368850, 18973548, 19303936, 21296029, 20882568, 19461270, 21479753
22077517, 20936905, 20235511, 21220620, 18964939, 19430401, 22296366
21153266, 19409212, 20703000, 22657942, 19879746, 20657441, 21294938
19684504, 19024808, 20528052, 24693382, 20977794, 18799993, 20466322
18740837, 19662635, 18440095, 20228093, 19065556, 20212067, 21868720
22905130, 19524384, 24350831, 17722075, 20446883, 25056052, 18952989
24523374, 16870214, 19928926, 19835133, 21629064, 21354456, 20466628
24386767, 25490238, 19931709, 19730508, 18819908, 20250147, 23124895
23220453, 19188927, 20074391, 18307021, 20356733, 14643995, 19065677
19547370, 21960504, 21225209, 20397490, 18967382, 19174430, 21241829
19536415, 19171086, 21889720, 22465352, 22168163, 19335438, 24397438
20447445, 18856999, 19869255, 20471920, 21620471, 23096938, 18990693
19124336, 17890099, 24812585, 18990023, 21300341, 20101006, 20848335
21744290, 20897759, 21668627, 19304354, 20543011, 19052488, 20794034
23025340, 23260854, 18681056, 20952966, 19896336, 25539063, 18618122
20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 22022760
20798891, 18743542, 25161298, 20347562, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21899588, 18899974, 21476308, 20598042
21297872, 24308635, 20171986, 19058490, 19032777, 22815955, 19399918
19434529, 21273804, 19018447, 22757364, 18851894, 19022470, 19284031
18043064, 20173897, 22062026, 20475845, 17274537, 19440586, 18974476
24825843, 22374754, 16887946, 17319928, 20401975, 20708701, 22062517
22809871, 17655240, 16439813, 19805359, 19155797, 20859910, 19393542
22024071, 17210525, 19189525, 21847223, 21649497, 25079710, 19075256
20315311, 22762046, 22075064, 20936731, 18845653, 19280225, 19248799
20560611, 18988834, 21756699, 18921743, 20245930, 18799063, 20373598
19571367, 20476175, 20925795, 19018206, 25264559, 20711718, 20509482
20181030, 20588502, 21911701, 18849537, 23501901, 19183343, 21917884
21142837, 19189317, 19644859, 19390567, 19279273, 20669434, 16863642
22528741, 25546608, 19619732, 18607546, 20348653, 19315691, 19676905
20165574, 17867700, 20558005, 20734332, 19532017, 20922010, 19818513
19450314, 22353346, 16941434, 20361671, 20009833, 22366558, 20294666
18191823, 23197103, 19195895, 19371175, 19307662, 19154375, 20043616
21977392, 18914624, 22529728, 25330273, 20139391, 19593445, 21291274
19382851, 19520602, 19174521, 21875360, 19676012, 19326908, 20217801
20093776, 18840932, 21097043, 21246723, 20803014, 21665897, 19143550
20428621, 19627012, 14283239, 21422580, 19213447, 19518079, 18610915
18674024, 24413809, 18306996, 19915271, 19524158, 20122715, 20284155
20017509, 22359063, 19363645, 19597439, 21239530, 19383839, 20880215
21756677, 19888853, 22458049, 19534363, 19354335, 19044962, 19639483
19475971, 22353199, 22243719, 21060755, 22916353, 20378086, 24808595
21756661, 21260431, 22923409, 19028800, 20877664, 21059919, 20879889
21380789, 19723336, 19077215, 19604659, 21421886, 21285458, 23533524
23170620, 22365117, 18288842, 19048007, 19308965, 19689979, 19503821
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19841800, 19512341
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 19054077
18674047, 19708632, 20898997, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 21419850, 19468347, 21373473, 25093739
16359751, 21164318, 22520320, 19769480, 19439759, 19272708, 19978542
19329654, 20402832, 19873610, 23229229, 13542050, 21517440, 19291380
21915719, 20879709, 20677396, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 19016730, 18250893, 16619249, 18354830, 24411921
16756406, 18254023, 21188584, 19989009, 17414008, 20688221, 20704450
20441797, 25483815, 19157754, 24437510, 18885870, 21785691, 20673810
21450666, 18893947, 18705806, 22223463, 16923858, 18417036, 23314180
20919320, 20474192, 22046677, 21299490, 19501299, 19385656, 20920911
20899461, 21387128, 21315084, 18122373, 20581111, 19606174, 24690216
18436647, 19023822, 19124589, 19178851, 19597583, 18499088, 19050649
Patch 21436941 : applied on Mon May 01 18:18:32 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
3924561976 rac1
--------------------------------------------------------------------------------
OPatch succeeded.
3. 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 grid: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 grid:oinstall OPatch [root@rac2 grid]# ll | grep OPatch drwxr-x---. 10 grid oinstall 4096 2017-05-01 18:32 OPatch drwxr-xr-x. 7 grid oinstall 4096 2017-05-01 14: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-05-01_18-34-47오후_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_18-34-47오후.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 3924561976 rac1 -------------------------------------------------------------------------------- OPatch 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 <패치 파일 압축 해제 경로>/25434003 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/25434003 -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/25434003/opatch_gi_2017-05-01_18-36-31_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/21436941" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25171037" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25363740" successfully applied to "/u01/app/12.1.0/grid". Patch "/media/sf_oracle/25434003/25363750" 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,25171037,25363740,25363750 opatchauto 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-05-01_18-51-25오후_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_18-51-25오후.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 Mon May 01 18:46:00 KST 2017
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 Mon May 01 18:44:01 KST 2017
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 Mon May 01 18:42:41 KST 2017
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 17008068, 19908836
21281532, 19238590, 24577566, 21184223, 19134173, 20569094, 20031873
20322560, 20387265, 21575362, 19149990, 21263635, 17551063, 18886413
22160989, 22507210, 19366375, 19703301, 19001390, 24285405, 18202441
20267166, 19358317, 19706965, 19068970, 18549238, 24739928, 18797519
22148226, 20825533, 21196809, 19649152, 19670108, 18940497, 18948177
22496904, 18964978, 19176326, 19035573, 20413820, 19176223, 21106027
20904530, 20134339, 19074147, 20868862, 18411216, 25475853, 21322887
21072646, 22507234, 20425790, 20862087, 18966843, 21329301, 20562898
19333670, 20124446, 19468991, 19883092, 20878790, 18510194, 19658708
19591608, 19402853, 20618595, 21787056, 22380919, 19469538, 21266085
17835294, 19721304, 19068610, 19791377, 22178855, 16777441, 22173980
20048359, 20746251, 21896069, 19185876, 20898391, 20907061, 20281121
6599380, 19577410, 22092979, 19001359, 20603378, 23089357, 21387964
19490948, 22294260, 17532734, 20832516, 22351572, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
20368850, 18973548, 19303936, 21296029, 20882568, 19461270, 21479753
22077517, 20936905, 20235511, 21220620, 18964939, 19430401, 22296366
21153266, 19409212, 20703000, 22657942, 19879746, 20657441, 21294938
19684504, 19024808, 20528052, 24693382, 20977794, 18799993, 20466322
18740837, 19662635, 18440095, 20228093, 19065556, 20212067, 21868720
22905130, 19524384, 24350831, 17722075, 20446883, 25056052, 18952989
24523374, 16870214, 19928926, 19835133, 21629064, 21354456, 20466628
24386767, 25490238, 19931709, 19730508, 18819908, 20250147, 23124895
23220453, 19188927, 20074391, 18307021, 20356733, 14643995, 19065677
19547370, 21960504, 21225209, 20397490, 18967382, 19174430, 21241829
19536415, 19171086, 21889720, 22465352, 22168163, 19335438, 24397438
20447445, 18856999, 19869255, 20471920, 21620471, 23096938, 18990693
19124336, 17890099, 24812585, 18990023, 21300341, 20101006, 20848335
21744290, 20897759, 21668627, 19304354, 20543011, 19052488, 20794034
23025340, 23260854, 18681056, 20952966, 19896336, 25539063, 18618122
20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 22022760
20798891, 18743542, 25161298, 20347562, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21899588, 18899974, 21476308, 20598042
21297872, 24308635, 20171986, 19058490, 19032777, 22815955, 19399918
19434529, 21273804, 19018447, 22757364, 18851894, 19022470, 19284031
18043064, 20173897, 22062026, 20475845, 17274537, 19440586, 18974476
24825843, 22374754, 16887946, 17319928, 20401975, 20708701, 22062517
22809871, 17655240, 16439813, 19805359, 19155797, 20859910, 19393542
22024071, 17210525, 19189525, 21847223, 21649497, 25079710, 19075256
20315311, 22762046, 22075064, 20936731, 18845653, 19280225, 19248799
20560611, 18988834, 21756699, 18921743, 20245930, 18799063, 20373598
19571367, 20476175, 20925795, 19018206, 25264559, 20711718, 20509482
20181030, 20588502, 21911701, 18849537, 23501901, 19183343, 21917884
21142837, 19189317, 19644859, 19390567, 19279273, 20669434, 16863642
22528741, 25546608, 19619732, 18607546, 20348653, 19315691, 19676905
20165574, 17867700, 20558005, 20734332, 19532017, 20922010, 19818513
19450314, 22353346, 16941434, 20361671, 20009833, 22366558, 20294666
18191823, 23197103, 19195895, 19371175, 19307662, 19154375, 20043616
21977392, 18914624, 22529728, 25330273, 20139391, 19593445, 21291274
19382851, 19520602, 19174521, 21875360, 19676012, 19326908, 20217801
20093776, 18840932, 21097043, 21246723, 20803014, 21665897, 19143550
20428621, 19627012, 14283239, 21422580, 19213447, 19518079, 18610915
18674024, 24413809, 18306996, 19915271, 19524158, 20122715, 20284155
20017509, 22359063, 19363645, 19597439, 21239530, 19383839, 20880215
21756677, 19888853, 22458049, 19534363, 19354335, 19044962, 19639483
19475971, 22353199, 22243719, 21060755, 22916353, 20378086, 24808595
21756661, 21260431, 22923409, 19028800, 20877664, 21059919, 20879889
21380789, 19723336, 19077215, 19604659, 21421886, 21285458, 23533524
23170620, 22365117, 18288842, 19048007, 19308965, 19689979, 19503821
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19841800, 19512341
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 19054077
18674047, 19708632, 20898997, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 21419850, 19468347, 21373473, 25093739
16359751, 21164318, 22520320, 19769480, 19439759, 19272708, 19978542
19329654, 20402832, 19873610, 23229229, 13542050, 21517440, 19291380
21915719, 20879709, 20677396, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 19016730, 18250893, 16619249, 18354830, 24411921
16756406, 18254023, 21188584, 19989009, 17414008, 20688221, 20704450
20441797, 25483815, 19157754, 24437510, 18885870, 21785691, 20673810
21450666, 18893947, 18705806, 22223463, 16923858, 18417036, 23314180
20919320, 20474192, 22046677, 21299490, 19501299, 19385656, 20920911
20899461, 21387128, 21315084, 18122373, 20581111, 19606174, 24690216
18436647, 19023822, 19124589, 19178851, 19597583, 18499088, 19050649
Patch 21436941 : applied on Mon May 01 18:41:10 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
-------------- -----
3924561976 rac1,rac2
--------------------------------------------------------------------------------
OPatch succeeded.
4. MGMTDB 패치
MGMTDB에 datapatch 적용
grid 유저로 한 번만 수행
export ORACLE_SID=-MGMTDB chmod -R 775 /u01/app/oracle/cfgtoollogs/sqlpatch datapatch -verbose
[grid@+ASM1 ~]$ export ORACLE_SID=-MGMTDB
[grid@-MGMTDB ~]$ chmod -R 775 /u01/app/oracle/cfgtoollogs/sqlpatch
[grid@-MGMTDB ~]$ datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Mon May 01 18:41:50 KST 2017
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_1717_2017_05_01_18_41_50/sqlpatch_invocation.log
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
Current state of SQL patches:
Bundle series PSU:
ID 170418 in the binary registry and ID 170418 with errors in PDB CDB$ROOT, ID 170418 with errors in PDB PDB$SEED, ID 170418 with errors in PDB RAC_SCAN
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED RAC_SCAN
Nothing to roll back
The following patches will be applied:
25171037 (DATABASE PATCH SET UPDATE 12.1.0.2.170418)
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...
Patch 25171037 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply__MGMTDB_CDBROOT_2017May01_18_42_15.log (no errors)
Patch 25171037 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply__MGMTDB_PDBSEED_2017May01_18_42_19.log (no errors)
Patch 25171037 apply (pdb RAC_SCAN): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply__MGMTDB_RAC_SCAN_2017May01_18_42_19.log (no errors)
SQL Patching tool complete on Mon May 1 18:42:26 2017
MGMTDB 패치 결과 확인
패치 결과 확인
SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch;
SQL> SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch; PATCH_ID VERSION ACTION STATUS ACTION_TIME ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- 25171037 12.1.0.2 APPLY WITH ERRORS 17/05/01 18:27:01.158861 25171037 12.1.0.2 APPLY SUCCESS 17/05/01 18:42:25.335173
객체 재컴파일
@?/rdbms/admin/utlrp
SQL> @?/rdbms/admin/utlrp
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2017-05-01 18:44:37
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2017-05-01 18:44:41
DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
5. 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-05-01_19-17-16오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_19-17-16오후.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 <패치 파일 압축 해제 경로>/25434003 -analyze -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/25434003 -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/25434003/opatch_gi_2017-05-01_19-19-56_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/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/25171037" successfully analyzed on "/u01/app/oracle/product/12.1.0/db_1" for apply. Patch "/media/sf_oracle/25434003/25363740" 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: 25171037,25363740 opatchauto succeeded.
DBMS 패치 적용
oracle 유저로 수행
$DB_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/25434003 -oh $DB_HOME -ocmrf $DB_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/25434003 -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/25434003/opatch_gi_2017-05-01_19-26-06_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/25171037" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Patch "/media/sf_oracle/25434003/25363740" 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: 25171037,25363740 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-05-01_19-32-35오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_19-32-35오후.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 Mon May 01 19:29:55 KST 2017
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 Mon May 01 19:29:45 KST 2017
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 17008068, 19908836
21281532, 19238590, 24577566, 21184223, 19134173, 20569094, 20031873
20322560, 20387265, 21575362, 19149990, 21263635, 17551063, 18886413
22160989, 22507210, 19366375, 19703301, 19001390, 24285405, 18202441
20267166, 19358317, 19706965, 19068970, 18549238, 24739928, 18797519
22148226, 20825533, 21196809, 19649152, 19670108, 18940497, 18948177
22496904, 18964978, 19176326, 19035573, 20413820, 19176223, 21106027
20904530, 20134339, 19074147, 20868862, 18411216, 25475853, 21322887
21072646, 22507234, 20425790, 20862087, 18966843, 21329301, 20562898
19333670, 20124446, 19468991, 19883092, 20878790, 18510194, 19658708
19591608, 19402853, 20618595, 21787056, 22380919, 19469538, 21266085
17835294, 19721304, 19068610, 19791377, 22178855, 16777441, 22173980
20048359, 20746251, 21896069, 19185876, 20898391, 20907061, 20281121
6599380, 19577410, 22092979, 19001359, 20603378, 23089357, 21387964
19490948, 22294260, 17532734, 20832516, 22351572, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
20368850, 18973548, 19303936, 21296029, 20882568, 19461270, 21479753
22077517, 20936905, 20235511, 21220620, 18964939, 19430401, 22296366
21153266, 19409212, 20703000, 22657942, 19879746, 20657441, 21294938
19684504, 19024808, 20528052, 24693382, 20977794, 18799993, 20466322
18740837, 19662635, 18440095, 20228093, 19065556, 20212067, 21868720
22905130, 19524384, 24350831, 17722075, 20446883, 25056052, 18952989
24523374, 16870214, 19928926, 19835133, 21629064, 21354456, 20466628
24386767, 25490238, 19931709, 19730508, 18819908, 20250147, 23124895
23220453, 19188927, 20074391, 18307021, 20356733, 14643995, 19065677
19547370, 21960504, 21225209, 20397490, 18967382, 19174430, 21241829
19536415, 19171086, 21889720, 22465352, 22168163, 19335438, 24397438
20447445, 18856999, 19869255, 20471920, 21620471, 23096938, 18990693
19124336, 17890099, 24812585, 18990023, 21300341, 20101006, 20848335
21744290, 20897759, 21668627, 19304354, 20543011, 19052488, 20794034
23025340, 23260854, 18681056, 20952966, 19896336, 25539063, 18618122
20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 22022760
20798891, 18743542, 25161298, 20347562, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21899588, 18899974, 21476308, 20598042
21297872, 24308635, 20171986, 19058490, 19032777, 22815955, 19399918
19434529, 21273804, 19018447, 22757364, 18851894, 19022470, 19284031
18043064, 20173897, 22062026, 20475845, 17274537, 19440586, 18974476
24825843, 22374754, 16887946, 17319928, 20401975, 20708701, 22062517
22809871, 17655240, 16439813, 19805359, 19155797, 20859910, 19393542
22024071, 17210525, 19189525, 21847223, 21649497, 25079710, 19075256
20315311, 22762046, 22075064, 20936731, 18845653, 19280225, 19248799
20560611, 18988834, 21756699, 18921743, 20245930, 18799063, 20373598
19571367, 20476175, 20925795, 19018206, 25264559, 20711718, 20509482
20181030, 20588502, 21911701, 18849537, 23501901, 19183343, 21917884
21142837, 19189317, 19644859, 19390567, 19279273, 20669434, 16863642
22528741, 25546608, 19619732, 18607546, 20348653, 19315691, 19676905
20165574, 17867700, 20558005, 20734332, 19532017, 20922010, 19818513
19450314, 22353346, 16941434, 20361671, 20009833, 22366558, 20294666
18191823, 23197103, 19195895, 19371175, 19307662, 19154375, 20043616
21977392, 18914624, 22529728, 25330273, 20139391, 19593445, 21291274
19382851, 19520602, 19174521, 21875360, 19676012, 19326908, 20217801
20093776, 18840932, 21097043, 21246723, 20803014, 21665897, 19143550
20428621, 19627012, 14283239, 21422580, 19213447, 19518079, 18610915
18674024, 24413809, 18306996, 19915271, 19524158, 20122715, 20284155
20017509, 22359063, 19363645, 19597439, 21239530, 19383839, 20880215
21756677, 19888853, 22458049, 19534363, 19354335, 19044962, 19639483
19475971, 22353199, 22243719, 21060755, 22916353, 20378086, 24808595
21756661, 21260431, 22923409, 19028800, 20877664, 21059919, 20879889
21380789, 19723336, 19077215, 19604659, 21421886, 21285458, 23533524
23170620, 22365117, 18288842, 19048007, 19308965, 19689979, 19503821
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19841800, 19512341
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 19054077
18674047, 19708632, 20898997, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 21419850, 19468347, 21373473, 25093739
16359751, 21164318, 22520320, 19769480, 19439759, 19272708, 19978542
19329654, 20402832, 19873610, 23229229, 13542050, 21517440, 19291380
21915719, 20879709, 20677396, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 19016730, 18250893, 16619249, 18354830, 24411921
16756406, 18254023, 21188584, 19989009, 17414008, 20688221, 20704450
20441797, 25483815, 19157754, 24437510, 18885870, 21785691, 20673810
21450666, 18893947, 18705806, 22223463, 16923858, 18417036, 23314180
20919320, 20474192, 22046677, 21299490, 19501299, 19385656, 20920911
20899461, 21387128, 21315084, 18122373, 20581111, 19606174, 24690216
18436647, 19023822, 19124589, 19178851, 19597583, 18499088, 19050649
여러 노드를 구성하는 RAC 시스템
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
6. 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_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-05-01_19-33-48오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_19-33-48오후.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
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/25434003 -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/25434003/opatch_gi_2017-05-01_19-36-06_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /media/sf_oracle/25434003 Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750 DB Patch(es): 25171037 25363740 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/25434003/25171037" successfully applied to "/u01/app/oracle/product/12.1.0/db_1". Patch "/media/sf_oracle/25434003/25363740" 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: 25171037,25363740 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-05-01_19-43-44오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_19-43-44오후.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 Mon May 01 19:39:47 KST 2017
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 Mon May 01 19:39:37 KST 2017
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:
21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
19791273, 21542577, 20951038, 19243521, 22165897, 17008068, 19908836
21281532, 19238590, 24577566, 21184223, 19134173, 20569094, 20031873
20322560, 20387265, 21575362, 19149990, 21263635, 17551063, 18886413
22160989, 22507210, 19366375, 19703301, 19001390, 24285405, 18202441
20267166, 19358317, 19706965, 19068970, 18549238, 24739928, 18797519
22148226, 20825533, 21196809, 19649152, 19670108, 18940497, 18948177
22496904, 18964978, 19176326, 19035573, 20413820, 19176223, 21106027
20904530, 20134339, 19074147, 20868862, 18411216, 25475853, 21322887
21072646, 22507234, 20425790, 20862087, 18966843, 21329301, 20562898
19333670, 20124446, 19468991, 19883092, 20878790, 18510194, 19658708
19591608, 19402853, 20618595, 21787056, 22380919, 19469538, 21266085
17835294, 19721304, 19068610, 19791377, 22178855, 16777441, 22173980
20048359, 20746251, 21896069, 19185876, 20898391, 20907061, 20281121
6599380, 19577410, 22092979, 19001359, 20603378, 23089357, 21387964
19490948, 22294260, 17532734, 20832516, 22351572, 19309466, 20627866
19081128, 20844426, 21188532, 18791688, 20890311, 21442094, 20596234
20368850, 18973548, 19303936, 21296029, 20882568, 19461270, 21479753
22077517, 20936905, 20235511, 21220620, 18964939, 19430401, 22296366
21153266, 19409212, 20703000, 22657942, 19879746, 20657441, 21294938
19684504, 19024808, 20528052, 24693382, 20977794, 18799993, 20466322
18740837, 19662635, 18440095, 20228093, 19065556, 20212067, 21868720
22905130, 19524384, 24350831, 17722075, 20446883, 25056052, 18952989
24523374, 16870214, 19928926, 19835133, 21629064, 21354456, 20466628
24386767, 25490238, 19931709, 19730508, 18819908, 20250147, 23124895
23220453, 19188927, 20074391, 18307021, 20356733, 14643995, 19065677
19547370, 21960504, 21225209, 20397490, 18967382, 19174430, 21241829
19536415, 19171086, 21889720, 22465352, 22168163, 19335438, 24397438
20447445, 18856999, 19869255, 20471920, 21620471, 23096938, 18990693
19124336, 17890099, 24812585, 18990023, 21300341, 20101006, 20848335
21744290, 20897759, 21668627, 19304354, 20543011, 19052488, 20794034
23025340, 23260854, 18681056, 20952966, 19896336, 25539063, 18618122
20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 22022760
20798891, 18743542, 25161298, 20347562, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21899588, 18899974, 21476308, 20598042
21297872, 24308635, 20171986, 19058490, 19032777, 22815955, 19399918
19434529, 21273804, 19018447, 22757364, 18851894, 19022470, 19284031
18043064, 20173897, 22062026, 20475845, 17274537, 19440586, 18974476
24825843, 22374754, 16887946, 17319928, 20401975, 20708701, 22062517
22809871, 17655240, 16439813, 19805359, 19155797, 20859910, 19393542
22024071, 17210525, 19189525, 21847223, 21649497, 25079710, 19075256
20315311, 22762046, 22075064, 20936731, 18845653, 19280225, 19248799
20560611, 18988834, 21756699, 18921743, 20245930, 18799063, 20373598
19571367, 20476175, 20925795, 19018206, 25264559, 20711718, 20509482
20181030, 20588502, 21911701, 18849537, 23501901, 19183343, 21917884
21142837, 19189317, 19644859, 19390567, 19279273, 20669434, 16863642
22528741, 25546608, 19619732, 18607546, 20348653, 19315691, 19676905
20165574, 17867700, 20558005, 20734332, 19532017, 20922010, 19818513
19450314, 22353346, 16941434, 20361671, 20009833, 22366558, 20294666
18191823, 23197103, 19195895, 19371175, 19307662, 19154375, 20043616
21977392, 18914624, 22529728, 25330273, 20139391, 19593445, 21291274
19382851, 19520602, 19174521, 21875360, 19676012, 19326908, 20217801
20093776, 18840932, 21097043, 21246723, 20803014, 21665897, 19143550
20428621, 19627012, 14283239, 21422580, 19213447, 19518079, 18610915
18674024, 24413809, 18306996, 19915271, 19524158, 20122715, 20284155
20017509, 22359063, 19363645, 19597439, 21239530, 19383839, 20880215
21756677, 19888853, 22458049, 19534363, 19354335, 19044962, 19639483
19475971, 22353199, 22243719, 21060755, 22916353, 20378086, 24808595
21756661, 21260431, 22923409, 19028800, 20877664, 21059919, 20879889
21380789, 19723336, 19077215, 19604659, 21421886, 21285458, 23533524
23170620, 22365117, 18288842, 19048007, 19308965, 19689979, 19503821
21526048, 19197175, 19180770, 19902195, 23324000, 20318889, 19013183
20591183, 19012119, 20464614, 19067244, 21632821, 19841800, 19512341
22695831, 20331945, 19587324, 24316947, 19578350, 19637186, 19054077
18674047, 19708632, 20898997, 21091431, 19289642, 21133343, 20869721
21172913, 19258504, 17365043, 21419850, 19468347, 21373473, 25093739
16359751, 21164318, 22520320, 19769480, 19439759, 19272708, 19978542
19329654, 20402832, 19873610, 23229229, 13542050, 21517440, 19291380
21915719, 20879709, 20677396, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 19016730, 18250893, 16619249, 18354830, 24411921
16756406, 18254023, 21188584, 19989009, 17414008, 20688221, 20704450
20441797, 25483815, 19157754, 24437510, 18885870, 21785691, 20673810
21450666, 18893947, 18705806, 22223463, 16923858, 18417036, 23314180
20919320, 20474192, 22046677, 21299490, 19501299, 19385656, 20920911
20899461, 21387128, 21315084, 18122373, 20581111, 19606174, 24690216
18436647, 19023822, 19124589, 19178851, 19597583, 18499088, 19050649
여러 노드를 구성하는 RAC 시스템
Local node = rac2
Remote node = rac1
--------------------------------------------------------------------------------
OPatch succeeded.
1 개의 댓글
사용자-066ff
패치 하는 법이 자세히 나와있네요 ㅎㅎ 감사합니다!