패치 전 준비

환경 변수 설정

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




OPatch 업데이트

$GRID_HOME/OPatch/opatch version
mv $GRID_HOME/OPatch $GRID_HOME/OPatch.old
unzip /media/sf_oracle/19.6/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/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.




1번 노드 패치

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




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




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.




2번 노드 패치

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




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




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.