페이지 이력

버전 비교

키

이 줄이 추가되었습니다.
이 줄이 삭제되었습니다.
서식이 변경되었습니다.

...

펼치기

1번 노드

서식 미적용

[root@rac1 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009 -oh $DB_HOME

OPatchauto session is initiated at Tue Feb 13 07:18:01 2018

System initialization log file is /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchautodb/systemconfig2018-02-13_07-18-19AM.log.

Session log file is /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/opatchauto2018-02-13_07-18-55AM.log
The id for this session is FYWH

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service


Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-13_07-19-53AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-13_07-19-53AM_1.log



OPatchauto session completed at Tue Feb 13 07:21:57 2018
Time taken to complete the session 3 minutes, 56 seconds

2번 노드

서식 미적용

[root@rac2 ~]# $DB_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009 -oh $DB_HOME

OPatchauto session is initiated at Tue Feb 13 07:22:21 2018

System initialization log file is /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchautodb/systemconfig2018-02-13_07-22-37AM.log.

Session log file is /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/opatchauto2018-02-13_07-23-14AM.log
The id for this session is TSKJ

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service


Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
No step execution required.........
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-13_07-24-00AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-13_07-24-00AM_1.log



OPatchauto session completed at Tue Feb 13 07:25:53 2018
Time taken to complete the session 3 minutes, 33 seconds

Database 생성 후 패치

Grid와 DBMS 패치

패치 사전 분석

코드 블럭

language	bash
title	root 유저로 수행

$GRID_HOME/OPatch/opatchauto apply <패치 압축 해제 경로>/27100009 -analyze

...

펼치기code

1번 노드

language	bash
title	root 유저로 수행

서식 미적용

[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009 -analyze

OPatchauto session is initiated at Sun Feb 18 04:21:35 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-18_04-21-51AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-18_04-23-18AM.log
The id for this session is FBRU

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1

Following step failed during analysis:
 /bin/sh -c 'cd /u01/app/oracle/product/12.2.0/db_1; ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 ORACLE_SID=racdb1 /u01/app/oracle/product/12.2.0/db_1/OPatch/datapatch -prereq -verbose'

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac1
RAC Home:/u01/app/oracle/product/12.2.0/db_1


==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
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/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log


Host:rac1
CRS Home:/u01/app/12.2.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-23-39AM_1.log



OPatchauto session completed at Sun Feb 18 04:28:08 2018
Time taken to complete the session 6 minutes, 33 seconds

2번 노드

서식 미적용

[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009 -analyze

OPatchauto session is initiated at Sun Feb 18 04:44:12 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-18_04-44-26AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-18_04-45-26AM.log
The id for this session is K8D1

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:rac2
RAC Home:/u01/app/oracle/product/12.2.0/db_1


==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
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/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-46AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-46AM_1.log


Host:rac2
CRS Home:/u01/app/12.2.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-47AM_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-47AM_1.log

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-47AM_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-47AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_04-45-47AM_1.log



OPatchauto session completed at Sun Feb 18 04:51:50 2018
Time taken to complete the session 7 minutes, 38 seconds

패치 적용

코드 블럭

language	bash
title	root 유저로 수행

$GRID_HOME/OPatch/opatchauto apply <패치 압축 해제 경로>/27100009

펼치기

1번 노드

서식 미적용

[root@rac1 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009

OPatchauto session is initiated at Sun Feb 18 04:52:46 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-18_04-53-00AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-18_04-54-05AM.log
The id for this session is M2XH

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
"/bin/sh -c 'cd /u01/app/oracle/product/12.2.0/db_1; ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 ORACLE_SID=racdb1 /u01/app/oracle/product/12.2.0/db_1/OPatch/datapatch -prereq -verbose'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be analyzed by manually retrying the same command.

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service


Bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/rac1/crsconfig/crspatch_rac1_2018-02-18_04-58-55AM.log
CRS service brought down successfully on home /u01/app/12.2.0/grid


Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/12.2.0/grid
Binary patch applied successfully on home /u01/app/12.2.0/grid


Starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/rac1/crsconfig/crspatch_rac1_2018-02-18_05-11-41AM.log
CRS service started successfully on home /u01/app/12.2.0/grid


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
"/bin/sh -c 'cd /u01/app/oracle/product/12.2.0/db_1;ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 ORACLE_SID=racdb1 /u01/app/oracle/product/12.2.0/db_1/OPatch/datapatch -verbose'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command.

SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-02-13AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-02-13AM_1.log


Host:rac1
CRS Home:/u01/app/12.2.0/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-04-21AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-04-21AM_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-04-21AM_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-04-21AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-04-21AM_1.log



OPatchauto session completed at Sun Feb 18 05:31:59 2018
Time taken to complete the session 39 minutes, 13 seconds

2번 노드

서식 미적용

[root@rac2 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009

OPatchauto session is initiated at Sun Feb 18 05:39:36 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-18_05-39-51AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-18_05-41-00AM.log
The id for this session is VYY4

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service


Bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/rac2/crsconfig/crspatch_rac2_2018-02-18_05-47-27AM.log
CRS service brought down successfully on home /u01/app/12.2.0/grid


Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/12.2.0/grid
Binary patch applied successfully on home /u01/app/12.2.0/grid


Starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/rac2/crsconfig/crspatch_rac2_2018-02-18_05-58-18AM.log
CRS service started successfully on home /u01/app/12.2.0/grid


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-49-09AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-49-09AM_1.log


Host:rac2
CRS Home:/u01/app/12.2.0/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-51-28AM_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-51-28AM_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-51-28AM_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-51-28AM_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-18_05-51-28AM_1.log



OPatchauto session completed at Sun Feb 18 06:16:40 2018
Time taken to complete the session 37 minutes, 5 seconds

datapatch

dataptch 적용 여부 확인

Database 생성 후, 수행한 opatchauto가 정상적으로 완료되었다면 datapatch도 함께 적용되어 있습니다.

코드 블럭

title	Database에 접속한 후 수행

select PATCH_ID, VERSION, ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;

펼치기

서식 미적용

SQL> select PATCH_ID, VERSION, ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;

  PATCH_ID VERSION              ACTION          STATUS          ACTION_TIME
---------- -------------------- --------------- --------------- ---------------------------------------------------------------------------
  27105253 12.2.0.1             APPLY           SUCCESS         18/02/18 06:16:19.709718

datapatch 적용

datapatch가 적용되지 않은 경우에만 수행합니다.

적용할 PDB를 모두 open시킨 후에 수행해야하며, close 상태인 PDB에는 datapatch가 적용되지 않습니다.

코드 블럭

language	bash
title	oracle 유저로 한번만 수행

datapatch -verbose <패치 압축 해제 경로>/27100009

패치 결과 확인

Grid 패치 결과 확인

코드 블럭

language	bash
title	grid 유저로 수행

$GRID_HOME/OPatch/opatch lsinventory -detail

...

Content

공간 도구

버전 비교

이전 버전 4

새 버전 5

키

Database 생성 후 패치

Grid와 DBMS 패치

datapatch

패치 결과 확인