Oracle Linux 7.6에 Oracle 19c 설치와 동시에 패치(applyRU)

환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.11.0.0

 

방법 : Oracle Linux 7.6에 Oracle 19c 설치와 동시에 패치(applyRU)

기존에는 rac 설치 시 grid 설치, db엔진 설치 후 패치를 적용시켜주는 방식이었지만

oracle 18c 부터 db 엔진이나 grid 엔진을 설치 할 때 패치도 같이 적용 시킬 수 있는 옵션이 생김

설치 상세 가이드는 아래 게시글 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1

https://positivemh.tistory.com/522

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1

 

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

https://positivemh.tistory.com/523

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

 

 

방법

grid 엔진 설치시
$ cd $GRID_HOME
$ ./gridSetup.sh -applyRU 패치파일경로
 
db 엔진 설치시
$ cd $ORACLE_HOME
$ ./runInstaller -applyRU 패치파일경로

 

 

실제 적용

설치파일

GRID : LINUX.X64_193000_grid_home.zip

DB : LINUX.X64_193000_db_home.zip

OPatch : p6880880_190000_Linux-x86-64.zip(12.2.0.1.24)

RU : Patch 32578973 - Combo of OJVM Component Release Update 19.11.0.0.210420 + Grid Infrastructure Apr 2021 Release Update 19.11.0.0.210420

 ㄴ Patch 32545008 - Database Grid Infrastructure Apr 2021 Release Update 19.11.0.0.210420
 ㄴ Patch 32399816 - Oracle JavaVM Component Release Update 19.11.0.0.210420

 

 

grid 설치

설치파일 압축 해제 및 OPatch 최신버전으로 교체

$ cd $GRID_HOME
$ unzip /ORA19/media/LINUX.X64_193000_grid_home.zip
$ mv OPatch/ OPatchold
$ unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip

 

 

패치파일 압축 해제

$ /ORA19/media
$ unzip p32578973_190000_Linux-x86-64.zip
$ cd 32578973
$ ls
32399816  32545008  PatchSearch.xml  README.html
$ cd 32545008
$ pwd
/ORA19/media/32578973/32545008

 

 

grid 설치(동시에 패치까지 진행)

$ cd $GRID_HOME
$ ./gridSetup.sh -applyRU /ORA19/media/32578973/32545008/
Preparing the home to patch...
Applying the patch /ORA19/media/32578973/32545008/...
(자동으로 패치 적용 후 GUI 창이 나타남)

gui가 로딩되기까지 시간이 조금 걸림

 

 

gui 설치 아래 게시글 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1

https://positivemh.tistory.com/522

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1

 

 

설치 완료

$ ./gridSetup.sh -applyRU /ORA19/media/32578973/32545008/
Preparing the home to patch...
Applying the patch /ORA19/media/32578973/32545008/...
Successfully applied the patch.
The log can be found at: /tmp/GridSetupActions2021-05-24_07-28-56PM/installerPatchActions_2021-05-24_07-28-56PM.log
Launching Oracle Grid Infrastructure Setup Wizard...
 
The response file for this session can be found at:
 /ORA19/app/grid/19c/install/response/grid_2021-05-24_07-28-56PM.rsp
 
You can find the log of this install session at:
 /tmp/GridSetupActions2021-05-24_07-28-56PM/gridSetupActions2021-05-24_07-28-56PM.log
Moved the install session logs to:
 /ORA19/app/oraInventory/logs/GridSetupActions2021-05-24_07-28-56PM

 

 

grid 설치 후 점검

$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       oel19db1                 STABLE
               ONLINE  ONLINE       oel19db2                 STABLE
ora.chad
               ONLINE  ONLINE       oel19db1                 STABLE
               ONLINE  ONLINE       oel19db2                 STABLE
ora.net1.network
               ONLINE  ONLINE       oel19db1                 STABLE
               ONLINE  ONLINE       oel19db2                 STABLE
