오라클/참고

오라클 19c RAC 패치 적용

Manly 2022. 11. 10. 17:01
반응형

방법 : 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

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 계정으로 실행)

0
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

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 계정으로 실행)

4
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 계정으로 실행)

 
# $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 계정으로 실행)

6
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 계정으로 실행)

9
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 UPDATE: 19.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

반응형

'오라클 > 참고' 카테고리의 다른 글

오라클 SID, Service Name  (0) 2022.11.16
물리, 논리적 분류 / 인덱스  (0) 2022.11.16
오라클 DB character set  (0) 2022.11.06
오라클 데이터 이관 (EXP / IMP)  (0) 2022.10.27
Character Set  (0) 2022.10.27

'오라클/참고'의 다른글

  • 현재글오라클 19c RAC 패치 적용

관련글

댓글

티스토리툴바