버전 비교

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

...

코드 블럭
languagebash
titleoracle 유저로 수행
export PATH=$PATH:/usr/ccs/bin
펼치기

서식 미적용
[oracle@orcl ~]$ export PATH=$PATH:/usr/ccs/bin

...

펼치기
서식 미적용
[oracle@orcl ~]$ opatch lsinventory

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


Oracle Home       : /u01/app/oracle/product/18.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/18.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.2.0.4.0
Log file location : /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatch/opatch2019-02-22_17-21-25오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-02-22_17-21-25오후.txt

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

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

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


Interim 패치(4):

Patch  28790647     : applied on Fri Feb 22 17:19:38 KST 2019
Unique Patch ID:  22592236
Patch description:  "OJVM RELEASE UPDATE: 18.5.0.0.190115 (28790647)"
   Created on 25 Nov 2018, 22:46:28 hrs PST8PDT
   Bugs fixed:
     27304131, 27539876, 27952586, 27642235, 27636900, 27461740, 28278547
     28278640, 27936676, 28502098, 28915870, 28601874

Patch  28822489     : applied on Fri Feb 22 17:08:58 KST 2019
Unique Patch ID:  22669539
Patch description:  "Database Release Update : 18.5.0.0.190115 (28822489)"
   Created on 18 Dec 2018, 22:44:52 hrs PST8PDT
   Bugs fixed:
     8932139, 9062315, 13554903, 14221306, 20436508, 21095391, 21547051
     21744603, 21766220, 21806121, 23003564, 23061453, 23310101, 23761724
     24489904, 24689376, 24737581, 24903291, 24925863, 24971597, 25035594
     25035599, 25287072, 25303284, 25309116, 25348956, 25487146, 25591292
     25607397, 25634405, 25644811, 25686739, 25726981, 25736428, 25743479
     25824236, 25882883, 25890002, 25911069, 25929650, 25943740, 25958554
     26083489, 26115103, 26226953, 26297826, 26336101, 26399691, 26422277
     26423085, 26427905, 26450454, 26476244, 26521043, 26536320, 26598422
     26615291, 26646549, 26654411, 26694735, 26731697, 26745002, 26785169
     26792891, 26818960, 26822620, 26843558, 26843664, 26846077, 26883456
     26894737, 26895149, 26898279, 26928317, 26933599, 26956033, 26960097
     26961415, 26966120, 26966916, 26986173, 26992964, 27005278, 27006664
     27026401, 27028251, 27030974, 27035653, 27036408, 27037839, 27038986
     27041253, 27044575, 27047831, 27053044, 27054231, 27058530, 27060167
     27060859, 27061736, 27066451, 27066519, 27073066, 27075854, 27080874
     27086821, 27090765, 27093423, 27101527, 27101652, 27106301, 27110878
     27111780, 27112686, 27119621, 27122162, 27125872, 27126666, 27128580
     27135647, 27142529, 27143756, 27143882, 27147979, 27150500, 27151826
     27152892, 27153641, 27155549, 27156355, 27160360, 27163928, 27164352
     27165231, 27166354, 27169796, 27169888, 27170305, 27179264, 27181521
     27181537, 27181897, 27189611, 27190851, 27193810, 27197334, 27199245
     27200959, 27208953, 27210038, 27210263, 27210872, 27214085, 27215007
     27216224, 27220937, 27221900, 27222121, 27222626, 27223075, 27224987
     27226913, 27228786, 27229389, 27231051, 27232983, 27233563, 27236052
     27236110, 27236722, 27240246, 27240570, 27241221, 27241247, 27242616
     27244337, 27244785, 27249215, 27250547, 27251690, 27254851, 27255377
     27256000, 27256488, 27256534, 27256584, 27258578, 27259307, 27259386
     27259983, 27262601, 27262650, 27262798, 27262945, 27262991, 27263276
     27263996, 27266245, 27270197, 27274456, 27274536, 27275136, 27275776
     27276231, 27282707, 27283029, 27283960, 27284375, 27284499, 27285244
     27288230, 27288894, 27292213, 27293599, 27294480, 27301308, 27301568
     27302594, 27302632, 27302681, 27302695, 27302711, 27302714, 27302730
     27302777, 27302800, 27302960, 27303785, 27303938, 27304410, 27304936
     27305318, 27307868, 27310092, 27313687, 27314206, 27314390, 27318869
     27320576, 27321179, 27321834, 27326204, 27329812, 27330158, 27330161
     27333658, 27333664, 27333693, 27333731, 27334316, 27334648, 27335682
     27338912, 27338946, 27339115, 27339396, 27339483, 27339495, 27341036
     27345190, 27345231, 27345450, 27345498, 27346329, 27346644, 27346709
     27346949, 27347126, 27348081, 27348707, 27349393, 27350267, 27351628
     27352600, 27354783, 27356373, 27357773, 27358241, 27359178, 27359368
     27360126, 27364891, 27364916, 27364947, 27365139, 27365702, 27365993
     27367194, 27368850, 27372756, 27375260, 27375542, 27376871, 27378103
     27379233, 27381383, 27381498, 27381656, 27384222, 27386467, 27389352
     27392187, 27394086, 27395404, 27395416, 27395794, 27396357, 27396365
     27396377, 27396624, 27396666, 27396672, 27396813, 27397048, 27398080
     27398660, 27400416, 27400598, 27401637, 27404668, 27405242, 27405645
     27405696, 27410279, 27410300, 27410595, 27412805, 27416327, 27416997
     27417186, 27420715, 27421101, 27421733, 27422874, 27423251, 27425507
     27425622, 27426363, 27427805, 27430802, 27432338, 27432355, 27433870
     27434050, 27434193, 27434486, 27434974, 27435537, 27439835, 27441326
     27441980, 27442041, 27444727, 27445330, 27445462, 27445727, 27447452
     27447687, 27448162, 27449814, 27450355, 27450400, 27450783, 27451049
     27451182, 27451187, 27451531, 27452046, 27452760, 27453225, 27454722
     27457666, 27457891, 27458164, 27459909, 27460675, 27462994, 27466597
     27467543, 27469245, 27469329, 27471876, 27472969, 27473800, 27479358
     27480784, 27483974, 27484556, 27486253, 27487795, 27489719, 27493674
     27496224, 27496308, 27497950, 27498477, 27501327, 27501413, 27501465
     27502420, 27504190, 27504770, 27505229, 27505603, 27506774, 27508985
     27510959, 27511196, 27512439, 27517818, 27518227, 27518310, 27520070
     27520900, 27522245, 27523368, 27523800, 27525909, 27532375, 27533819
     27534509, 27537472, 27540613, 27544030, 27544973, 27545630, 27547732
     27550341, 27551855, 27555481, 27558557, 27558559, 27558861, 27560602
     27560702, 27563629, 27563767, 27567477, 27570318, 27577758, 27578007
     27579353, 27580996, 27585755, 27585800, 27586810, 27586895, 27587672
     27591842, 27592466, 27593389, 27593501, 27593585, 27595973, 27599689
     27599927, 27601118, 27602091, 27602488, 27603841, 27604293, 27607563
     27607805, 27608669, 27610269, 27613080, 27613247, 27613530, 27615608
     27616657, 27617522, 27617978, 27620808, 27623844, 27625274, 27625620
     27631506, 27634676, 27635508, 27644757, 27645940, 27649707, 27652302
     27654521, 27658186, 27658205, 27662528, 27663370, 27664702, 27679488
     27679664, 27679806, 27679961, 27680162, 27680509, 27680669, 27682151
     27688036, 27688099, 27688692, 27690513, 27690578, 27691809, 27691920
     27691939, 27692215, 27693713, 27694261, 27695063, 27697092, 27698953
     27700466, 27701795, 27705761, 27707544, 27709046, 27718914, 27719187
     27723002, 27723151, 27726269, 27726780, 27732323, 27733415, 27739006
     27740424, 27740844, 27744211, 27745220, 27747869, 27748954, 27751006
     27753336, 27756900, 27757567, 27757794, 27757888, 27759077, 27759457
     27761402, 27766324, 27767081, 27772093, 27772815, 27773602, 27774320
     27774539, 27779886, 27780562, 27782339, 27783289, 27786772, 27791223
     27793533, 27797290, 27801337, 27803665, 27807441, 27810967, 27812560
     27812593, 27813267, 27815347, 27818871, 27825241, 27832643, 27833369
     27834984, 27835925, 27840386, 27843646, 27847259, 27849825, 27851757
     27861452, 27861909, 27869075, 27869339, 27873643, 27876671, 27882176
     27892488, 27896443, 27898015, 27918832, 27924147, 27926113, 27930478
     27931299, 27934468, 27940876, 27941896, 27945870, 27948050, 27948153
     27950708, 27952762, 27960021, 27961746, 27964051, 27965830, 27970265
     27971503, 27971575, 27975778, 27977039, 27983174, 27984028, 27989849
     27993289, 27994325, 27994333, 27995248, 27997875, 27998003, 27999597
     27999638, 28000269, 28004853, 28018962, 28021205, 28022101, 28022847
     28023081, 28023482, 28024347, 28033429, 28036487, 28057267, 28059199
     28067846, 28072130, 28072567, 28074713, 28085865, 28088762, 28090453
     28091981, 28098865, 28103600, 28104361, 28106402, 28108898, 28111583
     28120951, 28132287, 28165545, 28169711, 28174827, 28174951, 28180464
     28184554, 28187706, 28188330, 28194173, 28209341, 28210192, 28211734
     28214943, 28215510, 28218832, 28226179, 28227512, 28229360, 28238264
     28258608, 28264172, 28281094, 28282606, 28285766, 28290434, 28302049
     28304709, 28305001, 28305362, 28309182, 28312508, 28315995, 28319623
     28320117, 28320399, 28321446, 28328895, 28330714, 28338399, 28338999
     28344964, 28354603, 28361221, 28361787, 28365111, 28369092, 28385102
     28390273, 28391582, 28392168, 28393678, 28396445, 28403295, 28413955
     28420042, 28420457, 28434028, 28445741, 28455212, 28475164, 28478676
     28481679, 28483184, 28489150, 28492362, 28493478, 28502403, 28503484
     28504545, 28508053, 28508296, 28508557, 28514693, 28527416, 28528349
     28535272, 28544633, 28545687, 28553468, 28571483, 28580528, 28584193
     28584444, 28614072, 28617959, 28621470, 28627255, 28636676, 28670445
     28673203, 28679454, 28685371, 28695694, 28708023, 28713840, 28714058
     28728272, 28749289, 28752599, 28755011, 28758090, 28785022, 28805612
     28805695, 28809909, 28919145, 28960211, 28993590

