1. 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 소프트웨어의 업데이트 결과를 확인합니다.
{}
