소스 보기

사전 환경 조사

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으로 최신 버전을 받아서 교체합니다.

$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 파일과 함께 교체합니다.

패치 내역 확인

$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 소프트웨어에 적용된 패치 내역을 확인합니다.

$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 소프트웨어에 적용된 패치 내역을 확인합니다.

업데이트 사전 검증

Grid 업데이트 검증

$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이 필요한 경우가 있으니 참고 바랍니다.

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 옵션과 함께 확인합니다.

$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에 적용하기에 앞서 사전 분석을 통해 문제없이 적용이 가능한지 검증합니다.

Database 업데이트 검증

$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이 필요한 경우가 있으니 참고 바랍니다

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 옵션과 함께 확인합니다.

$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에 적용하기에 앞서 사전 분석을 통해 문제없이 적용이 가능한지 검증합니다.