복사되었습니다!
OS 환경 : Oracle Linux 8.7 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : 오라클 19c RAC 환경 opatchauto 이용 19.31 RU 패치
본문에서는 19.28이 설치된 RAC 환경에 19.31 패치를 적용하는 방법을 설명함
이때 opatch apply를 개별적으로 수행하지 않고 opatchauto를 이용해 커맨드 한줄로 수행하는 방법을 설명함
요즘 오라클 패치 파일 readme에서도 이 방식을 권장하고 있음
패치파일은 39062956를 사용함(참고로 19.31 패치는 한번 문제가 발생했었어서 rollback 되었다가 재릴리즈 되었음)
Patch 39062956 - Combo of OJVM Component Release Update 19.31.0.0.260421 + Grid Infrastructure Apr 2026 Release Update 19.31.0.0.260421 (REL-APR2026)
패치파일 구조
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
39062956
|
|- README.txt
|
|- README.html
|
|- 39036936/ <<-- GRID 및 DB 패치 파일
| --README.html
| -- 39034528 <<-- Database Release Update 19.31.0.0.260421
| -- 39039430 <<-- OCW Release Update 19.31.0.0.260421
| -- 39055473 <<-- ACFS Release Update 19.31.0.0.260421
| -- 39107855 <<-- Tomcat Release Update 19.0.0.0.0 (Beginning 19.31 TOMCAT version will be deleted.)
| -- 39107825 <<-- DBWLM Release Update 19.0.0.0.0 (Beginning from 19.31 Apr2026, QOS / WLM directory has been removed.)
|
|- 38906621/ <<-- OJVM 패치 파일
| --README.html
| -- <other files and directories>
|
39036936 폴더 안에 있는 파일 설명
39034528 : Database Release Update 19.31.0.0.260421
설치 대상 : Oracle RAC 환경이 아닌 경우 Oracle 홈에만 적용, Oracle RAC 환경인 경우에는 Oracle 홈과 Grid 홈 모두 적용
39039430 : OCW Release Update 19.31.0.0.260421
설치 대상 : Oracle 홈과 Grid 홈 모두 적용
39055473 : ACFS Release Update 19.31.0.0.260421
설치 대상 : Grid 홈에만 적용
39107855 : Tomcat Release Update 19.0.0.0.0 (Beginning 19.31 TOMCAT version will be deleted.)
설치 대상 : Grid 홈에만 적용
39107825 : DBWLM Release Update 19.0.0.0.0 (Beginning from 19.31 Apr2026, QOS / WLM directory has been removed.)
설치 대상 : Grid 홈에만 적용
테스트
양쪽 노드 모두 패치파일 unzip
|
1
2
|
$ cd /app/media
$ unzip -q p39062956_190000_Linux-x86-64.zip
|
양쪽 노드 모두 opatch 파일 업데이트(db)
|
1
2
3
|
$ cd $ORACLE_HOME
$ mv OPatch OPatchold
$ unzip -q /app/media/p6880880_190000_Linux-x86-64.zip
|
양쪽 노드 모두 opatch 파일 업데이트(grid)
|
1
2
3
4
|
# cd $GRID_HOME
# mv OPatch OPatchold
# unzip -q /app/media/p6880880_190000_Linux-x86-64.zip
# chown -R oracle:dba OPatch
|
패치 전 충돌 검사 수행
참고로 현재 는 /app/media/39062956임
|
1
2
3
4
5
6
7
8
9
10
11
12
|
# grid 유저로 수행
$ $GRID_HOME/OPatch/opatch prereq CheckMinimumOPatchVersion-phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39039430 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39055473 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39107855 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39107825 -oh $GRID_HOME
# oracle 유저로 수행
$ $ORACLE_HOME/OPatch/opatch prereq CheckMinimumOPatchVersion-phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39039430 -oh $ORACLE_HOME
|
패치 전 여유 공간 검사 수행
|
1
2
3
4
5
6
7
8
9
10
|
# grid 유저로 수행
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39039430 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39055473 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39107855 -oh $GRID_HOME
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39107825 -oh $GRID_HOME
# oracle 유저로 수행
$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39034528 -oh $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir <UNZIPPED_PATCH_LOCATION>/39036936/39039430 -oh $ORACLE_HOME
|
1번 노드 먼저 패치를 수행하는데 db나 grid를 수동으로 내리지 않고 바로 아래 명령을 수행함
1번 노드 root에서 패치 수행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
# cd /app/media/39062956
# export ORACLE_HOME=$GRID_HOME
# $GRID_HOME/OPatch/opatchauto apply 39036936
OPatchauto session is initiated at Fri Jun 5 23:29:25 2026
System initialization log file is /app/grid/product/19c/cfgtoollogs/opatchautodb/systemconfig2026-06-05_11-29-33PM.log.
Session log file is /app/grid/product/19c/cfgtoollogs/opatchauto/opatchauto2026-06-05_11-30-06PM.log
The id for this session is 1569
Executing OPatch prereq operations to verify patch applicability on home /app/grid/product/19c
Patch applicability verified successfully on home /app/grid/product/19c
Executing OPatch prereq operations to verify patch applicability on home /app/oracle/product/19c
Patch applicability verified successfully on home /app/oracle/product/19c
Executing patch validation checks on home /app/grid/product/19c
Patch validation checks successfully completed on home /app/grid/product/19c
Executing patch validation checks on home /app/oracle/product/19c
Patch validation checks successfully completed on home /app/oracle/product/19c
Verifying SQL patch applicability on home /app/oracle/product/19c
SQL patch applicability verified successfully on home /app/oracle/product/19c
Preparing to bring down database service on home /app/oracle/product/19c
Successfully prepared home /app/oracle/product/19c to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /app/grid/product/19c
Prepatch operation log file location: /app/oracle/crsdata/oel19db1/crsconfig/crs_prepatch_apply_inplace_oel19db1_2026-06-05_11-38-06PM.log
CRS service brought down successfully on home /app/grid/product/19c
Performing prepatch operation on home /app/oracle/product/19c
Prepatch operation completed successfully on home /app/oracle/product/19c
Start applying binary patch on home /app/oracle/product/19c
Binary patch applied successfully on home /app/oracle/product/19c
Running rootadd_rdbms.sh on home /app/oracle/product/19c
Successfully executed rootadd_rdbms.sh on home /app/oracle/product/19c
Performing postpatch operation on home /app/oracle/product/19c
Postpatch operation completed successfully on home /app/oracle/product/19c
Start applying binary patch on home /app/grid/product/19c
Binary patch applied successfully on home /app/grid/product/19c
Running rootadd_rdbms.sh on home /app/grid/product/19c
Successfully executed rootadd_rdbms.sh on home /app/grid/product/19c
Performing postpatch operations on CRS - starting CRS service on home /app/grid/product/19c
Postpatch operation log file location: /app/oracle/crsdata/oel19db1/crsconfig/crs_postpatch_apply_inplace_oel19db1_2026-06-06_00-12-57AM.log
CRS service started successfully on home /app/grid/product/19c
Preparing home /app/oracle/product/19c after database service restarted
No step execution required.........
Trying to apply SQL patch on home /app/oracle/product/19c
No SQL patch operations are required on local node for this home
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:oel19db1
RAC Home:/app/oracle/product/19c
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /app/media/39062956/39036936/39055473
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /app/media/39062956/39036936/39107825
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /app/media/39062956/39036936/39107855
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /app/media/39062956/39036936/39034528
Log: /app/oracle/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-39-47PM_1.log
Patch: /app/media/39062956/39036936/39039430
Log: /app/oracle/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-39-47PM_1.log
Host:oel19db1
CRS Home:/app/grid/product/19c
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /app/media/39062956/39036936/39034528
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-54-27PM_1.log
Patch: /app/media/39062956/39036936/39039430
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-54-27PM_1.log
Patch: /app/media/39062956/39036936/39055473
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-54-27PM_1.log
Patch: /app/media/39062956/39036936/39107825
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-54-27PM_1.log
Patch: /app/media/39062956/39036936/39107855
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-05_23-54-27PM_1.log
OPatchauto session completed at Sat Jun 6 00:19:12 2026
Time taken to complete the session 49 minutes, 40 seconds
|
1번 노드 grid, db 패치가 완료됨, 49분 소요됨
2번 노드 root에서 패치 수행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
# export ORACLE_HOME=$GRID_HOME
# $GRID_HOME/OPatch/opatchauto apply 39036936
OPatchauto session is initiated at Sat Jun 6 00:20:29 2026
System initialization log file is /app/grid/product/19c/cfgtoollogs/opatchautodb/systemconfig2026-06-06_12-20-40AM.log.
Session log file is /app/grid/product/19c/cfgtoollogs/opatchauto/opatchauto2026-06-06_12-21-19AM.log
The id for this session is 8YMN
Executing OPatch prereq operations to verify patch applicability on home /app/grid/product/19c
Patch applicability verified successfully on home /app/grid/product/19c
Executing OPatch prereq operations to verify patch applicability on home /app/oracle/product/19c
Patch applicability verified successfully on home /app/oracle/product/19c
Executing patch validation checks on home /app/grid/product/19c
Patch validation checks successfully completed on home /app/grid/product/19c
Executing patch validation checks on home /app/oracle/product/19c
Patch validation checks successfully completed on home /app/oracle/product/19c
Verifying SQL patch applicability on home /app/oracle/product/19c
SQL patch applicability verified successfully on home /app/oracle/product/19c
Preparing to bring down database service on home /app/oracle/product/19c
Successfully prepared home /app/oracle/product/19c to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /app/grid/product/19c
Prepatch operation log file location: /app/oracle/crsdata/oel19db2/crsconfig/crs_prepatch_apply_inplace_oel19db2_2026-06-06_00-29-28AM.log
CRS service brought down successfully on home /app/grid/product/19c
Performing prepatch operation on home /app/oracle/product/19c
Prepatch operation completed successfully on home /app/oracle/product/19c
Start applying binary patch on home /app/oracle/product/19c
Binary patch applied successfully on home /app/oracle/product/19c
Running rootadd_rdbms.sh on home /app/oracle/product/19c
Successfully executed rootadd_rdbms.sh on home /app/oracle/product/19c
Performing postpatch operation on home /app/oracle/product/19c
Postpatch operation completed successfully on home /app/oracle/product/19c
Start applying binary patch on home /app/grid/product/19c
Binary patch applied successfully on home /app/grid/product/19c
Running rootadd_rdbms.sh on home /app/grid/product/19c
Successfully executed rootadd_rdbms.sh on home /app/grid/product/19c
Performing postpatch operations on CRS - starting CRS service on home /app/grid/product/19c
Postpatch operation log file location: /app/oracle/crsdata/oel19db2/crsconfig/crs_postpatch_apply_inplace_oel19db2_2026-06-06_01-01-13AM.log
CRS service started successfully on home /app/grid/product/19c
Preparing home /app/oracle/product/19c after database service restarted
No step execution required.........
Trying to apply SQL patch on home /app/oracle/product/19c
SQL patch applied successfully on home /app/oracle/product/19c
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:oel19db2
RAC Home:/app/oracle/product/19c
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /app/media/39062956/39036936/39055473
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /app/media/39062956/39036936/39107825
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /app/media/39062956/39036936/39107855
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /app/media/39062956/39036936/39034528
Log: /app/oracle/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-31-02AM_1.log
Patch: /app/media/39062956/39036936/39039430
Log: /app/oracle/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-31-02AM_1.log
Host:oel19db2
CRS Home:/app/grid/product/19c
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /app/media/39062956/39036936/39034528
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-44-03AM_1.log
Patch: /app/media/39062956/39036936/39039430
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-44-03AM_1.log
Patch: /app/media/39062956/39036936/39055473
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-44-03AM_1.log
Patch: /app/media/39062956/39036936/39107825
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-44-03AM_1.log
Patch: /app/media/39062956/39036936/39107855
Log: /app/grid/product/19c/cfgtoollogs/opatchauto/core/opatch/opatch2026-06-06_00-44-03AM_1.log
OPatchauto session completed at Sat Jun 6 01:12:02 2026
Time taken to complete the session 51 minutes, 23 seconds
|
2번 노드 grid, db 패치가 완료됨, 51분 소요됨
패치 확인(모든 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
# su - oracle
$ opatch lspatches -oh $GRID_HOME
39107855;TOMCAT RELEASE UPDATE 19.0.0.0.0 (39107855)
39107825;DBWLM RELEASE UPDATE 19.0.0.0.0 (39107825)
39055473;ACFS RELEASE UPDATE 19.31.0.0.0 (39055473)
39039430;OCW RELEASE UPDATE 19.31.0.0.0 (39039430)
39034528;Database Release Update : 19.31.0.0.260421 (REL-APR2026) (39034528)
OPatch succeeded.
$ opatch lspatches -oh $ORACLE_HOME
39039430;OCW RELEASE UPDATE 19.31.0.0.0 (39039430)
39034528;Database Release Update : 19.31.0.0.260421 (REL-APR2026) (39034528)
37847857;OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857)
OPatch succeeded.
|
grid, db 모두 19.31로 패치됨(ojvm은 함께 패치되지 않음)
패치 내역 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SQL>
set lines 200 pages 1000
col action_time for a20
col action for a10
col status for a10
col description for a70
col version for a10
select to_char(action_time, 'yyyy/mm/dd hh24:mi:ss') as action_time,
action, status, description, patch_id
from dba_registry_sqlpatch
order by action_time;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
-------------------- ---------- ---------- ---------------------------------------------------------------------- ----------
2025/12/24 10:53:33 APPLY SUCCESS OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857) 37847857
2025/12/24 10:56:39 APPLY SUCCESS Database Release Update : 19.28.0.0.250715 (37960098) 37960098
2026/06/06 01:11:18 APPLY SUCCESS Database Release Update : 19.31.0.0.260421 (REL-APR2026) (39034528) 39034528
|
datapatch도 잘 적용됨(ojvm은 함께 패치되지 않음)
필요시 db 중지 후 ojvm은 함께 패치 수행(모든 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
SQL> shutdown immediate
$ cd /app/media/39062956/38906621/
$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.51
Copyright (c) 2026, Oracle Corporation. All rights reserved.
Oracle Home : /app/oracle/product/19c
Central Inventory : /app/oraInventory
from : /app/oracle/product/19c/oraInst.loc
OPatch version : 12.2.0.1.51
OUI version : 12.2.0.7.0
Log file location : /app/oracle/product/19c/cfgtoollogs/opatch/opatch2026-06-06_07-17-34AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 38906621
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/oracle/product/19c')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '38906621' to OH '/app/oracle/product/19c'
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 38906621 successfully applied.
Sub-set patch [37847857] has become inactive due to the application of a super-set patch [38906621].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /app/oracle/product/19c/cfgtoollogs/opatch/opatch2026-06-06_07-17-34AM_1.log
OPatch succeeded.
|
완료됨
패치 재확인(모든 노드)
|
1
2
3
4
5
6
|
$ opatch lspatches -oh $ORACLE_HOME
38906621;OJVM RELEASE UPDATE: 19.31.0.0.260421 (38906621)
39039430;OCW RELEASE UPDATE 19.31.0.0.0 (39039430)
39034528;Database Release Update : 19.31.0.0.260421 (REL-APR2026) (39034528)
OPatch succeeded.
|
ojvm이 19.31로 패치됨
db 기동(모든 노드) 후 datapatch 수행(한쪽 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
SQL> startup
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
SQL Patching tool version 19.31.0.0.0 Production on Sat Jun 6 07:25:19 2026
Copyright (c) 2012, 2026, Oracle. All rights reserved.
Log file for this invocation: /app/oracle/cfgtoollogs/sqlpatch/sqlpatch_453631_2026_06_06_07_25_19/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 37847857 (OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857)):
Binary registry: Not installed
SQL registry: Applied successfully on 24-DEC-25 10.53.33.506597 AM
Interim patch 38906621 (OJVM RELEASE UPDATE: 19.31.0.0.260421 (38906621)):
Binary registry: Installed
SQL registry: Not installed
Current state of release update SQL patches:
Binary registry:
19.31.0.0.0 Release_Update 260514003012: Installed
SQL registry:
Applied 19.31.0.0.0 Release_Update 260514003012 successfully on 06-JUN-26 01.11.18.913247 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
The following interim patches will be rolled back:
37847857 (OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857))
No release update patches need to be installed
The following interim patches will be applied:
38906621 (OJVM RELEASE UPDATE: 19.31.0.0.260421 (38906621))
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...done
Patch 37847857 rollback: SUCCESS
logfile: /app/oracle/cfgtoollogs/sqlpatch/37847857/27534561/37847857_rollback_ORADB_2026Jun06_07_27_07.log (no errors)
Patch 38906621 apply: SUCCESS
logfile: /app/oracle/cfgtoollogs/sqlpatch/38906621/28588735/38906621_apply_ORADB_2026Jun06_07_27_46.log (no errors)
SQL Patching tool complete on Sat Jun 6 07:28:29 2026
|
패치 내역 재확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
SQL>
set lines 200 pages 1000
col action_time for a20
col action for a10
col status for a10
col description for a70
col version for a10
select to_char(action_time, 'yyyy/mm/dd hh24:mi:ss') as action_time,
action, status, description, patch_id
from dba_registry_sqlpatch
order by action_time;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
-------------------- ---------- ---------- ---------------------------------------------------------------------- ----------
2025/12/24 10:53:33 APPLY SUCCESS OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857) 37847857
2025/12/24 10:56:39 APPLY SUCCESS Database Release Update : 19.28.0.0.250715 (37960098) 37960098
2026/06/06 01:11:18 APPLY SUCCESS Database Release Update : 19.31.0.0.260421 (REL-APR2026) (39034528) 39034528
2026/06/06 07:27:46 ROLLBACK SUCCESS OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857) 37847857
2026/06/06 07:28:29 APPLY SUCCESS OJVM RELEASE UPDATE: 19.31.0.0.260421 (38906621) 38906621
|
ojvm까지 datapatch도 잘 적용됨
참고1. ORACLE_HOME을 $GRID_HOME으로 설정해주어야함 그렇지 않은 경우 아래와 같은 에러가 발생함
|
1
2
3
4
5
6
7
|
# echo $ORACLE_HOME
/app/oracle/product/19c
# $GRID_HOME/OPatch/opatchauto apply 39036936
opatchauto must run from one of the homes specified
opathauto runs from the /app/grid/product/19c, while Oracle Home specified is /app/oracle/product/19c
opatchauto returns with error code = 2
|
참고2. opatchauto 파일 경로를 지정해주지 않으면 아래와 같은 에러가 발생함
|
1
2
3
4
|
# opatchauto apply 39036936
opatchauto must run from Grid Home with current arguments. Please retry it inside Grid Home
opatchauto returns with error code = 2
|
결론 :
opatchauto를 이용해 패치를 간편하게 수행할 수 있음
참조 :
19.31 combo patch readme 문서
'ORACLE > Install' 카테고리의 다른 글
| 오라클 19c Restart(ASM) to 싱글(FS) ADG 구성 가이드 (0) | 2026.06.08 |
|---|---|
| 오라클 19c DB RU(Release Update) 패치중 세션 종료 테스트 (0) | 2026.05.26 |
| Oracle Linux 7.6에 Oracle 11gR2 Silent 모드 설치 가이드 (0) | 2026.05.14 |
| 오라클 26ai AutoUpgrade를 이용해 엔진 설치 방법 (0) | 2026.05.12 |
| Oracle 26ai Single DB RU(Release Update) 패치 가이드 (0) | 2026.05.01 |