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.GIMR.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 /media/sf_oracle/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.
패치 현황 조사
oracle 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[oracle@rac1 ~]$ $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-21_08-59-47오전_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_08-59-47오전.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 /media/sf_oracle/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-21_09-08-28_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 파일 생성
oracle 유저로 수행
grid_env cd $GRID_HOME/OPatch/ocm/bin ./emocmrsp
[root@rac1 ~]# su - oracle [oracle@rac1 ~]$ grid_env [oracle@rac1 ~]$ cd $GRID_HOME/OPatch/ocm/bin [oracle@rac1 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. [oracle@rac1 bin]$ ls emocmrsp ocm.rsp
Grid 패치 적용
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/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-21_09-17-03_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-21_09-17-03_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.
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 /media/sf_oracle/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.
패치 현황 조회
oracle 유저로 수행
$GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
[oracle@rac2 ~]$ $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-21_10-36-05오전_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_10-36-05오전.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 /media/sf_oracle/24917825 -analyze
[root@rac2 grid]# 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-21_10-37-55_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 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 파일 생성
oracle 유저로 수행
grid_env cd $GRID_HOME/OPatch/ocm/bin ./emocmrsp
[oracle@rac2 ~]$ grid_env [oracle@rac2 ~]$ cd $GRID_HOME/OPatch/ocm/bin [oracle@rac2 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@rac2 bin]$ ls emocmrsp ocm.rsp
Grid 패치 적용
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/24917825 -ocmrf $GRID_HOME/OPatch/ocm/bin/ocm.rsp
[root@rac2 ~]# 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-21_10-43-34_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@rac2 ~]$ $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-21_11-29-13오전_1.log Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_11-29-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개의 제품이 설치되어 있습니다. Interim 패치(4): Patch 24828643 : applied on Fri Apr 21 11:03:43 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 Fri Apr 21 10:57:32 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 Fri Apr 21 10:53:32 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 Fri Apr 21 10:50:41 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 패치
OPatch 업데이트
oracle 유저로 수행
cd $DB_HOME mv OPatch OPatch.old cp -r /media/sf_oracle/OPatch . chown -R oracle:oinstall OPatch OPatch/opatch version
[oracle@rac1 ~]$ cd $DB_HOME [oracle@rac1 db_1]$ mv OPatch OPatch.old [oracle@rac1 db_1]$ cp -r /media/sf_oracle/OPatch . [oracle@rac1 db_1]$ chown -R oracle:oinstall OPatch [oracle@rac1 db_1]$ OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
[oracle@rac2 ~]$ cd $DB_HOME [oracle@rac2 db_1]$ mv OPatch OPatch.old [oracle@rac2 db_1]$ cp -r /media/sf_oracle/OPatch . [oracle@rac2 db_1]$ chown -R oracle:oinstall OPatch [oracle@rac2 db_1]$ OPatch/opatch version OPatch Version: 12.1.0.1.10 OPatch succeeded.
패치 현황 파악
oracle 유저로 수행
db_env cd $DB_HOME/OPatch ./opatch lsinventory -oh $DB_HOME
[oracle@rac1 ~]$ db_env [oracle@rac1 ~]$ cd $DB_HOME/OPatch [oracle@rac1 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-21_11-41-19오전_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_11-41-19오전.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.
패치 사전 분석
oracle 유저로 수행
cd <패치 압축을 해제한 경로>/24732082 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[oracle@rac1 ~]$ cd /media/sf_oracle/24732082 [oracle@rac1 24732082]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.1.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc OPatch version : 12.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-21_12-02-54오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
[oracle@rac2 ~]$ cd /media/sf_oracle/24732082 [oracle@rac2 24732082]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim 패치 설치 프로그램 버전 12.1.0.1.10 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.1.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc OPatch version : 12.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-21_12-06-21오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
DBMS 패치 적용
oracle 유저로 수행
opatch apply
[oracle@rac1 24732082]$ opatch apply 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-21_12-06-59오후_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101 24732082 계속하겠습니까? [y|n] y User Responded with: Y All checks passed. 보안 문제에 대한 알림을 받을 전자 메일 주소를 제공하고 Oracle Configuration Manager를 설치하여 시작하십시오. My Oracle Support 전자 메일 주소/사용자 이름을 사용할 경우 보다 간편하게 작업을 진행할 수 있습니다. 자세한 내용을 확인하려면 http://www.oracle.com/support/policies.html을 방문하십시오. 전자 메일 주소/사용자 이름: 보안 문제에 대한 알림을 받을 전자 메일 주소를 제공하지 않았습니다. 보안 문제에 대한 알림을 받지 않겠습니까(예[Y], 아니오[N]) [N]: y 이 노드는 Oracle Real Application Cluster의 일부입니다. 원격 노드: 'rac2' 로컬 노드: 'rac1' 로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오. (Oracle 홈 = '/u01/app/oracle/product/12.1.0/db_1') 로컬 시스템이 패치할 준비가 되었습니까? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.rdbms.deconfig, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.util, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk.parser.java, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.oraolap, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf.ic, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/db_1' ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.has.crs, 12.1.0.2.0 ] 이(가) 없거나 상위 버전이 발견되었습니다. oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.deconfig, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf.ic, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf.ic, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.oraolap.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.assistants.server, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.rdbms.deconfig, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk.parser.java, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.0/db_1' ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.oid.client, 12.1.0.2.0 ] 이(가) 없거나 상위 버전이 발견되었습니다. oracle.ldap.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.client, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.oraolap, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.oraolap.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.rdbms.dv, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.install.deinstalltool, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ldap.rsf.ic, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.oracore.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ctx, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.nlsrtl.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.xdk.parser.java, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.ctx.atg, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.sqlplus, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.network.listener, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.network.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dv, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.sqlplus.ic, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/db_1' oracle.rdbms.install.plugins, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.tfa, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms, 12.1.0.2.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 12.1.0.2.0 구성 요소를 패치하는 중... 롤링 모드로 패치하는 중입니다. 'rac2' 노드는 다음에 패치됩니다. 'rac2'의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오. (Oracle 홈 = '/u01/app/oracle/product/12.1.0/db_1') 노드가 패치할 준비가 되었습니까? [y|n] y User Responded with: Y Updating nodes 'rac2' Apply-related files are: FP = "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_files.txt" DP = "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_dirs.txt" MP = "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/make_cmds.txt" RC = "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/remote_cmds.txt" Instantiating the file "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_files.txt" with actual path. Propagating files to remote nodes... Instantiating the file "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/copy_dirs.txt" with actual path. Propagating directories to remote nodes... Instantiating the file "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0/db_1/.patch_storage/NApply/2017-04-21_12-06-59오후/rac/make_cmds.txt" with actual path. Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk libasmclntsh12.ohso ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iamdu ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ikfed ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk irman ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iadrci ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjobo ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjob ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iorion ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapmoddn ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapmodifymt ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapcompare ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapbind ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapsearch ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapaddmt ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapmodify ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapdelete ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ldap/lib; /usr/bin/make -f ins_ldap.mk ldapadd ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk patchset_opt_all ioracle ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/ctx/lib; /usr/bin/make -f ins_ctx.mk ictxhx ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/network/lib; /usr/bin/make -f ins_net_server.mk ilsnrctl ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/network/lib; /usr/bin/make -f ins_net_server.mk itnslsnr ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'rac2': cd /u01/app/oracle/product/12.1.0/db_1/sqlplus/lib; /usr/bin/make -f ins_sqlplus.mk genplusso ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 || echo REMOTE_MAKE_FAILED::>&2 'rac2' 노드가 패치되었습니다. 이 노드에서 Oracle 인스턴스를 재시작할 수 있습니다. Finished patching in rolling mode. Composite patch 24732082 successfully applied. Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2017-04-21_12-06-59오후_1.log OPatch succeeded.
패치 결과 확인
oracle 유저로 수행
opatch lsinventory
[oracle@rac1 ~]$ 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-21_12-26-21오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_12-26-21오후.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 패치(1): Patch 24732082 : applied on Fri Apr 21 12:16:20 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.
[oracle@rac2 ~]$ 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-21_12-27-18오후_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-21_12-27-18오후.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 패치(1): Patch 24732082 : applied on Fri Apr 21 12:16:20 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.