프린트 하기

내맘대로긍정이 알려주는

Oracle 23ai 신기능
무료 세미나 발표자료

다운로드 trending_flat

OS환경 : Oracle Linux 7.6 (64bit)


DB 환경 : Oracle Database 19.3.0.0


방법 : Oracle 19c RAC OPatch Release Update 적용 가이드

최신 OPatch 파일

p6880880_190000_Linux-x86-64.zip


패치 파일

p30501910_190000_Linux-x86-64.zip -- GRID, DB

p30484981_190000_Linux-x86-64.zip -- OJVM 

적용 전 꼭 패치 파일 안에 있는 README 파일을 읽어보길 권장함



아래 작업은 rac 설치 중 grid 설치 후 db 엔진(runInstall) 설치 후 진행하였음

p30501910

패치명

패치 번호 

패치 대상 

 Database Release Update 19.6.0.0.200114

 30557433

 Non RAC 환경에서는 DB만 해당, 

RAC 환경에서는 DB, GRID 모두 해당

 OCW Release Update 19.6.0.0.200114

 30489227

 DB, GRID 모두 해당

 ACFS Release Update 19.6.0.0.200114 Footnote2

 30489632

 GRID만 해당

 Tomcat Release Update 19.0.0.0.0Footnote 2

 30655595

 GRID만 해당



OPatch 최신파일 업로드

기존 OPatch 버전 확인

1
2
3
4
5
6
7
8
9
10
11
GRID
$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17
 
OPatch succeeded.
 
DB
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17
 
OPatch succeeded.



최신 OPatch 파일 업로드

1번, 2번노드 모두 업로드 후 진행

p6880880_190000_Linux-x86-64.zip 미디어 업로드

/ORA19/media

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
GRID
# mv $GRID_HOME/OPatch $GRID_HOME/OPatch_old
# unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip -d $GRID_HOME/
# chown -R oracle:dba $GRID_HOME/OPatch
# ls -al $GRID_HOME | grep OPatch
drwxr-x---  14 oracle dba   4096 Dec 19 00:56 OPatch
drwxr-x---  14 oracle dba   4096 Mar  4 07:38 OPatch_old
 
DB
# export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1
# mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old
# unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME/
# chown -R oracle:dba $ORACLE_HOME/OPatch
# ls -al $ORACLE_HOME | grep OPatch
drwxr-x---  14 oracle dba  4096 Dec 19 00:56 OPatch
drwxr-x---  14 oracle dba  4096 Dec 19 00:56 OPatch_old



Opatch 버전 확인

1
2
3
4
5
6
7
8
9
10
11
GRID
$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.19
 
OPatch succeeded.
 
DB
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.19
 
OPatch succeeded.

제일 뒷자리가 17에서 19로 변함



GRID, DB 업데이트

기존 패치 내역 확인(oracle 계정으로 확인)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
GRID
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
 
OPatch succeeded.
 
DB
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
 
OPatch succeeded.



업데이트 파일 압축해제

1
2
$ cd /ORA19/media/
$ unzip p30501910_190000_Linux-x86-64.zip



GRID 업데이트 사전 검증(충돌 여부 검증)

1
2
3
4
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489227
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489632
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30557433
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30655595


GRID 업데이트 사전 검증(충돌 여부 검증) log

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
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489227
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/grid/19.3.0
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/grid/19.3.0/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-06-37AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489632
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/grid/19.3.0
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/grid/19.3.0/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-01AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30557433
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/grid/19.3.0
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/grid/19.3.0/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-12AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 
$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30655595
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/grid/19.3.0
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/grid/19.3.0/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-33AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.



GRID 업데이트 필요 공간 확인(oracle 계정으로 실행)

/tmp/patch_list_grid.txt 파일 생성

업데이트 파일 경로 작성 후 저장

1
2
3
4
5
$ cat /tmp/patch_list_grid.txt 
/ORA19/media/30501910/30489227     
/ORA19/media/30501910/30489632     
/ORA19/media/30501910/30557433     
/ORA19/media/30501910/30655595     



OPatch CheckSystemSpace 명령으로 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GRID_HOME -phBaseFile /tmp/patch_list_grid.txt
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/grid/19.3.0
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/grid/19.3.0/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_10-25-58AM_1.log
 
Invoking prereq "checksystemspace"
 
Prereq "checkSystemSpace" passed.
 
OPatch succeeded.





