버전 비교

이전 버전 15

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 현재

changes.mady.by.user 윤병훈

에 저장

키

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

...

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

미

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

...

펼치기
서식 미적용
[oracle@orcl ~]$ $ORACLE_HOME/OPatch/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-01-29오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-02-22_17-01-29오후.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  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  27923415     : applied on Thu Jul 19 02:41:38 KST 2018
Unique Patch ID:  22239273
Patch description:  "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"
   Created on 15 Jul 2018, 10:33:22 hrs PST8PDT
   Bugs fixed:
     27304131, 27539876, 27952586, 27642235, 27636900, 27461740

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

Patch  28090523     : applied on Thu Jul 19 02:39:24 KST 2018
Unique Patch ID:  22329768
Patch description:  "Database Release Update : 18.3.0.0.180717 (28090523)"
   Created on 14 Jul 2018, 00:03:50 hrs PST8PDT
   Bugs fixed:
     9062315, 13554903, 21547051, 21766220, 21806121, 23003564, 23310101
     24489904, 24689376, 24737581, 24925863, 25035594, 25035599, 25287072
     25348956, 25634405, 25726981, 25743479, 25824236, 25943740, 26226953
     26336101, 26423085, 26427905, 26450454, 26476244, 26598422, 26615291
     26646549, 26654411, 26731697, 26785169, 26792891, 26818960, 26822620
     26843558, 26843664, 26846077, 26894737, 26898279, 26928317, 26933599
     26956033, 26961415, 26966120, 26986173, 26992964, 27005278, 27026401
     27028251, 27030974, 27036408, 27038986, 27041253, 27044575, 27047831
     27053044, 27058530, 27060167, 27060859, 27061736, 27066451, 27066519
     27073066, 27086821, 27090765, 27101527, 27101652, 27110878, 27112686
     27119621, 27126666, 27128580, 27135647, 27143756, 27143882, 27147979
     27153641, 27155549, 27156355, 27163928, 27169796, 27181521, 27181537
     27189611, 27190851, 27193810, 27199245, 27208953, 27210038, 27210872
     27214085, 27215007, 27216224, 27221900, 27222121, 27222626, 27224987
     27226913, 27232983, 27233563, 27236052, 27236110, 27240246, 27240570
     27241221, 27241247, 27244337, 27244785, 27249215, 27250547, 27254851
     27258578, 27259386, 27259983, 27262650, 27262945, 27263276, 27263996
     27270197, 27274456, 27274536, 27275136, 27275776, 27282707, 27283029
     27283960, 27284499, 27285244, 27288230, 27292213, 27294480, 27301308
     27301568, 27302594, 27302681, 27302695, 27302711, 27302730, 27302777
     27302800, 27302960, 27304410, 27304936, 27305318, 27307868, 27310092
     27313687, 27314206, 27314390, 27318869, 27321179, 27321834, 27326204
     27329812, 27330158, 27330161, 27333658, 27333664, 27333693, 27334316
     27334648, 27335682, 27338912, 27338946, 27339115, 27339396, 27339483
     27339495, 27341036, 27345190, 27345231, 27345450, 27345498, 27346329
     27346644, 27346709, 27346949, 27347126, 27348081, 27348707, 27349393
     27352600, 27354783, 27356373, 27357773, 27358241, 27359178, 27359368
     27360126, 27364891, 27364916, 27364947, 27365139, 27365702, 27365993
     27367194, 27368850, 27372756, 27375260, 27375542, 27376871, 27378103
     27379233, 27381383, 27381656, 27384222, 27389352, 27392187, 27395404
     27395416, 27395794, 27396357, 27396365, 27396377, 27396624, 27396666
     27396672, 27396813, 27398080, 27398660, 27401637, 27405242, 27405696
     27410300, 27410595, 27412805, 27417186, 27420715, 27421101, 27422874
     27423251, 27425507, 27425622, 27426363, 27427805, 27430802, 27432338
     27432355, 27433870, 27434050, 27434193, 27434486, 27434974, 27435537
     27439835, 27441326, 27442041, 27444727, 27445330, 27445462, 27447452
     27447687, 27448162, 27450355, 27450400, 27450783, 27451049, 27451182
     27451187, 27451531, 27452760, 27453225, 27457666, 27457891, 27458164
     27459909, 27460675, 27467543, 27469329, 27471876, 27472969, 27473800
     27479358, 27483974, 27484556, 27486253, 27487795, 27489719, 27496224
     27496308, 27497950, 27498477, 27501327, 27501413, 27501465, 27502420
     27504190, 27505603, 27506774, 27508985, 27511196, 27512439, 27517818
     27518227, 27518310, 27520070, 27520900, 27522245, 27523368, 27523800
     27525909, 27532375, 27533819, 27534509, 27537472, 27544030, 27545630
     27547732, 27550341, 27551855, 27558557, 27558559, 27558861, 27560702
     27563629, 27563767, 27570318, 27577758, 27579353, 27580996, 27585755
     27585800, 27586810, 27586895, 27587672, 27591842, 27592466, 27593389
     27595973, 27599689, 27602091, 27602488, 27603841, 27604293, 27607805
     27608669, 27610269, 27613080, 27613247, 27615608, 27616657, 27617522
     27625274, 27625620, 27631506, 27634676, 27635508, 27644757, 27649707
     27652302, 27663370, 27664702, 27679488, 27679664, 27679806, 27679961
     27680162, 27680509, 27682151, 27688099, 27688692, 27690578, 27691809
     27692215, 27693713, 27697092, 27701795, 27705761, 27707544, 27709046
     27718914, 27719187, 27723002, 27726269, 27726780, 27732323, 27739006
     27740844, 27744211, 27745220, 27747869, 27748954, 27751006, 27753336
     27757567, 27772815, 27773602, 27774320, 27774539, 27779886, 27780562
     27782339, 27783289, 27786772, 27791223, 27797290, 27803665, 27807441
     27812560, 27812593, 27813267, 27815347, 27818871, 27832643, 27833369
     27834984, 27840386, 27847259, 27851757, 27861909, 27869339, 27873643
     27882176, 27892488, 27924147, 27926113, 27930478, 27934468, 27941896
     27945870, 27950708, 27952762, 27961746, 27964051, 27970265, 27971575
     27984028, 27989849, 27993289, 27994333, 27997875, 27999597, 28021205
     28022847, 28033429, 28057267, 28059199, 28072130, 28098865, 28106402
     28132287, 28169711, 28174827, 28184554, 28188330, 25929650, 28264172



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

