1. Release Update 개요

분기마다 발표되는 Release Update 중에서 Grid와 Database 패치를 모두 포함한 GI Release Update로 작업을 수행합니다.

Linux x86 기준의 Grid Release Update에는 일반적으로 4~5가지의 패치가 포함되어 있습니다. (표는 2019년 7월 기준)

패치명패치 번호패치 대상
Database Release Update29834717RAC 환경에서는 Database 와 GI (RAC 환경이 아닌 경우 Database만 적용)
OCW Release Update29850993Database 와 GI 모두
ACFS Release Update29851014Grid만 해당
DBWLM Release Update
Grid만 해당
Tomcat Release Update29401763Grid만 해당

19년 7월 Release Update를 적용하여, 19.3 버전(Base)에서 19.4로 업그레이드하겠습니다.

2. 사전 환경 조사

A) Opatch 버전 확인

Grid Opatch 버전 확인
$GI_HOME/OPatch/opatch version
#mv $GI_HOME/OPatch $GI_HOME/OPatch.old
#unzip <패치 다운로드 경로>/p6880880_122010_Linux-x86-64.zip -d $GI_HOME
#chown -R oracle:oinstall $GI_HOME/OPatch
#ll $GI_HOME | grep OPatch
#$GI_HOME/OPatch/opatch version

1번 노드

[root@rac1 ~]# $GI_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

2번 노드

[root@rac2 ~]# $GI_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

Grid 소프트웨어와 함께 설치된 OPatch 파일의 버전을 확인합니다.

Release Update(이하 RU)의 readme 파일을 참고하여 OPatch 파일의 버전이 최소 요구사항을 충족하는지 확인하고, 상위 버전이 필요한 경우 support.oracle.com에서 패치번호 6880880으로 최신 버전을 받아서 교체합니다.

Database Opatch 버전 확인
$DB_HOME/OPatch/opatch version
#mv $DB_HOME/OPatch $DB_HOME/OPatch.old
#unzip <패치 다운로드 경로>/p6880880_122010_Linux-x86-64.zip -d $DB_HOME
#chown -R oracle:oinstall $DB_HOME/OPatch
#ll $DB_HOME | grep OPatch
#$DB_HOME/OPatch/opatch version

1번 노드

[root@rac1 ~]# $DB_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

2번 노드

[root@rac2 ~]# $DB_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

Database 소프트웨어와 함께 설치된 OPatch 파일의 버전을 확인합니다.

상위 버전이 필요할 경우 Grid의 OPatch 파일과 함께 교체합니다.

B) 패치 내역 확인

Grid 패치 내역 확인 : Oracle 유저로 수행
$GI_HOME/OPatch/opatch lspatches -oh $GI_HOME

1번 노드

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch lspatches -oh $GI_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.

2번 노드

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch lspatches -oh $GI_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.

기존에 Grid 소프트웨어에 적용된 패치 내역을 확인합니다.

Database 패치 내역 확인 : Oracle 유저로 수행
$DB_HOME/OPatch/opatch lspatches -oh $DB_HOME

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

마찬가지로 Database 소프트웨어에 적용된 패치 내역을 확인합니다.

3. 업데이트 사전 검증

A) Grid 업데이트 검증

Grid 업데이트 충돌 여부 검증 : Oracle 유저로 수행
$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir <압축 해제 경로>/29708769/29834717
$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir <압축 해제 경로>/29708769/29850993
$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir <압축 해제 경로>/29708769/29851014
$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir <압축 해제 경로>/29708769/29401763

1번 노드

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29834717
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-52-15오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29850993
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-52-23오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29851014
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-52-35오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29401763
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-52-43오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29834717
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-52-59오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29850993
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-53-14오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29851014
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-53-24오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GI_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29401763
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-53-44오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

업데이트를 위한 요구사항이 충족되는지 먼저 검증해야 합니다.

기존의 Grid 소프트웨어에 적용된 패치와 충돌되는 것이 있는지 확인합니다.

충돌되는 패치가 있을 경우, 기존 패치에 대한 rollback이 필요한 경우가 있으니 참고 바랍니다.

Grid 업데이트 필요 공간 확인 : Oracle 유저로 수행
vi /tmp/patch_list_gihome.txt
<압축 해제 경로>/29708769/29834717
<압축 해제 경로>/29708769/29850993
<압축 해제 경로>/29708769/29851014
<압축 해제 경로>/29708769/29401763
# cat /tmp/patch_list_gihome.txt
$GI_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GI_HOME -phBaseFile /tmp/patch_list_gihome.txt