GRID 업데이트 사전 분석(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
# $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME -analyze
 
OPatchauto session is initiated at Sun Mar  8 10:45:17 2020
 
System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-08_10-45-25AM.log.
 
Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-08_10-45-50AM.log
The id for this session is KMPY
 
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0
Patch applicability verified successfully on home /ORA19/app/grid/19.3.0
 
OPatchAuto successful.
 
--------------------------------Summary--------------------------------
 
Analysis for applying patches has completed successfully:
 
Host:oel19db1
CRS Home:/ORA19/app/grid/19.3.0
Version:19.0.0.0.0
 
 
==Following patches were SUCCESSFULLY analyzed to be applied:
 
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log
 
Patch: /ORA19/media/30501910/30489632
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log
 
Patch: /ORA19/media/30501910/30655595
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log
 
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log
 
 
 
OPatchauto session completed at Sun Mar  8 10:48:15 2020
Time taken to complete the session 2 minutes, 58 seconds



DB 업데이트 사전 검증(충돌 여부 검증)

1
2
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30557433
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30489227


DB 업데이트 사전 검증(충돌 여부 검증) log

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
log
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30557433
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/oracle/product/19.3.0/db_1
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-38-43AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30489227
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/oracle/product/19.3.0/db_1
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-38-55AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.



DB 업데이트 필요 공간 확인(oracle 계정으로 실행)

/tmp/patch_list_db.txt 파일 생성

업데이트 파일 경로 작성 후 저장

1
2
3
$ cat /tmp/patch_list_db.txt 
/ORA19/media/30501910/30557433
/ORA19/media/30501910/30489227



OPatch CheckSystemSpace 명령으로 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -oh $ORACLE_HOME -phBaseFile /tmp/patch_list_db.txt
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/oracle/product/19.3.0/db_1
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-42-24AM_1.log
 
Invoking prereq "checksystemspace"
 
Prereq "checkSystemSpace" passed.
 
OPatch succeeded.



DB 업데이트 사전 분석(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
# export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1
# $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME -analyze
 
OPatchauto session is initiated at Sun Mar  8 10:51:52 2020
 
System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-08_10-52-18AM.log.
 
Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-08_10-53-33AM.log
The id for this session is QSBI
 
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1
 
 
Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
OPatchAuto successful.
 
--------------------------------Summary--------------------------------
 
Analysis for applying patches has completed successfully:
 
Host:oel19db1
RAC Home:/ORA19/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
 
 
==Following patches were SKIPPED:
 
Patch: /ORA19/media/30501910/30489632
Reason: This patch is not applicable to this specified target type - "rac_database"
 
Patch: /ORA19/media/30501910/30655595
Reason: This patch is not applicable to this specified target type - "rac_database"
 
 
==Following patches were SUCCESSFULLY analyzed to be applied:
 
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-55-23AM_1.log
 
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-55-23AM_1.log
 
 
 
OPatchauto session completed at Sun Mar  8 10:56:30 2020
Time taken to complete the session 4 minutes, 39 seconds



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
# $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME
 
OPatchauto session is initiated at Mon Mar  9 07:31:46 2020
 
System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-09_07-32-19AM.log.
 
Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-09_07-33-26AM.log
The id for this session is X9DG
 
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0
Patch applicability verified successfully on home /ORA19/app/grid/19.3.0
 
 
Bringing down CRS service on home /ORA19/app/grid/19.3.0
CRS service brought down successfully on home /ORA19/app/grid/19.3.0
 
 
Start applying binary patch on home /ORA19/app/grid/19.3.0
Binary patch applied successfully on home /ORA19/app/grid/19.3.0
 
 
Starting CRS service on home /ORA19/app/grid/19.3.0
CRS service started successfully on home /ORA19/app/grid/19.3.0
 
OPatchAuto successful.
 
--------------------------------Summary--------------------------------
 
Patching is completed successfully. Please find the summary as follows:
 
Host:oel19db1
CRS Home:/ORA19/app/grid/19.3.0
Version:19.0.0.0.0
Summary:
 
==Following patches were SUCCESSFULLY applied:
 
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log
 
Patch: /ORA19/media/30501910/30489632
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log
 
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log
 
Patch: /ORA19/media/30501910/30655595
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log
 
 
 
OPatchauto session completed at Mon Mar  9 07:53:16 2020
Time taken to complete the session 21 minutes, 32 seconds



GRID 업데이트 적용 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
# $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME
 
OPatchauto session is initiated at Mon Mar  9 07:57:54 2020
 
System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-09_07-58-10AM.log.
 
Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-09_07-59-24AM.log
The id for this session is J81A
 
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0
Patch applicability verified successfully on home /ORA19/app/grid/19.3.0
 
 
Bringing down CRS service on home /ORA19/app/grid/19.3.0
CRS service brought down successfully on home /ORA19/app/grid/19.3.0
 
 
Start applying binary patch on home /ORA19/app/grid/19.3.0
Binary patch applied successfully on home /ORA19/app/grid/19.3.0
 
 
Starting CRS service on home /ORA19/app/grid/19.3.0
CRS service started successfully on home /ORA19/app/grid/19.3.0
 
OPatchAuto successful.
 
--------------------------------Summary--------------------------------
 
Patching is completed successfully. Please find the summary as follows:
 
Host:oel19db2
CRS Home:/ORA19/app/grid/19.3.0
Version:19.0.0.0.0
Summary:
 
==Following patches were SUCCESSFULLY applied:
 
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log
 
Patch: /ORA19/media/30501910/30489632
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log
 
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log
 
Patch: /ORA19/media/30501910/30655595
Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log
 
 
 
OPatchauto session completed at Mon Mar  9 08:18:40 2020
Time taken to complete the session 20 minutes, 48 seconds



GRID 업데이트 확인(oracle 계정으로 확인)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1번 노드
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489632;ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.
 
2번 노드
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489632;ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.



DB 업데이트 적용 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
# export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1
# $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME
OPatchauto session is initiated at Tue Mar 10 04:52:51 2020
System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-10_04-52-58AM.log.
Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-10_04-53-45AM.log
The id for this session is FR67
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
Preparing to bring down database service on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
Performing prepatch operation on home /ORA19/app/oracle/product/19.3.0/db_1
Perpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1
Start applying binary patch on home /ORA19/app/oracle/product/19.3.0/db_1
Binary patch applied successfully on home /ORA19/app/oracle/product/19.3.0/db_1
Performing postpatch operation on home /ORA19/app/oracle/product/19.3.0/db_1
Postpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1
Preparing home /ORA19/app/oracle/product/19.3.0/db_1 after database service restarted
No step execution required.........
 
Trying to apply SQL patch on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:oel19db1
RAC Home:/ORA19/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_04-54-40AM_1.log
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_05-29-22AM_1.log
OPatchauto session completed at Tue Mar 10 05:02:25 2020
Time taken to complete the session 12 minutes, 34 seconds



DB 업데이트 적용 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
# export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1
# $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME
 
OPatchauto session is initiated at Tue Mar 10 08:51:44 2020
 
System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-10_08-51-53AM.log.
 
Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-10_08-52-29AM.log
The id for this session is 1H4M
 
Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1
 
 
Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
 
Preparing to bring down database service on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
 
Performing prepatch operation on home /ORA19/app/oracle/product/19.3.0/db_1
Perpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1
 
 
Start applying binary patch on home /ORA19/app/oracle/product/19.3.0/db_1
Binary patch applied successfully on home /ORA19/app/oracle/product/19.3.0/db_1
 
 
Performing postpatch operation on home /ORA19/app/oracle/product/19.3.0/db_1
Postpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1
 
 
Preparing home /ORA19/app/oracle/product/19.3.0/db_1 after database service restarted
No step execution required.........
 
 
Trying to apply SQL patch on home /ORA19/app/oracle/product/19.3.0/db_1
No step execution required.........
 
OPatchAuto successful.
 
--------------------------------Summary--------------------------------
 
Patching is completed successfully. Please find the summary as follows:
 
Host:oel19db2
RAC Home:/ORA19/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Summary:
 
==Following patches were SUCCESSFULLY applied:
 
Patch: /ORA19/media/30501910/30489227
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_08-53-09AM_1.log
Patch: /ORA19/media/30501910/30557433
Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_08-57-56AM_1.log
 
 
OPatchauto session completed at Tue Mar 10 09:12:01 2020
Time taken to complete the session 14 minutes, 18 seconds



DB 업데이트 확인(oracle 계정으로 확인)

1
2
3
4
5
6
7
8
9
10
11
12
13
1번 노드
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.
 
2번 노드
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.



패치 내역 확인(oracle 계정으로 확인)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
GRID
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489632;ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.
 
DB
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.



패치 내역 비교



OJVM 패치 (옵션)

기존 패치 내역 확인(oracle 계정으로 확인)

1
2
3
4
5
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.



패치파일 압축해제 1번, 2번 노드 모두진행

1
2
3
4
# chown oracle:dba /ORA19/media/p30484981_190000_Linux-x86-64.zip
# su - oracle
$ cd /ORA19/media
$ unzip p30484981_190000_Linux-x86-64.zip



OJVM 패치 사전 분석(oracle 계정으로 확인) 1번, 2번 노드 모두진행

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /ORA19/media/30484981
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /ORA19/app/oracle/product/19.3.0/db_1
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-49-49PM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.



OJVM 패치(oracle 계정으로 실행) 1번, 2번 노드 모두진행

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
$ cd /ORA19/media/30484981/
$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /ORA19/app/oracle/product/19.3.0/db_1
Central Inventory : /ORA19/app/oraInventory
   from           : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-51-50PM_1.log
 
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30484981  
 
Do you want to proceed? [y|n]
y  <-- y입력
User Responded with: Y
All checks passed.
 
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ORA19/app/oracle/product/19.3.0/db_1')
 
 
Is the local system ready for patching? [y|n]
y  <-- y입력
User Responded with: Y
Backing up files...
Applying interim patch '30484981' to OH '/ORA19/app/oracle/product/19.3.0/db_1'
 
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...
Patch 30484981 successfully applied.
Log file location: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-51-50PM_1.log
 
OPatch succeeded.



OJVM 패치 결과 확인

1
2
3
4
5
6
$ $ORACLE_HOME/OPatch/opatch lspatches
30484981;OJVM RELEASE UPDATE19.6.0.0.200114 (30484981)
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
 
OPatch succeeded.

기존에 없던 OJVM RELEASE UPDATE가 생긴것을 확인 할 수 있음



참조 : https://dataforum.io/display/ORCL/Oracle+Database+19c+Real+Application+Cluster

p30501910의 README.html

https://positivemh.tistory.com/522

https://positivemh.tistory.com/523