패치 파일은 오라클을 구매한 고객을 대상으로 제공되는 유료 서비스입니다.
고객지원 사이트(https://support.oracle.com/portal/)를 통해서 등록된 고객만 다운로드 가능하니 참고 바랍니다.
1. 사전 준비
PATH 환경 변수 설정
export PATH=$PATH:/usr/ccs/bin:$ORACLE_HOME/OPatch
[oracle@orcl ~]$ export PATH=$PATH:/usr/ccs/bin:$ORACLE_HOME/OPatch
OPatch 버전 확인
opatch version
[oracle@orcl ~]$ opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded.
작업 전 패치 현황 조사
opatch lsinventory
[oracle@orcl ~]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle 홈: /u01/app/oracle/product/19.0.0/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_08-30-32오전_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-07-19_08-30-32오전.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ol7
ARU platform id: 226
ARU platform description:: Linux x86-64
설치된 최상위 레벨 제품(1):
Oracle Database 19c 19.0.0.0.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.
Interim 패치(2):
Patch 29585399 : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID: 22840393
Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
Bugs fixed:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047
Patch 29517242 : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID: 22862832
Patch description: "Database Release Update : 19.3.0.0.190416 (29517242)"
Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
Bugs fixed:
29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
29521748, 29530812, 29531654, 29557336, 29558975, 29601461
--------------------------------------------------------------------------------
OPatch succeeded.
Database 중지
shutdown immediate
[oracle@orcl ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 19 08:31:12 2019 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
Listener 중지
lsnrctl stop
[oracle@orcl ~]$ lsnrctl stop LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUL-2019 08:32:16 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol7)(PORT=1521))) The command completed successfully
패치 파일 압축 해제
cd <패치 파일 다운로드 경로> unzip p29699079_190000_Linux-x86-64.zip
[oracle@orcl sf_oracle]$ unzip p29699079_190000_Linux-x86-64.zip Archive: p29699079_190000_Linux-x86-64.zip creating: 29699079/ inflating: 29699079/README.html ... < 중략 > ... inflating: PatchSearch.xml
2. OJVM 패치
OJVM 패치 충돌 여부 확인
cd 29699079/29774421 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[oracle@orcl sf_oracle]$ cd 29699079/29774421 [oracle@orcl 29774421]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. PREREQ session Oracle 홈: /u01/app/oracle/product/19.0.0/db_1 중앙 인벤토리: /u01/app/oraInventory 출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc OPatch 버전: 12.2.0.1.17 OUI 버전: 12.2.0.7.0 로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_11-21-44오전_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
OJVM 패치 적용
opatch apply
[oracle@orcl 29774421]$ opatch apply Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle 홈: /u01/app/oracle/product/19.0.0/db_1 중앙 인벤토리: /u01/app/oraInventory 출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc OPatch 버전: 12.2.0.1.17 OUI 버전: 12.2.0.7.0 로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_11-22-16오전_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29774421 계속하겠습니까? [y|n] y User Responded with: Y All checks passed. 로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오. (Oracle 홈 = '/u01/app/oracle/product/19.0.0/db_1') 로컬 시스템이 패치할 준비가 되었습니까? [y|n] y User Responded with: Y Backing up files... OH '/u01/app/oracle/product/19.0.0/db_1'에 Interim 패치 '29774421'을(를) 적용하는 중 oracle.javavm.server, 19.0.0.0.0 구성요소를 패치하는 중... oracle.javavm.server.core, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.dbscripts, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms, 19.0.0.0.0 구성요소를 패치하는 중... Patch 29774421 successfully applied. Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_11-22-16오전_1.log OPatch succeeded.
OJVM 패치 결과 확인
opatch lsinventory
[oracle@orcl 29774421]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle 홈: /u01/app/oracle/product/19.0.0/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_11-24-02오전_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-07-19_11-24-02오전.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ol7
ARU platform id: 226
ARU platform description:: Linux x86-64
설치된 최상위 레벨 제품(1):
Oracle Database 19c 19.0.0.0.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.
Interim 패치(3):
Patch 29774421 : applied on Fri Jul 19 11:22:42 KST 2019
Unique Patch ID: 22965160
Patch description: "OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)"
Created on 11 Jun 2019, 04:07:14 hrs PST8PDT
Bugs fixed:
29540327, 29254623, 29445548, 29774362
Patch 29585399 : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID: 22840393
Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
Bugs fixed:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047
Patch 29517242 : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID: 22862832
Patch description: "Database Release Update : 19.3.0.0.190416 (29517242)"
Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
Bugs fixed:
29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
29521748, 29530812, 29531654, 29557336, 29558975, 29601461
--------------------------------------------------------------------------------
OPatch succeeded.
Upgrade 모드로 database 기동
startup upgrade alter pluggable database all open upgrade;
[oracle@orcl ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 19 11:25:13 2019 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup upgrade ORACLE instance started. Total System Global Area 3154114088 bytes Fixed Size 9139752 bytes Variable Size 671088640 bytes Database Buffers 2466250752 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> alter pluggable database all open upgrade; Pluggable database altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
Database를 생성한 후에 패치하였을 때의 추가 작업
생성된 database에 datapatch 적용
datapatch -verbose
[oracle@orcl ~]$ datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on Fri Jul 19 11:26:12 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5188_2019_07_19_11_26_12/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 29774421 (OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)):
Binary registry: Installed
PDB CDB$ROOT: Not installed
PDB PDB: Not installed
PDB PDB$SEED: Not installed
Current state of release update SQL patches:
Binary registry:
19.3.0.0.0 Release_Update 190410122720: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:47:09.777365
PDB PDB:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:54:48.381831
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:54:48.381831
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
29774421 (OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421))
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 29774421 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29774421/22965160/29774421_apply_ORCL_CDBROOT_2019Jul19_11_26_49.log (no errors)
Patch 29774421 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29774421/22965160/29774421_apply_ORCL_PDBSEED_2019Jul19_11_27_49.log (no errors)
Patch 29774421 apply (pdb PDB): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29774421/22965160/29774421_apply_ORCL_PDB_2019Jul19_11_27_49.log (no errors)
SQL Patching tool complete on Fri Jul 19 11:28:20 2019
3. DBMS 패치
DBMS 패치를 위해 database 중지
shutdown
[oracle@orcl ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 19 11:28:48 2019 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
DBMS 패치 충돌 여부 확인
cd 29699079/29834717 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[oracle@orcl ~]$ cd /media/sf_oracle/29699079/29834717 [oracle@orcl 29834717]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. PREREQ session Oracle 홈: /u01/app/oracle/product/19.0.0/db_1 중앙 인벤토리: /u01/app/oraInventory 출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc OPatch 버전: 12.2.0.1.17 OUI 버전: 12.2.0.7.0 로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_12-22-32오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
DBMS 패치
opatch apply
[oracle@orcl 29834717]$ opatch apply Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle 홈: /u01/app/oracle/product/19.0.0/db_1 중앙 인벤토리: /u01/app/oraInventory 출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc OPatch 버전: 12.2.0.1.17 OUI 버전: 12.2.0.7.0 로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_12-23-09오후_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29834717 계속하겠습니까? [y|n] y User Responded with: Y All checks passed. 로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오. (Oracle 홈 = '/u01/app/oracle/product/19.0.0/db_1') 로컬 시스템이 패치할 준비가 되었습니까? [y|n] y User Responded with: Y Backing up files... OH '/u01/app/oracle/product/19.0.0/db_1'에 Interim 패치 '29834717'을(를) 적용하는 중 ApplySession: Oracle 홈에 선택적 구성요소 [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.nlsrtl.companion, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] 이(가) 없거나 상위 버전이 발견되었습니다. oracle.rdbms.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms, 19.0.0.0.0 구성요소를 패치하는 중... oracle.assistants.acf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.assistants.deconfig, 19.0.0.0.0 구성요소를 패치하는 중... oracle.assistants.server, 19.0.0.0.0 구성요소를 패치하는 중... oracle.buildtools.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ctx, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ldap.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.network.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.dbscripts, 19.0.0.0.0 구성요소를 패치하는 중... oracle.sdo, 19.0.0.0.0 구성요소를 패치하는 중... oracle.sqlplus, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ctx.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.dbdev, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ons, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.util, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.deconfig, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.rman, 19.0.0.0.0 구성요소를 패치하는 중... oracle.odbc, 19.0.0.0.0 구성요소를 패치하는 중... oracle.network.client, 19.0.0.0.0 구성요소를 패치하는 중... oracle.oracore.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.xdk.parser.java, 19.0.0.0.0 구성요소를 패치하는 중... oracle.nlsrtl.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.dbjava.ucp, 19.0.0.0.0 구성요소를 패치하는 중... oracle.dbjava.jdbc, 19.0.0.0.0 구성요소를 패치하는 중... oracle.dbjava.ic, 19.0.0.0.0 구성요소를 패치하는 중... oracle.oraolap.dbscripts, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ldap.security.osdt, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ldap.rsf.ic, 19.0.0.0.0 구성요소를 패치하는 중... oracle.xdk.rsf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.network.listener, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ovm, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ctx.atg, 19.0.0.0.0 구성요소를 패치하는 중... oracle.install.deinstalltool, 19.0.0.0.0 구성요소를 패치하는 중... oracle.duma, 19.0.0.0.0 구성요소를 패치하는 중... oracle.sdo.locator, 19.0.0.0.0 구성요소를 패치하는 중... oracle.sdo.locator.jrf, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.oci, 19.0.0.0.0 구성요소를 패치하는 중... oracle.ldap.owm, 19.0.0.0.0 구성요소를 패치하는 중... oracle.xdk, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.install.plugins, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.dv, 19.0.0.0.0 구성요소를 패치하는 중... oracle.sqlplus.ic, 19.0.0.0.0 구성요소를 패치하는 중... oracle.rdbms.rsf.ic, 19.0.0.0.0 구성요소를 패치하는 중... oracle.precomp.lang, 19.0.0.0.0 구성요소를 패치하는 중... oracle.precomp.common, 19.0.0.0.0 구성요소를 패치하는 중... Patch 29834717 successfully applied. Sub-set patch [29517242] has become inactive due to the application of a super-set patch [29834717]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_12-23-09오후_1.log OPatch succeeded
패치 결과 및 비활성 패치 확인
opatch lsinventory opatch lsinventory -inactive
[oracle@orcl ~]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle 홈: /u01/app/oracle/product/19.0.0/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_12-26-51오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-07-19_12-26-51오후.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ol7
ARU platform id: 226
ARU platform description:: Linux x86-64
설치된 최상위 레벨 제품(1):
Oracle Database 19c 19.0.0.0.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.
Interim 패치(3):
Patch 29834717 : applied on Fri Jul 19 12:24:03 KST 2019
Unique Patch ID: 23016168
Patch description: "Database Release Update : 19.4.0.0.190716 (29834717)"
Created on 10 Jul 2019, 02:09:26 hrs PST8PDT
Bugs fixed:
29850930, 29225758, 29276272, 14735102, 17428816, 19080742, 19697993
20313356, 21374587, 21965541, 23296836, 23606241, 25756945, 25806201
25883179, 25986062, 25997810, 26476244, 26611353, 26739322, 26872233
27126938, 27244999, 27359766, 27369515, 27423500, 27453490, 27666312
27710072, 27846298, 27957203, 28064977, 28072567, 28125947, 28129791
28181021, 28210681, 28271693, 28279456, 28313275, 28326928, 28350595
28371123, 28379065, 28381939, 28390273, 28431445, 28463226, 28475242
28489419, 28502773, 28513333, 28534475, 28547068, 28561704, 28569897
28572533, 28572544, 28572667, 28572834, 28587723, 28593682, 28594086
28597221, 28601957, 28605066, 28606598, 28612239, 28625862, 28627033
28636532, 28643718, 28644549, 28645570, 28646200, 28646939, 28649388
28655209, 28663782, 28673945, 28692275, 28694872, 28696373, 28705231
28710385, 28710734, 28714461, 28715727, 28718469, 28719348, 28720418
28722229, 28730079, 28740708, 28742555, 28749853, 28755011, 28758722
28760206, 28767240, 28772390, 28774416, 28777214, 28781754, 28785531
28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
28815123, 28815355, 28819640, 28824482, 28827682, 28833912, 28835937
28849776, 28854004, 28862532, 28863432, 28867992, 28873575, 28876253
28876639, 28884931, 28888327, 28889730, 28892794, 28897512, 28899663
28901126, 28905457, 28907196, 28912691, 28915561, 28917080, 28918429
28919145, 28922227, 28922532, 28922608, 28925634, 28925880, 28933158
28936114, 28937717, 28938698, 28940179, 28940281, 28941901, 28942455
28945421, 28945994, 28950868, 28951533, 28952168, 28954762, 28955606
28956908, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
28977322, 28983095, 28983486, 28986207, 28986231, 28986326, 28986481
28988482, 28989306, 28993295, 28993353, 28994307, 28996376, 29000000
29001305, 29001888, 29002784, 29002927, 29003738, 29006318, 29006621
29007321, 29007775, 29008035, 29008669, 29009513, 29011936, 29012609
29013475, 29014076, 29015118, 29017265, 29018655, 29019121, 29021063
29021352, 29024054, 29024552, 29024732, 29026582, 29026606, 29027456
29027694, 29027940, 29031575, 29031600, 29032234, 29032276, 29032457
29032607, 29033052, 29033145, 29033200, 29033280, 29034587, 29037290
29038528, 29039089, 29039510, 29040739, 29043554, 29043651, 29043725
29044763, 29044954, 29047850, 29048178, 29048289, 29048498, 29048605
29050357, 29050560, 29050765, 29051702, 29051953, 29052726, 29053783
29056024, 29056270, 29056560, 29056767, 29059011, 29061959, 29062692
29062848, 29062860, 29062868, 29110526, 29110783, 29110790, 29110797
29110802, 29110805, 29111598, 29113282, 29113305, 29117526, 29117642
29119077, 29120223, 29122224, 29122254, 29123297, 29123432, 29123482
29124368, 29125036, 29125374, 29125380, 29126345, 29127957, 29128693
29128935, 29129450, 29129497, 29129712, 29130219, 29131539, 29132938
29134447, 29135383, 29135649, 29136111, 29138641, 29141316, 29141341
29141685, 29142609, 29142667, 29144995, 29145214, 29145730, 29149829
29150338, 29151520, 29152357, 29155099, 29157389, 29158680, 29158899
29159909, 29159936, 29160174, 29162095, 29163156, 29163415, 29163437
29163524, 29163567, 29167111, 29167342, 29167374, 29167940, 29168219
29168433, 29169073, 29169215, 29171683, 29171942, 29172618, 29172826
29173140, 29173373, 29173817, 29174004, 29176318, 29177466, 29177543
29177886, 29178385, 29180313, 29180455, 29180559, 29180893, 29181153
29181231, 29181620, 29181743, 29181923, 29182019, 29183912, 29184297
29184666, 29185193, 29186456, 29189302, 29189307, 29189889, 29190235
29190474, 29190740, 29191541, 29192419, 29192468, 29192685, 29193207
29194205, 29194367, 29194493, 29194827, 29194981, 29195279, 29195337
29195758, 29196725, 29199635, 29199733, 29200316, 29200700, 29201494
29201539, 29202104, 29202850, 29203122, 29203166, 29203425, 29203443
29203604, 29205281, 29205323, 29205419, 29205463, 29205767, 29205918
29206109, 29206605, 29207073, 29208260, 29208732, 29211457, 29211724
29212012, 29212433, 29212611, 29213351, 29213775, 29213850, 29213879
29214561, 29214960, 29216746, 29216984, 29217294, 29217472, 29217828
29217848, 29218570, 29219205, 29219273, 29220079, 29221248, 29221891
29222031, 29222784, 29223833, 29223859, 29223967, 29224065, 29224605
29225076, 29225168, 29227602, 29228869, 29229164, 29229754, 29229844
29229955, 29230252, 29230565, 29231133, 29232117, 29232154, 29233415
29234123, 29237538, 29240307, 29241345, 29241651, 29242017, 29242884
29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
29248495, 29248552, 29248835, 29248858, 29249991, 29250059, 29250317
29251259, 29253184, 29253871, 29254031, 29254930, 29255178, 29255273
29255431, 29255435, 29256426, 29259119, 29259320, 29260452, 29261547
29261906, 29262512, 29262887, 29265448, 29266248, 29266899, 29267292
29268412, 29269171, 29269228, 29270585, 29273539, 29273570, 29273735
29273812, 29273847, 29274428, 29274564, 29274627, 29275461, 29277317
29278218, 29279658, 29279751, 29279854, 29281527, 29281691, 29281796
29282233, 29282898, 29285503, 29285788, 29285956, 29286037, 29287130
29287705, 29292837, 29293072, 29293574, 29297863, 29297915, 29298220
29299049, 29299082, 29299844, 29301463, 29301566, 29302963, 29303918
29304781, 29306226, 29306713, 29311588, 29312310, 29312672, 29312734
29312753, 29313347, 29313417, 29313525, 29314539, 29317756, 29318410
29319441, 29321489, 29323946, 29324568, 29324735, 29325087, 29325105
29325257, 29325765, 29325993, 29327044, 29329042, 29329087, 29329807
29330361, 29331066, 29331209, 29331380, 29331493, 29332292, 29332395
29332771, 29333500, 29336843, 29337310, 29338315, 29338453, 29338780
29338913, 29339101, 29339155, 29341209, 29343086, 29345937, 29346057
29346211, 29346943, 29347620, 29348176, 29350052, 29351386, 29351716
29351735, 29351749, 29352298, 29352724, 29352867, 29352947, 29353271
29353432, 29353960, 29355654, 29356547, 29356704, 29356711, 29356752
29358509, 29358828, 29360285, 29360672, 29360911, 29360950, 29361472
29361801, 29363151, 29364171, 29364177, 29366940, 29367019, 29367561
29368253, 29372541, 29373418, 29373588, 29374179, 29375941, 29376346
29377986, 29378029, 29378834, 29378913, 29379978, 29382784, 29382815
29384781, 29384854, 29384864, 29385429, 29385652, 29386502, 29386635
29386660, 29387073, 29387274, 29388020, 29388072, 29388094, 29388524
29388830, 29389889, 29390011, 29390435, 29390785, 29391030, 29394014
29394140, 29394749, 29395657, 29397954, 29397996, 29398488, 29398863
29399100, 29399121, 29399938, 29402131, 29404483, 29405012, 29405462
29405651, 29405996, 29407804, 29409149, 29410311, 29410834, 29411037
29412066, 29412269, 29417719, 29417884, 29420834, 29421059, 29423826
29424999, 29426241, 29429017, 29429264, 29429566, 29430524, 29431192
29431485, 29434301, 29435474, 29435652, 29436454, 29436514, 29437594
29437712, 29438277, 29438736, 29439522, 29441196, 29443187, 29443250
29444072, 29444282, 29444602, 29446669, 29449477, 29450421, 29451386
29452576, 29452936, 29452953, 29455424, 29457312, 29457370, 29457807
29460252, 29461791, 29462594, 29462767, 29462957, 29464779, 29465177
29467622, 29476473, 29483532, 29483672, 29483685, 29483712, 29486181
29488894, 29489546, 29490256, 29492127, 29492939, 29494245, 29495057
29495684, 29497311, 29500826, 29502561, 29503543, 29503631, 29503827
29504492, 29504682, 29505668, 29507616, 29510278, 29511611, 29514479
29515134, 29515240, 29515766, 29515834, 29516300, 29517168, 29521187
29521748, 29522358, 29522561, 29522662, 29523511, 29525467, 29525886
29527595, 29529147, 29530440, 29530515, 29530812, 29531654, 29541769
29542449, 29543034, 29546817, 29547867, 29548687, 29548722, 29549154
29549730, 29557336, 29558975, 29559187, 29559446, 29559908, 29559981
29565611, 29580983, 29581771, 29584261, 29586143, 29597536, 29597754
29598039, 29598233, 29599300, 29601461, 29604002, 29608000, 29611020
29611991, 29616244, 29616414, 29618074, 29618190, 29622936, 29626732
29628200, 29629650, 29629681, 29631749, 29632095, 29633697, 29635427
29635717, 29637362, 29638285, 29641736, 29653246, 29656819, 29657422
29664087, 29664161, 29670782, 29676089, 29677051, 29677733, 29679856
29687459, 29687763, 29692694, 29695841, 29703932, 29707099, 29742223
29747648, 29751094, 29753244, 29754951, 29756274, 29757651, 29766207
29766503, 29766679, 29775393, 29779196, 29795957, 29838773
Patch 29774421 : applied on Fri Jul 19 11:22:42 KST 2019
Unique Patch ID: 22965160
Patch description: "OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)"
Created on 11 Jun 2019, 04:07:14 hrs PST8PDT
Bugs fixed:
29540327, 29254623, 29445548, 29774362
Patch 29585399 : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID: 22840393
Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
Bugs fixed:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@orcl ~]$ opatch lsinventory -inactive
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle 홈: /u01/app/oracle/product/19.0.0/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2019-07-19_12-28-13오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-07-19_12-28-13오후.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ol7
ARU platform id: 226
ARU platform description:: Linux x86-64
설치된 최상위 레벨 제품(1):
Oracle Database 19c 19.0.0.0.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.
Inactive patches (1) :
Patch 29517242 : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID: 22862832
Patch description: "Database Release Update : 19.3.0.0.190416 (29517242)"
Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
Bugs fixed:
29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
29521748, 29530812, 29531654, 29557336, 29558975, 29601461
--------------------------------------------------------------------------------
OPatch succeeded.
Database 기동
startup alter pluggable database all open;
[oracle@orcl ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 19 12:28:40 2019 Version 19.4.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 3154114088 bytes Fixed Size 9139752 bytes Variable Size 771751936 bytes Database Buffers 2365587456 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> alter pluggable database all open; Pluggable database altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.4.0.0.0
생성된 database에 대하여 datapatch 적용
datapatch -verbose
[oracle@orcl ~]$ datapatch -verbose
SQL Patching tool version 19.4.0.0.0 Production on Fri Jul 19 12:30:09 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_1933_2019_07_19_12_30_09/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 29774421 (OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)):
Binary registry: Installed
PDB CDB$ROOT: Applied successfully on 19/07/19 11:28:19.629218
PDB PDB: Applied successfully on 19/07/19 11:28:19.682900
PDB PDB$SEED: Applied successfully on 19/07/19 11:28:19.653755
Current state of release update SQL patches:
Binary registry:
19.4.0.0.0 Release_Update 190626171128: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:47:09.777365
PDB PDB:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:54:48.381831
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 19/07/19 09:54:48.381831
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB
No interim patches need to be rolled back
Patch 29834717 (Database Release Update : 19.4.0.0.190716 (29834717)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.4.0.0.0 Release_Update 190626171128
No interim patches need to be applied
For the following PDBs: PDB$SEED
No interim patches need to be rolled back
Patch 29834717 (Database Release Update : 19.4.0.0.190716 (29834717)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.4.0.0.0 Release_Update 190626171128
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 29834717 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29834717/23016168/29834717_apply_ORCL_CDBROOT_2019Jul19_12_31_00.log (no errors)
Patch 29834717 apply (pdb PDB): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29834717/23016168/29834717_apply_ORCL_PDB_2019Jul19_12_35_58.log (no errors)
Patch 29834717 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29834717/23016168/29834717_apply_ORCL_PDBSEED_2019Jul19_12_40_56.log (no errors)
SQL Patching tool complete on Fri Jul 19 12:42:05 2019
Database를 생성한 후에 패치하였을 때의 추가 작업
datapatch 결과 확인
select PATCH_ID, PATCH_TYPE, ACTION, STATUS, ACTION_TIME, DESCRIPTION, SOURCE_VERSION, TARGET_VERSION from DBA_REGISTRY_SQLPATCH;
SQL> col STATUS form a10 SQL> col ACTION_TIME form a25 SQL> col DESCRIPTION form a60 SQL> select PATCH_ID, PATCH_TYPE, ACTION, STATUS, ACTION_TIME, DESCRIPTION, SOURCE_VERSION, TARGET_VERSION from DBA_REGISTRY_SQLPATCH; PATCH_ID PATCH_TYPE ACTION STATUS ACTION_TIME DESCRIPTION SOURCE_VERSION TARGET_VERSION ---------- ---------- --------------- ---------- ------------------------- ------------------------------------------------------------ --------------- --------------- 29517242 RU APPLY SUCCESS 19/07/19 09:47:09.777365 Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29774421 INTERIM APPLY SUCCESS 19/07/19 11:28:19.629218 OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421) 19.3.0.0.0 19.3.0.0.0 29834717 RU APPLY SUCCESS 19/07/19 12:41:40.970913 Database Release Update : 19.4.0.0.190716 (29834717) 19.3.0.0.0 19.4.0.0.0
{}
