내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.3.0.0
방법 : Oracle 19c RAC OPatch Release Update 적용 가이드
최신 OPatch 파일
p6880880_190000_Linux-x86-64.zip
패치 파일
p30501910_190000_Linux-x86-64.zip -- GRID, DB
p30484981_190000_Linux-x86-64.zip -- OJVM
적용 전 꼭 패치 파일 안에 있는 README 파일을 읽어보길 권장함
아래 작업은 rac 설치 중 grid 설치 후 db 엔진(runInstall) 설치 후 진행하였음
p30501910
패치명 |
패치 번호 |
패치 대상 |
Database Release Update 19.6.0.0.200114 |
30557433 |
Non RAC 환경에서는 DB만 해당, RAC 환경에서는 DB, GRID 모두 해당 |
OCW Release Update 19.6.0.0.200114 |
30489227 |
DB, GRID 모두 해당 |
ACFS Release Update 19.6.0.0.200114 Footnote2 |
30489632 |
GRID만 해당 |
Tomcat Release Update 19.0.0.0.0Footnote 2 |
30655595 |
GRID만 해당 |
OPatch 최신파일 업로드
기존 OPatch 버전 확인
1 2 3 4 5 6 7 8 9 10 11 | GRID $ $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. DB $ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. |
최신 OPatch 파일 업로드
1번, 2번노드 모두 업로드 후 진행
p6880880_190000_Linux-x86-64.zip 미디어 업로드
/ORA19/media
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | GRID # mv $GRID_HOME/OPatch $GRID_HOME/OPatch_old # unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip -d $GRID_HOME/ # chown -R oracle:dba $GRID_HOME/OPatch # ls -al $GRID_HOME | grep OPatch drwxr-x--- 14 oracle dba 4096 Dec 19 00:56 OPatch drwxr-x--- 14 oracle dba 4096 Mar 4 07:38 OPatch_old DB # export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1 # mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old # unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME/ # chown -R oracle:dba $ORACLE_HOME/OPatch # ls -al $ORACLE_HOME | grep OPatch drwxr-x--- 14 oracle dba 4096 Dec 19 00:56 OPatch drwxr-x--- 14 oracle dba 4096 Dec 19 00:56 OPatch_old |
Opatch 버전 확인
1 2 3 4 5 6 7 8 9 10 11 | GRID $ $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded. DB $ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.19 OPatch succeeded. |
제일 뒷자리가 17에서 19로 변함
GRID, DB 업데이트
기존 패치 내역 확인(oracle 계정으로 확인)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | GRID $ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) OPatch succeeded. DB $ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) OPatch succeeded. |
업데이트 파일 압축해제
1 2 | $ cd /ORA19/media/ $ unzip p30501910_190000_Linux-x86-64.zip |
GRID 업데이트 사전 검증(충돌 여부 검증)
1 2 3 4 | $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489227 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489632 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30557433 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30655595 |
GRID 업데이트 사전 검증(충돌 여부 검증) log
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 | $ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489227 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/grid/19.3.0 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/grid/19.3.0/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-06-37AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. $ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30489632 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/grid/19.3.0 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/grid/19.3.0/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-01AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. $ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30557433 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/grid/19.3.0 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/grid/19.3.0/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-12AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. $ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $GRID_HOME -phBaseDir /ORA19/media/30501910/30655595 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/grid/19.3.0 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/grid/19.3.0/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_04-07-33AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. |
GRID 업데이트 필요 공간 확인(oracle 계정으로 실행)
/tmp/patch_list_grid.txt 파일 생성
업데이트 파일 경로 작성 후 저장
1 2 3 4 5 | $ cat /tmp/patch_list_grid.txt /ORA19/media/30501910/30489227 /ORA19/media/30501910/30489632 /ORA19/media/30501910/30557433 /ORA19/media/30501910/30655595 |
OPatch CheckSystemSpace 명령으로 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | $ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -oh $GRID_HOME -phBaseFile /tmp/patch_list_grid.txt Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/grid/19.3.0 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/grid/19.3.0/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/grid/19.3.0/cfgtoollogs/opatch/opatch2020-03-08_10-25-58AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. |
GRID 업데이트 사전 분석(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | # $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME -analyze OPatchauto session is initiated at Sun Mar 8 10:45:17 2020 System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-08_10-45-25AM.log. Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-08_10-45-50AM.log The id for this session is KMPY Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0 Patch applicability verified successfully on home /ORA19/app/grid/19.3.0 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:oel19db1 CRS Home:/ORA19/app/grid/19.3.0 Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log Patch: /ORA19/media/30501910/30489632 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log Patch: /ORA19/media/30501910/30655595 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-46-48AM_1.log OPatchauto session completed at Sun Mar 8 10:48:15 2020 Time taken to complete the session 2 minutes, 58 seconds |
DB 업데이트 사전 검증(충돌 여부 검증)
1 2 | $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30557433 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30489227 |
DB 업데이트 사전 검증(충돌 여부 검증) log
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | log $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30557433 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/oracle/product/19.3.0/db_1 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-38-43AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /ORA19/media/30501910/30489227 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/oracle/product/19.3.0/db_1 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-38-55AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. |
DB 업데이트 필요 공간 확인(oracle 계정으로 실행)
/tmp/patch_list_db.txt 파일 생성
업데이트 파일 경로 작성 후 저장
1 2 3 | $ cat /tmp/patch_list_db.txt /ORA19/media/30501910/30557433 /ORA19/media/30501910/30489227 |
OPatch CheckSystemSpace 명령으로 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | $ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -oh $ORACLE_HOME -phBaseFile /tmp/patch_list_db.txt Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/oracle/product/19.3.0/db_1 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-08_10-42-24AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. |
DB 업데이트 사전 분석(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | # export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1 # $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME -analyze OPatchauto session is initiated at Sun Mar 8 10:51:52 2020 System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-08_10-52-18AM.log. Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-08_10-53-33AM.log The id for this session is QSBI Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:oel19db1 RAC Home:/ORA19/app/oracle/product/19.3.0/db_1 Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /ORA19/media/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /ORA19/media/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-55-23AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-08_10-55-23AM_1.log OPatchauto session completed at Sun Mar 8 10:56:30 2020 Time taken to complete the session 4 minutes, 39 seconds |
GRID 업데이트 적용 1번노드(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 | # $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME OPatchauto session is initiated at Mon Mar 9 07:31:46 2020 System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-09_07-32-19AM.log. Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-09_07-33-26AM.log The id for this session is X9DG Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0 Patch applicability verified successfully on home /ORA19/app/grid/19.3.0 Bringing down CRS service on home /ORA19/app/grid/19.3.0 CRS service brought down successfully on home /ORA19/app/grid/19.3.0 Start applying binary patch on home /ORA19/app/grid/19.3.0 Binary patch applied successfully on home /ORA19/app/grid/19.3.0 Starting CRS service on home /ORA19/app/grid/19.3.0 CRS service started successfully on home /ORA19/app/grid/19.3.0 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:oel19db1 CRS Home:/ORA19/app/grid/19.3.0 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log Patch: /ORA19/media/30501910/30489632 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log Patch: /ORA19/media/30501910/30655595 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_07-40-53AM_1.log OPatchauto session completed at Mon Mar 9 07:53:16 2020 Time taken to complete the session 21 minutes, 32 seconds |
GRID 업데이트 적용 2번노드(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 | # $GRID_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $GRID_HOME OPatchauto session is initiated at Mon Mar 9 07:57:54 2020 System initialization log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchautodb/systemconfig2020-03-09_07-58-10AM.log. Session log file is /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/opatchauto2020-03-09_07-59-24AM.log The id for this session is J81A Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/grid/19.3.0 Patch applicability verified successfully on home /ORA19/app/grid/19.3.0 Bringing down CRS service on home /ORA19/app/grid/19.3.0 CRS service brought down successfully on home /ORA19/app/grid/19.3.0 Start applying binary patch on home /ORA19/app/grid/19.3.0 Binary patch applied successfully on home /ORA19/app/grid/19.3.0 Starting CRS service on home /ORA19/app/grid/19.3.0 CRS service started successfully on home /ORA19/app/grid/19.3.0 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:oel19db2 CRS Home:/ORA19/app/grid/19.3.0 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log Patch: /ORA19/media/30501910/30489632 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log Patch: /ORA19/media/30501910/30655595 Log: /ORA19/app/grid/19.3.0/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_08-05-37AM_1.log OPatchauto session completed at Mon Mar 9 08:18:40 2020 Time taken to complete the session 20 minutes, 48 seconds |
GRID 업데이트 확인(oracle 계정으로 확인)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 1번 노드 $ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME 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. 2번 노드 $ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME 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. |
DB 업데이트 적용 1번노드(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | # export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1 # $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME OPatchauto session is initiated at Tue Mar 10 04:52:51 2020 System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-10_04-52-58AM.log. Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-10_04-53-45AM.log The id for this session is FR67 Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... Preparing to bring down database service on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... Performing prepatch operation on home /ORA19/app/oracle/product/19.3.0/db_1 Perpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Start applying binary patch on home /ORA19/app/oracle/product/19.3.0/db_1 Binary patch applied successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Performing postpatch operation on home /ORA19/app/oracle/product/19.3.0/db_1 Postpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Preparing home /ORA19/app/oracle/product/19.3.0/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:oel19db1 RAC Home:/ORA19/app/oracle/product/19.3.0/db_1 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_04-54-40AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_05-29-22AM_1.log OPatchauto session completed at Tue Mar 10 05:02:25 2020 Time taken to complete the session 12 minutes, 34 seconds |
DB 업데이트 적용 2번노드(root 계정으로 실행)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | # export ORACLE_HOME=/ORA19/app/oracle/product/19.3.0/db_1 # $ORACLE_HOME/OPatch/opatchauto apply /ORA19/media/30501910 -oh $ORACLE_HOME OPatchauto session is initiated at Tue Mar 10 08:51:44 2020 System initialization log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-10_08-51-53AM.log. Session log file is /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-10_08-52-29AM.log The id for this session is 1H4M Executing OPatch prereq operations to verify patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Verifying SQL patch applicability on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... Preparing to bring down database service on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... Performing prepatch operation on home /ORA19/app/oracle/product/19.3.0/db_1 Perpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Start applying binary patch on home /ORA19/app/oracle/product/19.3.0/db_1 Binary patch applied successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Performing postpatch operation on home /ORA19/app/oracle/product/19.3.0/db_1 Postpatch operation completed successfully on home /ORA19/app/oracle/product/19.3.0/db_1 Preparing home /ORA19/app/oracle/product/19.3.0/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /ORA19/app/oracle/product/19.3.0/db_1 No step execution required......... OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:oel19db2 RAC Home:/ORA19/app/oracle/product/19.3.0/db_1 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /ORA19/media/30501910/30489227 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_08-53-09AM_1.log Patch: /ORA19/media/30501910/30557433 Log: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_08-57-56AM_1.log OPatchauto session completed at Tue Mar 10 09:12:01 2020 Time taken to complete the session 14 minutes, 18 seconds |
DB 업데이트 확인(oracle 계정으로 확인)
1 2 3 4 5 6 7 8 9 10 11 12 13 | 1번 노드 $ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME 30557433;Database Release Update : 19.6.0.0.200114 (30557433) 30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227) OPatch succeeded. 2번 노드 $ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME 30557433;Database Release Update : 19.6.0.0.200114 (30557433) 30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227) OPatch succeeded. |
패치 내역 확인(oracle 계정으로 확인)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | GRID $ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME 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. DB $ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME 30557433;Database Release Update : 19.6.0.0.200114 (30557433) 30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227) OPatch succeeded. |
패치 내역 비교
OJVM 패치 (옵션)
기존 패치 내역 확인(oracle 계정으로 확인)
1 2 3 4 5 | $ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME 30557433;Database Release Update : 19.6.0.0.200114 (30557433) 30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227) OPatch succeeded. |
패치파일 압축해제 1번, 2번 노드 모두진행
1 2 3 4 | # chown oracle:dba /ORA19/media/p30484981_190000_Linux-x86-64.zip # su - oracle $ cd /ORA19/media $ unzip p30484981_190000_Linux-x86-64.zip |
OJVM 패치 사전 분석(oracle 계정으로 확인) 1번, 2번 노드 모두진행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /ORA19/media/30484981 Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /ORA19/app/oracle/product/19.3.0/db_1 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-49-49PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. |
OJVM 패치(oracle 계정으로 실행) 1번, 2번 노드 모두진행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | $ cd /ORA19/media/30484981/ $ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /ORA19/app/oracle/product/19.3.0/db_1 Central Inventory : /ORA19/app/oraInventory from : /ORA19/app/oracle/product/19.3.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-51-50PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30484981 Do you want to proceed? [y|n] y <-- y입력 User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/ORA19/app/oracle/product/19.3.0/db_1') Is the local system ready for patching? [y|n] y <-- y입력 User Responded with: Y Backing up files... Applying interim patch '30484981' to OH '/ORA19/app/oracle/product/19.3.0/db_1' Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.javavm.server.core, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0... Patch 30484981 successfully applied. Log file location: /ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_20-51-50PM_1.log OPatch succeeded. |
OJVM 패치 결과 확인
1 2 3 4 5 6 | $ $ORACLE_HOME/OPatch/opatch lspatches 30484981;OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981) 30557433;Database Release Update : 19.6.0.0.200114 (30557433) 30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227) OPatch succeeded. |
기존에 없던 OJVM RELEASE UPDATE가 생긴것을 확인 할 수 있음
참조 : https://dataforum.io/display/ORCL/Oracle+Database+19c+Real+Application+Cluster
p30501910의 README.html
https://positivemh.tistory.com/522
https://positivemh.tistory.com/523
'ORACLE > Install' 카테고리의 다른 글
Oracle Linux 7.6에 Oracle 18c 에서 Oracle 19c로 AutoUpgrade 가이드 (0) | 2020.03.24 |
---|---|
Oracle Linux 6.8에 Oracle 11g R2 환경 OS Watcher 설치 가이드 (0) | 2020.03.11 |
Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2 (22) | 2020.03.02 |
Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1 (42) | 2020.03.01 |
Oracle 19c 컴포넌트 추가 설치 방법 (0) | 2020.02.09 |