1번 노드

[racdb1:/home/oracle]> cat /tmp/patch_list_gihome.txt
/media/sf_oracle/19.4/29708769/29834717
/media/sf_oracle/19.4/29708769/29850993
/media/sf_oracle/19.4/29708769/29851014
/media/sf_oracle/19.4/29708769/29401763

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GI_HOME -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-56-02오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> cat /tmp/patch_list_gihome.txt
/media/sf_oracle/19.4/29708769/29834717
/media/sf_oracle/19.4/29708769/29850993
/media/sf_oracle/19.4/29708769/29851014
/media/sf_oracle/19.4/29708769/29401763

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GI_HOME -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2019-08-24_07-56-08오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

업데이트를 적용하기 위한 여유 공간이 있는지 확인합니다.

패치 경로가 저장된 텍스트 파일을 만들어서, OPatch의 CheckSystmSpace 옵션과 함께 확인합니다.

Grid 업데이트 사전 분석 : root 유저로 수행
$GI_HOME/OPatch/opatchauto apply <압축 해제 경로>/29708769 -analyze

1번 노드

[root@rac1 ~]# $GI_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -analyze

OPatchauto session is initiated at Sat Aug 24 07:57:52 2019

System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-08-24_07-58-02AM.log.

세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-08-24_07-58-26AM.log입니다.
이 세션의 ID는 7JT7입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid
Patch applicability verified successfully on home /u01/app/19c/grid

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac1
CRS Home:/u01/app/19c/grid
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_07-59-20오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29851014
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_07-59-20오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_07-59-20오전_1.log



OPatchauto session completed at Sat Aug 24 08:00:14 2019
Time taken to complete the session 2 minutes, 22 seconds

2번 노드

[root@rac2 ~]# $GI_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -analyze

OPatchauto session is initiated at Sat Aug 24 08:00:22 2019

System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-00-33AM.log.

세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-01-01AM.log입니다.
이 세션의 ID는 WFTB입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid
Patch applicability verified successfully on home /u01/app/19c/grid

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac2
CRS Home:/u01/app/19c/grid
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-01-34오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29851014
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-01-34오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-01-34오전_1.log



OPatchauto session completed at Sat Aug 24 08:01:58 2019
Time taken to complete the session 1 minute, 36 seconds

업데이트를 Grid에 적용하기에 앞서 사전 분석을 통해 문제없이 적용이 가능한지 검증합니다.

B) Database 업데이트 검증

Database 업데이트 충돌 여부 검증 : Oracle 유저로 수행
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir <압축 해제 경로>/29708769/29834717
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir <압축 해제 경로>/29708769/29850993

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29834717
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-02-47오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29850993
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-03-01오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29834717
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-03-07오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir /media/sf_oracle/19.4/29708769/29850993
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-03-17오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Database 소프트웨어에 적용된 패치와 충돌되는 것이 있는지 확인합니다.

충돌되는 패치가 있을 경우, 기존 패치에 대한 rollback이 필요한 경우가 있으니 참고 바랍니다

Database 업데이트 필요 공간 확인 : Oracle 유저로 수행
vi /tmp/patch_list_dbhome.txt
<압축 해제 경로>/29708769/29834717
<압축 해제 경로>/29708769/29850993
# cat /tmp/patch_list_dbhome.txt
$DB_HOME/OPatch/opatch prereq CheckSystemSpace -oh $DB_HOME -phBaseFile /tmp/patch_list_dbhome.txt

1번 노드

[racdb1:/home/oracle]> cat /tmp/patch_list_dbhome.txt
/media/sf_oracle/19.4/29708769/29834717
/media/sf_oracle/19.4/29708769/29850993

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckSystemSpace -oh $DB_HOME -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-06-35오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> cat /tmp/patch_list_dbhome.txt
/media/sf_oracle/19.4/29708769/29834717
/media/sf_oracle/19.4/29708769/29850993

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckSystemSpace -oh $DB_HOME -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-24_08-06-36오전_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

업데이트를 적용하기 위한 여유 공간이 있는지 확인합니다.

패치 경로가 저장된 텍스트 파일을 만들어서, OPatch의 CheckSystmSpace 옵션과 함께 확인합니다.

Database 업데이트 사전 분석 : root 유저로 수행
$DB_HOME/OPatch/opatchauto apply <압축 해제 경로>/29708769 -oh $DB_HOME -analyze

