페이지 이력
패치 사전 준비
환경 변수 설정
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
export ORACLE_BASE=/u01/app/oracle export GRIDGI_HOME=/u01/app/19c/grid export DB_HOME=$ORACLE_BASE/product/19c/db_1 export ORACLE_HOME=$GRID$GI_HOME |
펼치기 | ||||
---|---|---|---|---|
|
OPatch 업데이트
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch version #mv $GRID$GI_HOME/OPatch $GRID$GI_HOME/OPatch.old #unzip <패치 다운로드 경로>/p6880880_122010_Linux-x86-64.zip -d $GRID$GI_HOME #chown -R oracle:oinstall $GRID$GI_HOME/OPatch #ll $GRID$GI_HOME | grep OPatch #$GRID#$GI_HOME/OPatch/opatch version |
펼치기 | ||||
---|---|---|---|---|
|
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$DB_HOME/OPatch/opatch version #mv $DB_HOME/OPatch $DB_HOME/OPatch.old #unzip <패치 다운로드 경로>/p6880880_122010_Linux-x86-64.zip -d $DB_HOME #chown -R oracle:oinstall $DB_HOME/OPatch #ll $DB_HOME | grep OPatch #$DB_HOME/OPatch/opatch version |
펼치기 | ||||
---|---|---|---|---|
|
패치 현황 조사
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch lspatches -oh $GRID$GI_HOME $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME |
펼치기 | ||||
---|---|---|---|---|
|
패치 압축 해제
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
mkdir ~oracle/patch unzip <패치번호>_190000_Linux-x86-64.zip -d ~oracle/patch |
펼치기 | ||||
---|---|---|---|---|
|
Grid 패치 충돌 여부 검증
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID$GI_HOME -phBaseDir ~oracle/patch/<패치번호>/<Database Release Update> $GRID$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID$GI_HOME -phBaseDir ~oracle/patch/<패치번호>/<OCW Release Update> $GRID$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID$GI_HOME -phBaseDir ~oracle/patch/<패치번호>/<ACFS Release Update> $GRID$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID$GI_HOME -phBaseDir ~oracle/patch/<패치번호>/<DBWLM Release Update> $GRID$GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID$GI_HOME -phBaseDir ~oracle/patch/<패치번호>/<Tomcat Release Update> |
펼치기 | ||||
---|---|---|---|---|
|
DB 패치 충돌 여부 검증
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$DB_HOME/OPatch/opatch prereq CheckConflictAmongPatchesCheckConflictAgainstOHWithDetail -oh $GRID$DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<Database<OCW Release Update> $GRID$DB_HOME/OPatch/opatch prereq CheckConflictAmongPatchesCheckConflictAgainstOHWithDetail -oh $GRID$DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<OCW<Database Release Update> $GRID |
펼치기 |
---|
서식 미적용 |
---|
[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/30116789/30122149
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2020-01-12_21-22-03오후_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[racdb1:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/30116789/30125133
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2020-01-12_21-22-12오후_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded. |
서식 미적용 |
---|
[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/30116789/30122149
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2020-01-12_21-22-20오후_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[racdb2:/home/oracle]> $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/30116789/30125133
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/oracle/product/19c/db_1
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2020-01-12_21-22-30오후_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded. |
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$DB_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<OCW Release Update>
$DB_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<Database Release Update> |
펼치기 | ||||||
---|---|---|---|---|---|---|
| ||||||
펼치기 |
서식 미적용 |
---|
[racdb1:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30122149
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-18-36오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb1:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30122167
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-18-49오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb1:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30125133
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-18-58오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb1:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/29401763
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-19-09오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded. |
서식 미적용 |
---|
[racdb2:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30122149
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-19-19오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb2:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30122167
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-19-27오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb2:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/30125133
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-19-34오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded.
[racdb2:/home/oracle]> $GRID_HOME/OPatch/opatch prereq CheckConflictAmongPatches -oh $GRID_HOME -phBaseDir ~oracle/patch/30116789/29401763
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle 홈: /u01/app/19c/grid
중앙 인벤토리: /u01/app/oraInventory
출처: /u01/app/19c/grid/oraInst.loc
OPatch 버전: 12.2.0.1.17
OUI 버전: 12.2.0.7.0
로그 파일 위치: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-01-12_21-19-42오후_1.log
Invoking prereq "checkconflictamongpatches"
Prereq "checkConflictAmongPatches" passed.
OPatch succeeded. |
DB 패치 충돌 여부 검증
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<OCW Release Update>
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $DB_HOME -phBaseDir ~oracle/patch/<패치번호>/<Database Release Update> |
|
1번 노드 패치
Grid 패치를 위한 공간 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
cat > /tmp/patch_list_gihome.txt /home/oracle/patch/<패치번호>/<Database Release Update> /home/oracle/patch/<패치번호>/<OCW Release Update> /home/oracle/patch/<패치번호>/<ACFS Release Update> /home/oracle/patch/<패치번호>/<DBWLM Release Update> /home/oracle/patch/<패치번호>/<Tomcat Release Update> <ctrl+c> $GRID$GI_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GRID$GI_HOME -phBaseFile /tmp/patch_list_gihome.txt |
펼치기 | ||
---|---|---|
|
Prepatch 수행
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/crs/install/rootcrs.sh -prepatch |
펼치기 | ||
---|---|---|
|
Grid 패치
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<Database Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<OCW Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<ACFS Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<DBWLM Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<Tomcat Release Update> |
펼치기 | ||
---|---|---|
|
DB 패치를 위한 공간 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
cat > /tmp/patch_list_dbhome.txt /home/oracle/patch/<패치번호>/<OCW Release Update> /home/oracle/patch/<패치번호>/<Database Release Update> <ctrl + c> $DB_HOME/OPatch/opatch prereq CheckSystemSpace -oh $DB_HOME -phBaseFile /tmp/patch_list_dbhome.txt |
펼치기 | ||
---|---|---|
|
DB 패치
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
~oracle/patch/<패치번호>/<OCW Release Update>/custom/scripts/prepatch.sh -dbhome $DB_HOME $DB_HOME/OPatch/opatch apply -oh $DB_HOME -local ~oracle/patch/<패치번호>/<OCW Release Update> $DB_HOME/OPatch/opatch apply -oh $DB_HOME -local ~oracle/patch/<패치번호>/<Database Release Update> ~oracle/patch/<패치번호>/<OCW Release Update>/custom/scripts/postpatch.sh -dbhome $DB_HOME |
펼치기 | ||
---|---|---|
|
Postpatch 수행
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/rdbms/install/rootadd_rdbms.sh $GRID$GI_HOME/crs/install/rootcrs.sh -postpatch |
펼치기 | ||
---|---|---|
|
패치 결과 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch lspatches -oh $GRID$GI_HOME $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME |
펼치기 | ||
---|---|---|
|
2번 노드 패치
Grid 패치를 위한 공간 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
cat > /tmp/patch_list_gihome.txt /home/oracle/patch/<패치번호>/<Database Release Update> /home/oracle/patch/<패치번호>/<OCW Release Update> /home/oracle/patch/<패치번호>/<ACFS Release Update> /home/oracle/patch/<패치번호>/<DBWLM Release Update> /home/oracle/patch/<패치번호>/<Tomcat Release Update> <ctrl+c> $GRID$GI_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GRID$GI_HOME -phBaseFile /tmp/patch_list_gihome.txt |
펼치기 | ||
---|---|---|
|
Prepatch 수행
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/crs/install/rootcrs.sh -prepatch |
펼치기 | ||
---|---|---|
|
Grid 패치
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<Database Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<OCW Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<ACFS Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<DBWLM Release Update> $GRID$GI_HOME/OPatch/opatch apply -oh $GRID$GI_HOME -local ~oracle/patch/<패치번호>/<Tomcat Release Update> |
펼치기 | ||
---|---|---|
|
DB 패치를 위한 공간 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
cat > /tmp/patch_list_dbhome.txt /home/oracle/patch/<패치번호>/<OCW Release Update> /home/oracle/patch/<패치번호>/<Database Release Update> <ctrl + c> $DB_HOME/OPatch/opatch prereq CheckSystemSpace -oh $DB_HOME -phBaseFile /tmp/patch_list_dbhome.txt |
펼치기 | ||
---|---|---|
|
DB 패치
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
~oracle/patch/<패치번호>/<OCW Release Update>/custom/scripts/prepatch.sh -dbhome $DB_HOME $DB_HOME/OPatch/opatch apply -oh $DB_HOME -local ~oracle/patch/<패치번호>/<OCW Release Update> $DB_HOME/OPatch/opatch apply -oh $DB_HOME -local ~oracle/patch/<패치번호>/<Database Release Update> ~oracle/patch/<패치번호>/<OCW Release Update>/custom/scripts/postpatch.sh -dbhome $DB_HOME |
펼치기 | ||
---|---|---|
|
Postpatch 수행
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/rdbms/install/rootadd_rdbms.sh $GRID$GI_HOME/crs/install/rootcrs.sh -postpatch |
펼치기 | ||
---|---|---|
|
패치 결과 확인
코드 블럭 | ||||||
---|---|---|---|---|---|---|
| ||||||
$GRID$GI_HOME/OPatch/opatch lspatches -oh $GRID$GI_HOME $DB_HOME/OPatch/opatch lspatches -oh $DB_HOME |
펼치기 | ||
---|---|---|
|
...