OPatch succeeded.

Database Release Update

새로 구축되는 환경에서는 database를 생성하기 전에 소프트웨어만 설치된 상태에서 패치하는 것을 권장합니다.

기존에 database가 구성된 상태에서 패치를 수행한다면, 반드시 리스너와 인스턴스를 모두 중지시키고 패치를 진행해야 합니다.

Database Release Update 충돌 여부 검증

...

펼치기
서식 미적용
[oracle@orcl 28822489]$ opatch apply

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-05-46오후_1.log

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

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.

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


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28822489' to OH '/u01/app/oracle/product/18.3.0/db_1'
ApplySession: Oracle 홈에 선택적 구성 요소 [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ] 이(가) 없거나 상위 버전이 발견되었습니다.

oracle.oracore.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.dbjava.jdbc, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.dbjava.ic, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.network.listener, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.assistants.acf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.rsf.ic, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.server, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ctx, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ons, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.deconfig, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.util, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.sdo.locator.jrf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.xdk.parser.java, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.assistants.server, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.crs, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.rman, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.xdk, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ctx.atg, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.dbjava.ucp, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.install.deinstalltool, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.dbscripts, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.xdk.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.network.client, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.install.plugins, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.sdo, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.oci, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ctx.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.oraolap.dbscripts, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.assistants.deconfig, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.nlsrtl.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.precomp.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.network.rsf, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.sqlplus.ic, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.sdo.locator, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.nlsrtl.rsf.core, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.sqlplus, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.javavm.client, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ldap.owm, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.ldap.security.osdt, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.install.common, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.precomp.lang, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.precomp.common, 18.0.0.0.0 구성 요소를 패치하는 중...
Patch 28822489 successfully applied.
Sub-set patch [28090523] has become inactive due to the application of a super-set patch [28822489].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatch/opatch2019-02-22_17-05-46오후_1.log

OPatch succeeded.

...

Database Release Update 적용 결과 확인

코드 블럭
languagebash
titleoracle 유저로 수행
linenumberstrue
opatch lsinventory

...

Oracle JavaVM Component Release Update

기존에 database가 구성된 상태에서 패치를 수행한다면, 반드시 리스너와 인스턴스를 모두 중지시키고 패치를 진행해야 합니다.

Oracle JavaVM Component Release Update 충돌 여부 검증

...

펼치기
서식 미적용
[oracle@orcl 28790647]$ opatch apply

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-18-41오후_1.log

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

계속하겠습니까? [y|n]
y
User Responded with: Y
All checks passed.

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


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28790647' to OH '/u01/app/oracle/product/18.3.0/db_1'

oracle.javavm.server, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.javavm.server.core, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms.dbscripts, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.rdbms, 18.0.0.0.0 구성 요소를 패치하는 중...

oracle.javavm.client, 18.0.0.0.0 구성 요소를 패치하는 중...
Patch 28790647 successfully applied.
Sub-set patch [27923415] has become inactive due to the application of a super-set patch [28790647].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatch/opatch2019-02-22_17-18-41오후_1.log

OPatch succeeded.

Oracle JavaVM Component Release Update 적용 결과 확인

코드 블럭
languagebash
titleoracle 유저로 수행
linenumberstrue
opatch lsinventory
펼치기
서식 미적용
[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

...

펼치기
서식 미적용
[oracle@orcl ~]$ sqlplus /nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Feb 22 18:17:22 2019
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1660940400 bytes
Fixed Size		    8896624 bytes
Variable Size		 1056964608 bytes
Database Buffers	  587202560 bytes
Redo Buffers		    7876608 bytes
Database mounted.
Database opened.

SQL> alter pluggable database all open;

Pluggable database altered.

datapatch 결과 확인

코드 블럭
titlesys 또는 system 계정으로 실행
linenumberstrue
select version_full from v$instance;

...