1번 노드

[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -oh $DB_HOME -analyze

OPatchauto session is initiated at Sat Aug 24 08:07:50 2019

System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-08-02AM.log.

세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-08-31AM.log입니다.
이 세션의 ID는 GCXU입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db_1
No step execution required.........

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac1
RAC Home:/u01/app/oracle/product/19c/db_1
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29851014
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-09-18오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-09-18오전_1.log



OPatchauto session completed at Sat Aug 24 08:09:47 2019
Time taken to complete the session 1 minute, 57 seconds

2번 노드

[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -oh $DB_HOME -analyze

OPatchauto session is initiated at Sat Aug 24 08:10:00 2019

System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-10-13AM.log.

세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-10-43AM.log입니다.
이 세션의 ID는 QB63입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db_1
No step execution required.........

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac2
RAC Home:/u01/app/oracle/product/19c/db_1
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29851014
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-11-15오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-11-15오전_1.log



OPatchauto session completed at Sat Aug 24 08:11:57 2019
Time taken to complete the session 1 minute, 58 seconds

업데이트를 Database에 적용하기에 앞서 사전 분석을 통해 문제없이 적용이 가능한지 검증합니다.

4. Release Update 적용

A) Grid 업데이트

Grid 업데이트 : root 유저로 수행
$GI_HOME/OPatch/opatchauto apply <압축 해제 경로>/29708769

1번 노드

[root@rac1 ~]# $GI_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769

OPatchauto session is initiated at Sat Aug 24 08:13:04 2019

System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-13-14AM.log.

세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-13-34AM.log입니다.
이 세션의 ID는 NWRP입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid
Patch applicability verified successfully on home /u01/app/19c/grid


Bringing down CRS service on home /u01/app/19c/grid
CRS service brought down successfully on home /u01/app/19c/grid


Start applying binary patch on home /u01/app/19c/grid
Binary patch applied successfully on home /u01/app/19c/grid


Starting CRS service on home /u01/app/19c/grid
CRS service started successfully on home /u01/app/19c/grid

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
CRS Home:/u01/app/19c/grid
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-18-36오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-18-36오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29851014
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-18-36오전_1.log



OPatchauto session completed at Sat Aug 24 08:29:32 2019
Time taken to complete the session 16 minutes, 28 seconds

2번 노드

[root@rac2 ~]# $GI_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769

OPatchauto session is initiated at Sat Aug 24 08:29:43 2019

System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-29-56AM.log.

세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-30-24AM.log입니다.
이 세션의 ID는 C7E8입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid
Patch applicability verified successfully on home /u01/app/19c/grid


Bringing down CRS service on home /u01/app/19c/grid
CRS service brought down successfully on home /u01/app/19c/grid


Start applying binary patch on home /u01/app/19c/grid
Binary patch applied successfully on home /u01/app/19c/grid


Starting CRS service on home /u01/app/19c/grid
CRS service started successfully on home /u01/app/19c/grid

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
CRS Home:/u01/app/19c/grid
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-35-40오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-35-40오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29851014
Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-35-40오전_1.log



OPatchauto session completed at Sat Aug 24 08:46:07 2019
Time taken to complete the session 16 minutes, 24 seconds

root 계정으로 접속하여 Grid 소프트웨어에 업데이트를 적용합니다.

업데이트시 클러스터를 재기동하는 과정이 진행되므로, 한 번에 하나의 노드만 업데이트합니다.

B) Database 업데이트

Database 업데이트 : root 유저로 수행
$DB_HOME/OPatch/opatchauto apply <압축 해제 경로>/29708769 -oh $DB_HOME

1번 노드

