개요
오라클에서 패치 정보를 확인하기 위한 방법으로 opatch 유틸리티를 통한 확인이 가능합니다.
또한 오라클에서는 패치 정보를 조회 할 수 있는 view 도 제공하고있습니다.
이에 대한 조회 스크립트를 문서로 남겨봅니다.
Patch 정보 확인
opatch 유틸리티를 통한 조회
명령문 : opatch lsinventory
ora19c:admin/ > opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/19c/db
Central Inventory : /oracle/oraInventory
from : /oracle/product/19c/db/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /oracle/product/19c/db/cfgtoollogs/opatch/opatch2023-05-23_01-23-48AM_1.log
Lsinventory Output file location : /oracle/product/19c/db/cfgtoollogs/opatch/lsinv/lsinventory2023-05-23_01-23-48AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora19c
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 34786990 : applied on Fri Mar 17 03:50:16 EDT 2023
Unique Patch ID: 25032666
Patch description: "OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)"
Created on 6 Dec 2022, 13:24:50 hrs UTC
Bugs fixed:
29445548, 29254623, 29540327, 29774362, 30134746, 30160625, 30534662
29512125, 29942275, 30855101, 31306261, 31359215, 30895577, 29224710
26716835, 31668872, 32165759, 32069696, 32032733, 30889443, 30674373
32167592, 32523206, 29415774, 28777073, 32124570, 31247838, 29540831
32892883, 31776121, 33223248, 33563137, 33184467, 31844357, 31727233
31494420, 28209601, 31311732, 33805155, 34149263, 33872610, 33822881
34473578, 34450366, 34461697, 34346865, 30408443, 34604941, 34786432
Patch 34444812 : applied on Fri Mar 17 03:40:53 EDT 2023
Unique Patch ID: 24971521
Patch description: "Database Release Update Revision : 19.16.1.0.221018 (34444812)"
Created on 15 Oct 2022, 09:09:09 hrs UTC
Bugs fixed:
31442332, 30544247, 32988028, 30046497, 32753472, 29161597, 31934301
30001105, 30534549, 28888327, 32816003, 29356711, 33352794, 29286229
30591475, 29934158, 33334957, 32009197, 32234148, 32996071, 32811069
31417192, 32215991, 32737774, 29972134, 31462082, 31609974, 31657681
30206675, 32829060, 28694872, 29385429, 28383667, 29134447, 31720377
...
25997810, 33177660, 30649310, 29684518, 31422440, 29785544, 32249640
33531067, 31248496, 33534589, 29634643, 29303712, 29532112, 30751527
32375438, 28927452, 29319558, 29503827, 30661000, 32551177, 30299817
29903190, 32546937, 30577591, 29785169, 33420249, 29435652, 31832901
29747648, 33201415, 31458739, 29050560, 33415279, 33499867, 29934557
30522285, 30392011, 30763305, 32715945
Patch 29585399 : applied on Thu Apr 18 03:21:33 EDT 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.
Dictionary View 를 통한 패치 정보 조회
Oracle 11g 까지는 'DBA_REGISTRY_HISTORY' 를 조회하여 확인 가능하지만
Oracle 12c 부터는 해당 view 의 구조가 변경되어 'DBA_REGISTRY_SQLPATCH' 를 사용하도록 권장 됩니다.
oracle 11g 이하 버전
조회 view : DBA_REGISTRY_HISTORY
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A15
COLUMN NAMESPACE FORMAT A15
COLUMN VERSION FORMAT A25
COLUMN COMMENTS FORMAT A30
SQL>
SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
,ACTION
,NAMESPACE
,VERSION
,ID
,COMMENTS
/* ,BUNDLE_SERIES*/
FROM DBA_REGISTRY_HISTORY
ORDER BY ACTION_TIME
;
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS
-------------------- --------------- --------------- ------------------------- ---------- ------------------------------
20221212 11:40:10 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0
20230323 21:47:15 jvmpsu.sql SERVER 11.2.0.4.2 01020OJVMP SU 0 RAN jvmpsu.sql
20230323 21:48:12 APPLY SERVER 11.2.0.4 201020 PSU 11.2.0.4.201020
oracle 12C 이상 버전
조회 view : DBA_REGISTRY_SQLPATCH
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A10
COLUMN STATUS FORMAT A10
COLUMN DESCRIPTION FORMAT A65
COLUMN VERSION FORMAT A10
SQL>
SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
,ACTION
,STATUS
,DESCRIPTION
,SOURCE_VERSION
,TARGET_VERSION
,PATCH_ID
FROM DBA_REGISTRY_SQLPATCH
ORDER BY ACTION_TIME
;
ACTION_TIME ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
-------------------- ---------- ---------- ----------------------------------------------------------------- ------------------------------ ------------------------------ ----------
20230320 21:14:24 APPLY SUCCESS Database Release Update Revision : 19.16.1.0.221018 (34444812) 19.1.0.0.0 19.16.1.0.0 34444812
20230320 21:14:24 APPLY SUCCESS OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990) 19.1.0.0.0 19.1.0.0.0 34786990
'Oracle > Install & Patch' 카테고리의 다른 글
| [RHEL 7.9] ORACLE_19c_Install_RAC (3) Oracle Instance 설치 (0) | 2023.05.24 |
|---|---|
| [RHEL 7.9] ORACLE_19c_Install_RAC (2) ASM 구성 및 Oracle 엔진 설치 (0) | 2023.05.23 |
| [RHEL 7.9] ORACLE_19c_Install_RAC (1) 사전설정 및 GRID 설치 (1) | 2023.05.23 |
| [RHEL 7.9] ORACLE_19c(19.3.0.0)_Install_Silent Mode (0) | 2023.05.19 |
| [RHEL 7.9] ORACLE_11g(11.2.0.4)_Install (1) | 2023.05.18 |
댓글