페이지 이력

버전 비교

키

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

패치 전 준비

환경 변수 설정

코드 블럭

language	bash
title	root 계정 환경 변수 설정
linenumbers	true

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 업데이트

코드 블럭

language	bash
title	$GRID_HOME의 OPatch 업데이트
linenumbers	true

$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.

코드 블럭

language	bash
title	$DB_HOME의 OPatch 업데이트
linenumbers	true

$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 패치

코드 블럭

language	bash
title	1번 노드 Grid 패치 적용
linenumbers	true

$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 패치

코드 블럭

language	bash
title	1번 노드 DB 패치 적용
linenumbers	true

$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번 노드 패치 결과 확인

코드 블럭

language	bash
title	1번 노드 패치 결과 확인
linenumbers	true

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 패치

코드 블럭

language	bash
title	2번 노드 Grid 패치 적용
linenumbers	true

$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 패치

코드 블럭

language	bash
title	2번 노드 DB 패치 적용
linenumbers	true

$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번 노드 패치 결과 확인

코드 블럭

language	bash
title	2번 노드 패치 결과 확인
linenumbers	true

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.

Content

공간 도구

버전 비교

이전 버전 2

새 버전 3

키

패치 전 준비

환경 변수 설정

OPatch 업데이트

1번 노드 패치

1번 노드 Grid 패치

1번 노드 DB 패치

1번 노드 패치 결과 확인

2번 노드 패치

2번 노드 Grid 패치

2번 노드 DB 패치

2번 노드 패치 결과 확인