소스 보기

Release Update 적용

Grid 업데이트

$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 소프트웨어에 업데이트를 적용합니다.

업데이트시 클러스터를 재기동하는 과정이 진행되므로, 한 번에 하나의 노드만 업데이트합니다.

Database 업데이트

$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 유저로 업데이트를 진행하며, 한 번에 하나의 노드씩 작업을 수행합니다.

결과 확인

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

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