1. 사전 환경 조사
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 소프트웨어에 적용된 패치 내역을 확인합니다.
2. 업데이트 사전 검증
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에 적용하기에 앞서 사전 분석을 통해 문제없이 적용이 가능한지 검증합니다.
{}