[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -oh $DB_HOME

OPatchauto session is initiated at Sat Aug 24 08:46:50 2019

System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-47-03AM.log.

세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-47-59AM.log입니다.
이 세션의 ID는 NYQX입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db_1
No step execution required.........


Preparing to bring down database service on home /u01/app/oracle/product/19c/db_1
No step execution required.........


Performing prepatch operation on home /u01/app/oracle/product/19c/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1


Start applying binary patch on home /u01/app/oracle/product/19c/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19c/db_1


Performing postpatch operation on home /u01/app/oracle/product/19c/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1


Preparing home /u01/app/oracle/product/19c/db_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/19c/db_1
No step execution required.........

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
RAC Home:/u01/app/oracle/product/19c/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29851014
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-48-57오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-48-57오전_1.log



OPatchauto session completed at Sat Aug 24 08:54:27 2019
Time taken to complete the session 7 minutes, 37 seconds

2번 노드

[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.4/29708769 -oh $DB_HOME

OPatchauto session is initiated at Sat Aug 24 08:55:06 2019

System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2019-08-24_08-55-18AM.log.

세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2019-08-24_08-56-09AM.log입니다.
이 세션의 ID는 YDEE입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db_1
No step execution required.........


Preparing to bring down database service on home /u01/app/oracle/product/19c/db_1
No step execution required.........


Performing prepatch operation on home /u01/app/oracle/product/19c/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1


Start applying binary patch on home /u01/app/oracle/product/19c/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19c/db_1


Performing postpatch operation on home /u01/app/oracle/product/19c/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19c/db_1


Preparing home /u01/app/oracle/product/19c/db_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/19c/db_1
No step execution required.........

OPatchAuto를 성공했습니다.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
RAC Home:/u01/app/oracle/product/19c/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/19.4/29708769/29851014
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/19.4/29708769/29401763
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/19.4/29708769/29834717
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-57-06오전_1.log

Patch: /media/sf_oracle/19.4/29708769/29850993
Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-08-24_08-57-06오전_1.log



OPatchauto session completed at Sat Aug 24 09:02:05 2019
Time taken to complete the session 7 minutes, 0 second

Database 소프트웨어도 동일하게 root 유저로 업데이트를 진행하며, 한 번에 하나의 노드씩 작업을 수행합니다.

C) 결과 확인

Grid 업데이트 결과 확인
$GI_HOME/OPatch/opatch lspatches -oh $GI_HOME

1번 노드

[racdb1:/home/oracle]> $GI_HOME/OPatch/opatch lspatches -oh $GI_HOME
29851014;ACFS RELEASE UPDATE 19.4.0.0.0 (29851014)
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $GI_HOME/OPatch/opatch lspatches -oh $GI_HOME
29851014;ACFS RELEASE UPDATE 19.4.0.0.0 (29851014)
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)

OPatch succeeded.

Grid 소프트웨어의 업데이트 결과를 확인합니다.

Database 업데이트 결과 확인
$DB_HOME/OPatch/opatch lspatches -oh $DB_HOME

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

Database 소프트웨어의 업데이트 결과를 확인합니다.

5. OJVM 패치 (옵션)

A) 패치 내역 확인

Database 패치 내역 확인 : Oracle 유저로 수행
$DB_HOME/OPatch/opatch lspatches -oh $DB_HOME

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

Database에 패치된 내역이 있는지 확인합니다.

기본적으로 OJVM은 Java를 사용하는 Database에 패치합니다.

B) OJVM 패치 사전 분석

OJVM 패치 사전 분석 : Oracle 유저로 수행
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph <압축 해제 경로>/29774421

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /media/sf_oracle/19.4/29774421
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-34-09오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /media/sf_oracle/19.4/29774421
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-34-32오전_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

패치를 진행하기 전에 기존에 패치와 충돌되는 부분이 있는지 확인합니다.

C) OJVM 패치 적용

OJVM 패치 : Oracle 유저로 수행
cd <압축 해제 경로>/29774421
$DB_HOME/OPatch/opatch apply

1번 노드

[racdb1:/home/oracle]> cd /media/sf_oracle/19.4/29774421

[racdb1:/media/sf_oracle/19.4/29774421]> $DB_HOME/OPatch/opatch apply
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-38-36오전_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/19c/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
OH '/u01/app/oracle/product/19c/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/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-38-36오전_1.log

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> cd /media/sf_oracle/19.4/29774421

[racdb2:/media/sf_oracle/19.4/29774421]> $DB_HOME/OPatch/opatch apply
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-42-27오전_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/19c/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
y
User Responded with: Y
Backing up files...
OH '/u01/app/oracle/product/19c/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/19c/db_1/cfgtoollogs/opatch/opatch2019-08-26_01-42-27오전_1.log

OPatch succeeded.

OJVM 패치를 Database 소프트웨어에 적용합니다.

D) 패치 결과 확인

Database 패치 결과 확인
$DB_HOME/OPatch/opatch lspatches

1번 노드

[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29774421;OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

2번 노드

[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME
29774421;OJVM RELEASE UPDATE: 19.4.0.0.190716 (29774421)
29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)
29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

Database에 패치가 된 내역을 확인합니다.

  • 레이블 없음