Patch  27908644     : applied on Thu Jul 19 02:44:11 KST 2018
Unique Patch ID:  22153180
Patch description:  "UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171"
   Created on 4 May 2018, 01:21:02 hrs PST8PDT
   Bugs fixed:
     27908644

Patch  28090553     : applied on Thu Jul 19 02:40:01 KST 2018
Unique Patch ID:  22256940
Patch description:  "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"
   Created on 11 Jul 2018, 19:20:31 hrs PST8PDT
   Bugs fixed:
     12816839, 18701017, 22734786, 23698980, 23840305, 25709124, 25724089
     26299684, 26313403, 26433972, 26527054, 26586174, 26587652, 26647619
     26827699, 26860285, 26882126, 26882316, 26943660, 26996813, 27012915
     27018734, 27032726, 27034318, 27040560, 27080748, 27086406, 27092991
     27098733, 27106915, 27114112, 27121566, 27133637, 27144533, 27153755
     27166715, 27174938, 27174948, 27177551, 27177852, 27182006, 27182064
     27184253, 27204476, 27212837, 27213140, 27220610, 27222423, 27222938
     27238077, 27238258, 27249544, 27252023, 27257509, 27263677, 27265816
     27267992, 27271876, 27274143, 27285557, 27299455, 27300007, 27302415
     27309182, 27314512, 27315159, 27320985, 27334353, 27338838, 27346984
     27358232, 27362190, 27370933, 27377219, 27378959, 27379846, 27379956
     27393421, 27398223, 27399499, 27399762, 27399985, 27401618, 27403244
     27404599, 27426277, 27428790, 27430219, 27430254, 27433163, 27452897
     27458829, 27465480, 27475272, 27481406, 27481765, 27492916, 27496806
     27503318, 27503413, 27508936, 27508984, 27513114, 27519708, 27526362
     27528204, 27532009, 27534289, 27560562, 27560735, 27573154, 27573408
     27574335, 27577122, 27579969, 27581484, 27593587, 27595801, 27600706
     27609819, 27625010, 27625050, 27627992, 27654039, 27657467, 27657920
     27668379, 27682288, 27691717, 27702244, 27703242, 27708711, 27714373
     27725967, 27731346, 27734470, 27735534, 27739957, 27740854, 27747407
     27748321, 27757979, 27766679, 27768034, 27778433, 27782464, 27783059
     27786669, 27786699, 27801774, 27811439, 27839732, 27850736, 27862636
     27864737, 27865439, 27889841, 27896388, 27897639, 27906509, 27931506
     27935826, 27941514, 27957892, 27978668, 27984314, 27993298, 28023410
     28025398, 28032758, 28039471, 28039953, 28045209, 28099592, 28109698
     28174926, 28182503, 28204423, 28240153



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

OPatch succeeded.

수정된 SQL 파일을 Database에 적재

Database 소프트웨어를 새로 구축되는 환경에서 database 소프트웨어만 설치하고 database를 생성하지 않은 경우에는 해당이 이 과정이 필요 없습니다.

Database 기동

코드 블럭
titleoracle 유저로 수행
linenumberstrue
sqlplus /nolog
connect / as sysdba

...