1. 패치 전 준비
A) 환경 변수 설정
root 계정 환경 변수 설정
export GRID_HOME=/u01/app/19c/grid export ORACLE_BASE=/u01/app/oracle export DB_HOME=$ORACLE_BASE/product/19c/db_1
[root@rac1 ~]# export GRID_HOME=/u01/app/19c/grid [root@rac1 ~]# export ORACLE_BASE=/u01/app/oracle [root@rac1 ~]# export DB_HOME=$ORACLE_BASE/product/19c/db_1
[root@rac2 ~]# export GRID_HOME=/u01/app/19c/grid [root@rac2 ~]# export ORACLE_BASE=/u01/app/oracle [root@rac2 ~]# export DB_HOME=$ORACLE_BASE/product/19c/db_1
B) OPatch 업데이트
$GRID_HOME의 OPatch 업데이트
$GRID_HOME/OPatch/opatch version mv $GRID_HOME/OPatch $GRID_HOME/OPatch.old unzip <opatch 다운로드 디렉토리>/p6880880_190000_Linux-x86-64.zip -d $GRID_HOME chown -R oracle:oinstall $GRID_HOME/OPatch $GRID_HOME/OPatch/opatch version
[root@rac1 ~]# $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac1 ~]# mv $GRID_HOME/OPatch $GRID_HOME/OPatch.old [root@rac1 ~]# unzip /media/sf_oracle/19.6/p6880880_190000_Linux-x86-64.zip -d $GRID_HOME Archive: /media/sf_oracle/19.6/p6880880_190000_Linux-x86-64.zip ... << 중략 >> ... inflating: /u01/app/19c/grid/OPatch/opatchauto inflating: /u01/app/19c/grid/OPatch/operr inflating: /u01/app/19c/grid/OPatch/opatchauto.cmd [root@rac1 ~]# chown -R oracle:oinstall $GRID_HOME/OPatch [root@rac1 ~]# $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded.
[root@rac2 ~]# $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac2 ~]# mv $GRID_HOME/OPatch $GRID_HOME/OPatch.old [root@rac2 ~]# unzip /media/sf_oracle/19.6/p6880880_190000_Linux-x86-64.zip -d $GRID_HOME Archive: /media/sf_oracle/19.6/p6880880_190000_Linux-x86-64.zip ... << 중략 >> ... inflating: /u01/app/19c/grid/OPatch/opatchauto inflating: /u01/app/19c/grid/OPatch/operr inflating: /u01/app/19c/grid/OPatch/opatchauto.cmd [root@rac2 ~]# chown -R oracle:oinstall $GRID_HOME/OPatch [root@rac2 ~]# $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded.
$DB_HOME의 OPatch 업데이트
$DB_HOME/OPatch/opatch version mv $DB_HOME/OPatch $DB_HOME/OPatch.old cp -r $GRID_HOME/OPatch $DB_HOME/ chown -R oracle:oinstall $DB_HOME/OPatch $DB_HOME/OPatch/opatch version
[root@rac1 ~]# $DB_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac1 ~]# mv $DB_HOME/OPatch $DB_HOME/OPatch.old [root@rac1 ~]# cp -r $GRID_HOME/OPatch $DB_HOME/ [root@rac1 ~]# chown -R oracle:oinstall $DB_HOME/OPatch [root@rac1 ~]# $DB_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded.
[root@rac2 ~]# $DB_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac2 ~]# mv $DB_HOME/OPatch $DB_HOME/OPatch.old [root@rac2 ~]# cp -r $GRID_HOME/OPatch $DB_HOME/ [root@rac2 ~]# chown -R oracle:oinstall $DB_HOME/OPatch [root@rac2 ~]# $DB_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded.
2. 1번 노드 패치
A) 1번 노드 Grid 패치
1번 노드 Grid 패치 적용
$GRID_HOME/OPatch/opatchauto apply <패치 압축 해제 디렉토리>/30501910
[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/19.6/30501910 OPatchauto session is initiated at Thu Mar 29 10:46:34 2020 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-29_10-46-50AM.log. 세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2020-03-29_10-48-10AM.log입니다. 이 세션의 ID는 1PM4입니다. 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 SUCCESSFULLY applied: Patch: /media/sf_oracle/19.6/30501910/30489227 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_10-53-49오전_1.log Patch: /media/sf_oracle/19.6/30501910/30489632 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_10-53-49오전_1.log Patch: /media/sf_oracle/19.6/30501910/30557433 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_10-53-49오전_1.log Patch: /media/sf_oracle/19.6/30501910/30655595 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_10-53-49오전_1.log Following homes are skipped during patching as patches are not applicable: /u01/app/oracle/product/11g/db_1 OPatchauto session completed at Thu Mar 29 11:10:36 2020 Time taken to complete the session 24 minutes, 2 seconds
B) 1번 노드 DB 패치
1번 노드 DB 패치 적용
$DB_HOME/OPatch/opatchauto apply <패치 압축 해제 디렉토리>/30501910 -oh $DB_HOME
[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.6/30501910 -oh $DB_HOME OPatchauto session is initiated at Thu Mar 29 11:41:40 2020 System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-29_11-41-58AM.log. 세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-29_11-44-14AM.log입니다. 이 세션의 ID는 HQDF입니다. 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.6/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /media/sf_oracle/19.6/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /media/sf_oracle/19.6/30501910/30489227 Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_11-46-16오전_1.log Patch: /media/sf_oracle/19.6/30501910/30557433 Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_11-46-16오전_1.log OPatchauto session completed at Thu Mar 29 11:53:28 2020 Time taken to complete the session 11 minutes, 48 seconds
C) 1번 노드 패치 결과 확인
1번 노드 패치 결과 확인
grid_env opatch lspatches db_env opatch lspatches
[racdb1:/home/oracle]> grid_env [+ASM1:/home/oracle]> opatch lspatches 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. [+ASM1:/home/oracle]> db_env [racdb1:/home/oracle]> opatch lspatches 30298532;Database Patch Set Update : 11.2.0.4.200114 (30298532) 29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455) OPatch succeeded.
3. 2번 노드 패치
A) 2번 노드 Grid 패치
2번 노드 Grid 패치 적용
$GRID_HOME/OPatch/opatchauto apply <패치 압축 해제 디렉토리>/30501910
[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/19.6/30501910 OPatchauto session is initiated at Thu Mar 29 11:54:28 2020 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-29_11-54-41AM.log. 세션 로그 파일은 /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2020-03-29_11-56-31AM.log입니다. 이 세션의 ID는 CA8I입니다. 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 SUCCESSFULLY applied: Patch: /media/sf_oracle/19.6/30501910/30489227 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-02-42오후_1.log Patch: /media/sf_oracle/19.6/30501910/30489632 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-02-42오후_1.log Patch: /media/sf_oracle/19.6/30501910/30557433 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-02-42오후_1.log Patch: /media/sf_oracle/19.6/30501910/30655595 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-02-42오후_1.log Following homes are skipped during patching as patches are not applicable: /u01/app/oracle/product/11g/db_1 OPatchauto session completed at Thu Mar 29 12:21:39 2020 Time taken to complete the session 27 minutes, 11 seconds
B) 2번 노드 DB 패치
2번 노드 DB 패치 적용
$DB_HOME/OPatch/opatchauto apply <패치 압축 해제 디렉토리>/30501910 -oh $DB_HOME
[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/19.6/30501910 -oh $DB_HOME OPatchauto session is initiated at Thu Mar 29 12:35:59 2020 System initialization log file is /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-29_12-36-19PM.log. 세션 로그 파일은 /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-29_12-38-59PM.log입니다. 이 세션의 ID는 MEP1입니다. 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.6/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /media/sf_oracle/19.6/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /media/sf_oracle/19.6/30501910/30489227 Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-40-58오후_1.log Patch: /media/sf_oracle/19.6/30501910/30557433 Log: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-29_12-40-58오후_1.log OPatchauto session completed at Thu Mar 29 12:49:21 2020 Time taken to complete the session 13 minutes, 23 seconds
C) 2번 노드 패치 결과 확인
2번 노드 패치 결과 확인
grid_env opatch lspatches db_env opatch lspatches
[racdb2:/home/oracle]> grid_env [+ASM2:/home/oracle]> opatch lspatches 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. [+ASM2:/home/oracle]> db_env [racdb2:/home/oracle]> opatch lspatches 30298532;Database Patch Set Update : 11.2.0.4.200114 (30298532) 29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455) OPatch succeeded.
{}