ora.ons
               ONLINE  ONLINE       oel19db1                 STABLE
               ONLINE  ONLINE       oel19db2                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oel19db1                 STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 Started,STABLE
      2        ONLINE  ONLINE       oel19db2                 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
ora.cvu
      1        ONLINE  ONLINE       oel19db1                 STABLE
ora.oel19db1.vip
      1        ONLINE  ONLINE       oel19db1                 STABLE
ora.oel19db2.vip
      1        ONLINE  ONLINE       oel19db2                 STABLE
ora.qosmserver
      1        ONLINE  ONLINE       oel19db1                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oel19db1                 STABLE
--------------------------------------------------------------------------------

 

 

grid 패치 버전 확인

$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)
32584670;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32584670)
32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761)
32576499;ACFS RELEASE UPDATE 19.11.0.0.0 (32576499)
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
 
OPatch succeeded.

정상적으로 19.11로 패치+설치됨

 

 

ASMCA 디스크 그룹 추가

asmca 디스크 그룹 추가 아래 게시글 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

https://positivemh.tistory.com/523

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

 

 

db 엔진 설치

설치파일 압축 해제 및 OPatch 최신버전으로 교체

$ cd $ORACLE_HOME
$ unzip /ORA19/media/LINUX.X64_193000_db_home.zip
$ mv OPatch/ OPatchold
$ unzip /ORA19/media/p6880880_190000_Linux-x86-64.zip

 

 

db 엔진 설치(동시에 패치까지 진행)

$ cd $ORACLE_HOME
$ ./runInstaller -applyRU /ORA19/media/32578973/32545008/
Preparing the home to patch...
Applying the patch /ORA19/media/32578973/32545008/...
(자동으로 패치 적용 후 GUI 창이 나타남)

gui가 로딩되기까지 시간이 조금 걸림

 

 

gui 설치 아래 게시글 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

https://positivemh.tistory.com/523

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

 

 

db 엔진 패치버전 확인

$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761)
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
 
OPatch succeeded.

정상적으로 19.11로 패치+설치됨

 

 

ojvm 패치

ojvm 패치 경로로 이동 후 패치 진행(양쪽 노드 모두 진행)

$ cd /ORA19/media/32578973/32399816/
$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/app/oracle/product/19c
Central Inventory : /ORA19/app/oraInventory
   from           : /oracle/app/oracle/product/19c/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/cfgtoollogs/opatch/opatch2021-05-24_21-03-08PM_1.log
 
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32399816  
 
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 = '/oracle/app/oracle/product/19c')
 
 
Is the local system ready for patching? [y|n]
y <-- [y 입력]
User Responded with: Y
Backing up files...
Applying interim patch '32399816' to OH '/oracle/app/oracle/product/19c'
 
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...
 
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 32399816 successfully applied.
Log file location: /oracle/app/oracle/product/19c/cfgtoollogs/opatch/opatch2021-05-24_21-03-08PM_1.log
 
OPatch succeeded.

 

 

패치 버전 확인

$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
32399816;OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)
32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761)
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
 
OPatch succeeded.

정상적으로 ovjm도 19.11로 패치됨

 

 

db 생성

dbca

$ dbca

 

 

gui 설치 아래 게시글 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

https://positivemh.tistory.com/523

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2

 

 

db 기동 후 패치 적용

$ cd $ORACLE_HOME/OPatch
$ datapatch -verbose

 

 

참조 : https://pat98.tistory.com/1038

https://docs.oracle.com/en/database/oracle/oracle-database/18/rilin/applying-patches-during-database-install-or-upgrade.html#GUID-9E8DC4A7-4DCD-4BF7-A476-434B1B047418

https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/applying-patches-during-oracle-grid-infrastructure-install-or-upgrade.html#GUID-D10C7B8D-A120-48A2-8237-36809D0DB21E

https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/apply-patches-during-db-install.html#GUID-9E8DC4A7-4DCD-4BF7-A476-434B1B047418

1410202.1