| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
Tags
- Oracle 19c
- 오라클구조
- 오라클설치
- 디비투
- adg
- 오라클
- oracle recovery
- 오라클아키텍쳐
- goldengate
- 19c
- SSH
- diskgroup
- 티베로
- oracle goldengate
- ORACLE19C
- SILENTMODE
- 오지지
- 데이터가드
- Oracle
- 데이터베이스
- OracleGoldenGate
- ActiveDataGuard
- Installation
- Opatch
- 사일런트모드
- ogg
- Database
- linux
- oracle installation
- DataGuard
Archives
- Today
- Total
DoubleDBDeep
[ORACLE] Oracle Database 19c RAC 설치 & 19.17 patch 본문
ADG test를 위한 19.17 oracle RAC 설치 (Standby DB server)
| OS / ORACLE ENVIRONMENT | |
| EDITION | EE |
| RAC | RAC 2 NODE |
| VERSION | Oracle Database19c |
| PATCH | 34416665 (19.17.0.0.0) |
| SERVER | Linux 7.9 (5.4.17-2102.201.3.el7uek.x86_64) |
Media 준비
- 엔진 : https://www.oracle.com/kr/database/technologies/oracle-database-software-downloads.html
- Patch Set : support.oracle.com (opatch number : p6880880 / GI patch number : 34416665)
환경 구성
서버
| VM | HOSTNAME | Memory | Net Adapter 1 | Net Adapter 2 | 구성 방법 |
| racdr1 | racdr1 | 10GB | 어댑터에 브리지 | 호스트 전용 어댑터 | linux 설치 |
| racdr2 | racdr2 | 10GB | 어댑터에 브리지 | 호스트 전용 어댑터 | RAC 복제 |
스토리지
| 파일 이름 | 용량 | 타입 | 용도 |
| RACDR1.VDI | 100GB | Dynamic / Normal | RACDR1 NODE STORAGE |
| RACDR2.VDI | 100GB | Dynamic / Normal | RACDR2 NODE STORAGE |
| CRS1.VDI | 3GB | Fixed / Shareable | OCR / Vote 저장 영역 |
| CRS2.VDI | 3GB | Fixed / Shareable | |
| CRS3.VDI | 3GB | Fixed / Shareable | |
| CRS4.VDI | 30GB | Fixed / Shareable | OCR / Vote 저장 영역 Primary Server와 동일하게 구성하기 위함 |
| DATA.VDI | 50GB | Fixed / Shareable | DATA 영역 |
| FRA.VDI | 30GB | Fixed / Shareable | FAST RECOVERY AREA |
네트워크 (vi /etc/hosts)
| VM | PUBLIC IP | PRIVATE IP | VIRTUAL IP | NETMASK | GATEWAY | DNS | SCAN IP |
| RACDR1 | 192.168.0.27 | 192.168.56.101 | 192.168.0.201 | 255.255.255.0 | 192.168.0.1 | 127.0.0.1 | 192.168.0.191 192.168.0.192 192.168.0.193 |
| RACDR2 | 192.168.0.32 | 192.168.56.102 | 192.168.0.202 | 255.255.255.0 | 192.168.0.1 | 127.0.0.1 |
SELINUX 설정
[racdr1|root:/root]> vi /etc/selinux/config
SELINUX=permissive
[racdr1|root:/root]> setenforce permissive
hostname 설정
[root@racdb1 rpm]# vi /etc/hostname
racdr1
[root@racdb1 rpm]# hostnamectl set-hostname racdr1
[root@racdb1 rpm]# hostnamectl status
Static hostname: racdr1
Icon name: computer-vm
Chassis: vm
Machine ID: bcd5407e6717e14ebb1a639ce33dd5b4
Boot ID: 7c884827875343d996ce15331495d9c9
Virtualization: kvm
Operating System: Oracle Linux Server 7.9
CPE OS Name: cpe:/o:oracle:linux:7:9:server
Kernel: Linux 5.4.17-2102.201.3.el7uek.x86_64
Architecture: x86-64프로세스 정리
systemctl stop bluetooth.service
systemctl disable bluetooth.service
systemctl stop firewalld
systemctl disable firewalld
systemctl stop chronyd
systemctl disable chronyd
systemctl stop ntpdate
systemctl disable ntpdate
systemctl stop avahi-daemon
systemctl disable avahi-daemon
systemctl stop libvirtd
systemctl disable libvirtd.service디렉토리 및 유저 생성
# group 생성
groupadd dba
# oracle 유저생성
useradd -g dba -G dba oracle
# oracle 유저 password 설정
passwd oracle# oracle home directory 생성
mkdir -p /u01/app/oracle/product/19c/db_1
# grid home directory 생성
mkdir -p /u01/app/19c/grid
# media directory 생성
mkdir -p /u01/media/engine/19c
mkdir -p /u01/media/patch/19c
mkdir -p /u01/media/rpm설치 파일 및 패키지 업로드
# 패치파일 업로드 후 권한 조정
chown -R oracle:dba /u01
chmod -R 775 /u01패키지 설치
[root@racdb1 ~]# cd /u01/media/rpm
[root@racdb1 rpm]# ls -al
total 2631512
drwxrwxr-x. 2 oracle dba 53 Mar 23 08:45 .
drwxrwxr-x. 5 oracle dba 44 Mar 23 08:44 ..
-rw-r--r--. 1 root root 903336 Mar 23 08:55 ksh-20120801-142.0.1.el7.x86_64.rpm
-rw-r--r--. 1 root root 12624 Mar 23 08:55 libaio-devel-0.3.109-13.el7.x86_64.rpm
-rw-r--r--. 1 oracle dba 2694664264 Mar 23 08:47 oracle-database-ee-19c-1.0-1.x86_64.rpm
-rw-r--r--. 1 root root 19552 Mar 23 08:55 oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm
[root@racdb1 rpm]# rpm -ivh ksh-20120801-142.0.1.el7.x86_64.rpm
warning: ksh-20120801-142.0.1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:ksh-20120801-142.0.1.el7 ################################# [100%]
[root@racdb1 rpm]# rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm
warning: libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:libaio-devel-0.3.109-13.el7 ################################# [100%]
[root@racdb1 rpm]# rpm -ivh oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm
warning: oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-preinstall-19c-1.################################# [100%]
[root@racdb1 rpm]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-ee-19c-1.0-1 ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure>>> preinstall 까지만 설치해도 무방 ... ㅎㅎ 마지막단계인 ee는 안해도됨!
oracle asm 사용을 위한 rpm 설치
[racdr1|root:/dev]> cd /u01/media/rpm
[racdr1|root:/u01/media/rpm]> ls
ksh-20120801-142.0.1.el7.x86_64.rpm oracleasm-support-2.1.11-2.el7.x86_64.rpm
libaio-devel-0.3.109-13.el7.x86_64.rpm oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm
oracleasmlib-2.0.12-1.el7.x86_64.rpm
[racdr1|root:/u01/media/rpm]> rpm -ivh oracleasm-support-2.1.11-2.el7.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:oracleasm-support-2.1.11-2.el7 ################################# [100%]
Note: Forwarding request to 'systemctl enable oracleasm.service'.
Created symlink from /etc/systemd/system/multi-user.target.wants/oracleasm.service to /usr/lib/systemd/system/oracleasm.service.
[racdr1|root:/u01/media/rpm]> systemctl enable oracleasm.service
[racdr1|root:/u01/media/rpm]> rpm -ivh oracleasmlib-2.0.12-1.el7.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:oracleasmlib-2.0.12-1.el7 ################################# [100%]프로필 설정
- root
export TZ=Asia/Seoul
##########################################
# 1. ORACLE
##########################################
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19c/db_1
export ORACLE_SID=racdr1
export GRID_HOME=/u01/app/19c/grid
##########################################
# 2. FORMAT
##########################################
export PATH=$PATH:$GRID_HOME/bin
export PS1='[$ORACLE_SID|\u:$PWD]> '
set -o vi
stty erase ^H
##########################################
# 3. ALIAS
##########################################
alias ss='sqlplus / as sysdba'
alias ob='cd $ORACLE_BASE'
alias gh='cd $GRID_HOME'
alias dbs='cd $ORACLE_HOME/dbs'
alias net='cd $GRID_HOME/network/admin'
alias ..='. ~/.bash_profile'
alias ...='vi ~/.bash_profile'
alias ora="su - oracle"- oracle
##########################################
# 1. ORACLE
##########################################
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19c/db_1
export ORACLE_SID=racdr1
export GRID_HOME=/u01/app/19c/grid
##########################################
# 2. FORMAT
##########################################
export PATH=$PATH:$ORACLE_HOME/bin:$GRID_HOME/bin:$ORACLE_HOME/OPatch
export BASE_PATH=/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export DISPLAY=192.168.0.66:0.0
export PS1='[$ORACLE_SID|\u:$PWD]> '
export NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'
set -o vi
stty erase ^H
##########################################
# 3. ALIAS
##########################################
alias ss='sqlplus / as sysdba'
alias ob='cd $ORACLE_BASE'
alias oh='cd $ORACLE_HOME'
alias gh='cd $GRID_HOME'
alias dbs='cd $ORACLE_HOME/dbs'
alias net='cd $GRID_HOME/network/admin'
alias ..='. ~/.bash_profile'
alias ...='vi ~/.bash_profile'
alias a='tail -50f /u01/app/oracle/diag/rdbms/racdr/$ORACLE_SID/trace/al*.log'
alias bdump='cd /u01/app/oracle/diag/rdbms/racdr/$ORACLE_SID/trace'
alias asm='export ORACLE_SID=+ASM1;export ORACLE_HOME=$GRID_HOME;export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$BASE_PATH'공유 스토리지 생성
racdr1 VM 끄고 진행
VirtualBox > 파일 > 가상미디어 관리자 선택
새로만들기 > 고정크기로 원하는 용량만큼 생성
나는 adg를 위해 Primary DB와 이름, 용량을 동일하게 부여함
CRS1, 2, 3 3GB | CRS4 30GB | DATA 50GB | FRA 30GB
racdr1 > 설정 > 저장소 > 생성 순서대로 스토리지 연결
asm 환경 구성
[racdr1|root:/root]> oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
-----------------------------------------------------------------------
[racdr1|root:/root]> oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm
-----------------------------------------------------------------------
[racdr1|root:/root]> oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
-----------------------------------------------------------------------
[racdr1|root:/root]> oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_SCAN_DIRECTORIES=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"디스크 파티셔닝
[racdr1|root:/root]> ls /dev/sd*
/dev/sda /dev/sda1 /dev/sda2 /dev/sdb /dev/sdc /dev/sdd /dev/sde /dev/sdf /dev/sdg
$ fdisk /dev/sdb ### "n", "p", "1", "엔터", "엔터", "w" 입력
$ fdisk /dev/sdc ### "n", "p", "1", "엔터", "엔터", "w" 입력
$ fdisk /dev/sdd ### "n", "p", "1", "엔터", "엔터", "w" 입력
$ fdisk /dev/sde ### "n", "p", "1", "엔터", "엔터", "w" 입력
$ fdisk /dev/sdf ### "n", "p", "1", "엔터", "엔터", "w" 입력
$ fdisk /dev/sdg ### "n", "p", "1", "엔터", "엔터", "w" 입력
[racdr1|root:/root]> ls /dev/sd*
/dev/sda /dev/sda2 /dev/sdb1 /dev/sdc1 /dev/sdd1 /dev/sde1 /dev/sdf1 /dev/sdg1
/dev/sda1 /dev/sdb /dev/sdc /dev/sdd /dev/sde /dev/sdf /dev/sdgasm 디스크 생성
[racdr1|root:/root]> oracleasm createdisk CRS1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[racdr1|root:/root]> oracleasm createdisk CRS2 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[racdr1|root:/root]> oracleasm createdisk CRS3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[racdr1|root:/root]> oracleasm createdisk DATA /dev/sde1
Writing disk header: done
Instantiating disk: done
[racdr1|root:/root]> oracleasm createdisk FRA /dev/sdf1
Writing disk header: done
Instantiating disk: done
[racdr1|root:/root]> oracleasm createdisk CRS4 /dev/sdg1
Writing disk header: done
Instantiating disk: done
-----------------------------------------------------------------------
[racdr1|root:/root]> oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[racdr1|root:/root]> oracleasm listdisks
CRS1
CRS2
CRS3
CRS4
DATA
FRAracdr2 복제 생성
racdr1 VM 끄고 진행
VirtualBox > 파일 > 가상미디어 관리자 선택
생성 후 설정에서 racdr1의 설정과 동일하게 구성 (공유스토리지 까지)
- 네트워크 - 어댑터1 : 어댑터에브리지 / 어댑터 2 : 호스트 전용 어댑터
- 오디오 - 사용안함
- 시스템 - 부팅순서 플로피 x / 프로세서 CPU 2
rac2 접속 후 network 설정 / hostname / profile 변경
# hostname 설정 변경
[racdr1|root:/root]> hostnamectl status
Static hostname: racdr1
Icon name: computer-vm
Chassis: vm
Machine ID: bcd5407e6717e14ebb1a639ce33dd5b4
Boot ID: b1bab80a956f45b09c3693b3c2cf49d9
Virtualization: kvm
Operating System: Oracle Linux Server 7.9
CPE OS Name: cpe:/o:oracle:linux:7:9:server
Kernel: Linux 5.4.17-2136.317.5.3.el7uek.x86_64
Architecture: x86-64
--------------------------------------------------------------------------
[racdr1|root:/root]> hostnamectl set-hostname racdr2
[racdr1|root:/root]> hostnamectl status
Static hostname: racdr2
Icon name: computer-vm
Chassis: vm
Machine ID: bcd5407e6717e14ebb1a639ce33dd5b4
Boot ID: b1bab80a956f45b09c3693b3c2cf49d9
Virtualization: kvm
Operating System: Oracle Linux Server 7.9
CPE OS Name: cpe:/o:oracle:linux:7:9:server
Kernel: Linux 5.4.17-2136.317.5.3.el7uek.x86_64
Architecture: x86-64
# .bash_profile 변경 < root / oracle >
export ORACLE_SID=racdr2Grid 설치 (rac1 에서만 진행)
- 엔진 압축 해제 < grid profile >
[racdr1|oracle:/home/oracle]> asm
[+ASM1|oracle:/home/oracle]> cd /u01/media/engine/19c/
[+ASM1|oracle:/u01/media/engine/19c]> ls -al
total 5809468
drwxrwxr-x. 2 oracle dba 80 Mar 23 08:47 .
drwxrwxr-x. 3 oracle dba 17 Mar 23 08:44 ..
-rw-r--r--. 1 oracle dba 3059705302 Mar 23 08:48 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 oracle dba 2889184573 Mar 23 08:47 LINUX.X64_193000_grid_home.zip
[+ASM1|oracle:/u01/media/engine/19c]> unzip LINUX.X64_193000_grid_home.zip -d $GRID_HOME
~~- 설치
[+ASM1|oracle:/u01/media/engine/19c]> gh
[+ASM1|oracle:/u01/app/19c/grid]> ./gridSetup.sh
1) 소프트웨어 설치 후 Cluster 구성까지 진행
2) 소프트웨어 설치 후 Standalone 서버 구성
3) Grid 업그레이드 하거나 ASM 구성 진행
4) 소프트웨어만 설치
1) Oracle 독립형 클러스터 구성
2) Oracle 도메인 서비스 클러스터 구성
3) Oracle 데이터베이스에 대한 Oracle 멤버 클러스터 구성
4) 응용프로그램에 대한 Oracle 멤버 클러스터 구성
---
Oracle Extended 클러스터로 구성
cluster name 설정
SCAN Name은 /etc/hosts에 정의한 이름과 같아야함
GNS 사용 X (Grid Name Service 설정)
racdr2 노드 추가
클러스터 노드 간 비밀번호 없는 ssh환경 구성
enp0s3 > 공용사용 / enp0s8 > ASM 및 전용 / virbr0 은 사용안함처리
저장영역 옵션 정보
1) asm 사용
2) 공유 파일 시스템 사용
GIMR 사용 X (grid infrastructure 관리 저장소)
asm diskgroup 생성
Change Discovery Path > 경로 변경 /dev/oracleasm/disks/*
Disk group명을 CRS로 설정 후 이중화 - External
disk CRS 1, 2, 3, 4 선택 후 Next
ASM 비밀번호 지정 > 권고와 맞지않다고 나오는 오류 (무시가능)
실패분리 (IPMI) 사용안함
EM 사용안함
ASM 그룹 선택
ORACLE_BASE, GRID_HOME 경로 확인
ROOT.SH 자동으로 돌릴지
사전 조건 검사
1) Swap Size
PRVF-7573 : Sufficient swap size is not available on node "racdr2" [Required = 9.7186GB (1.019072E7KB) ; Found = 8GB (8388604.0KB)]
- Cause: The swap size found does not meet the minimum requirement.
- Action: Increase swap size to at least meet the minimum swap space requirement.
최소 swap size보다 낮으니 높여주세요 ~~/
[racdr2|root:/root]> swapon -s
Filename Type Size Used Priority
/dev/dm-1 partition 8388604 0 -2--> 무시 가능 (16G이상의 메모리 설정시에만 16G로 조정)
2) resolv.conf Integrity
PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: racdr1,racdr2
- Cause: The DNS response time for an unreachable node exceeded the value specified on nodes specified.
- Action: Make sure that ''options timeout'', ''options attempts'' and ''nameserver'' entries in file resolv.conf are proper. On HPUX these entries will be ''retrans'', ''retry'' and ''nameserver''. On Solaris these will be ''options retrans'', ''options retry'' and ''nameserver''. Make sure that the DNS server responds back to name lookup request within the specified time when looking up an unknown host name.
--> DNS IP 설정 관련 / 무시
3) RPM Package Manager Database
PRVG-11250 : The check "RPM Package Manager database" was not performed because it needs 'root' user privileges.
- Cause: In running the pre-requisite test suite for a planned system management operation, the indicated check was not performed because it requires root user privileges, and the root user credentials had not been supplied.
- Action: To include the check, reissue the request providing the required credentials for the root user.
--> 늘 그렇듯 ... runcluvfy.sh를 루트 계정으로 돌려라 ..
./runcluvfy.sh stage -pre crsinst -n racdr1,racdr2 -method root
4) DNS/NIS name service
PRVG-11826 : DNS resolved IP addresses "" for SCAN name "racdr-scan" not found in the name service returned IP addresses "10.0.1.191,10.0.1.193,10.0.1.192"
--> DNS IP 설정 관련 / 무시
Fix 하고 Check again 해도 그대로 .. > Ignore 후 설치 진행
설치중
root.sh 돌리기
아이코 Finish 화면 깜빢
확인
[racdr1|root:/root]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.chad
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.net1.network
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.ons
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE racdr2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE racdr1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE racdr1 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE racdr1 Started,STABLE
2 ONLINE ONLINE racdr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE racdr1 STABLE
ora.qosmserver
1 ONLINE ONLINE racdr1 STABLE
ora.racdr1.vip
1 ONLINE ONLINE racdr1 STABLE
ora.racdr2.vip
1 ONLINE ONLINE racdr2 STABLE
ora.scan1.vip
1 ONLINE ONLINE racdr2 STABLE
ora.scan2.vip
1 ONLINE ONLINE racdr1 STABLE
ora.scan3.vip
1 ONLINE ONLINE racdr1 STABLE
--------------------------------------------------------------------------------ASM 디스크 그룹 추가
[+ASM|oracle:/home/oracle]> asmca
종료 후 확인
[racdr1|root:/root]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.chad
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.net1.network
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.ons
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 ONLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 ONLINE OFFLINE STABLEchown oracle:dba /u01/app
chown oracle:dba /u01/app/19c
chown oracle:dba /u01/app/19c/gridDatabase 엔진 설치
1. media파일 압축해제
# OS user oracle로 접속
[racdr1|oracle:/u01/app/19c/grid]> cd /u01/media/engine/19c/
[racdr1|oracle:/u01/media/engine/19c]> ls -al
total 5809504
drwxrwxr-x. 2 oracle dba 96 Mar 23 12:54 .
drwxrwxr-x. 3 oracle dba 17 Mar 23 08:44 ..
-rw-r--r--. 1 oracle dba 36762 Mar 23 12:54 grid.rsp
-rw-r--r--. 1 oracle dba 3059705302 Mar 23 08:48 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 oracle dba 2889184573 Mar 23 08:47 LINUX.X64_193000_grid_home.zip
# ORACLE_HOME에 압축해제
[racdr1|oracle:/u01/media/engine/19c]> unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
# 설치 프로그램 실행
[racdr1|oracle:/u01/media/engine/19c]> oh
[racdr1|oracle:/u01/app/oracle/product/19c/db_1]> ./runInstaller2. GUI로 엔진 설치
1) 단일 인스턴스 데이터베이스 생성 및 구성
2) 소프트웨어만 설정
1) 단일 인스턴스 데이터베이스 설치
2) RAC 데이터베이스 설치
노드 선택
에디션 선택 (EE)
ORACLE_BASE, ORACLE_HOME 경로 확인
관리 OS 그룹 설정
root script 자동 수행
사전 조건 검사
무시할게 .. ㅠ
인스톨 고고 ㅠ
fin
Release Update 적용
chown root:dba /u01/app/19c/grid1) OPatch version up / 두 노드 모두 진행
# racdr1
[+ASM1|oracle:/home/oracle]> opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
# GRID OPATCH
[racdr1|root:/root]> mv $GRID_HOME/OPatch $GRID_HOME/OPatch_old
[racdr1|oracle:/home/oracle]> cd /u01/media/patch/19c
[racdr1|oracle:/u01/media/patch/19c]> unzip p6880880_190000_Linux-x86-64.zip -d $GRID_HOME
# ORACLE OPATCH
[racdr1|oracle:/u01/media/patch/19c]> mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old
[racdr1|oracle:/u01/media/patch/19c]> unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
# 확인
[racdr1|oracle:/u01/media/patch/19c]> opatch version
OPatch Version: 12.2.0.1.33
OPatch succeeded.
[racdr1|oracle:/u01/media/patch/19c]> asm
[+ASM1|oracle:/u01/media/patch/19c]> opatch version
OPatch Version: 12.2.0.1.33
OPatch succeeded.# racdr2
[racdr2|oracle:/home/oracle]> opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
# GRID OPATCH
[racdr2|root:/root]> mv $GRID_HOME/OPatch $GRID_HOME/OPatch_old
[racdr2|oracle:/home/oracle]> cd /u01/media/patch/19c
[racdr2|oracle:/u01/media/patch/19c]> unzip p6880880_190000_Linux-x86-64.zip -d $GRID_HOME
# ORACLE OPATCH
[racdr2|oracle:/u01/app/19c/grid]> mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old
[racdr2|oracle:/u01/media/patch/19c]> unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
# 확인
[racdr2|oracle:/u01/media/patch/19c]> opatch version
OPatch Version: 12.2.0.1.33
OPatch succeeded.
[racdr2|oracle:/u01/media/patch/19c]> asm
[+ASM1|oracle:/u01/media/patch/19c]> opatch version
OPatch Version: 12.2.0.1.33
OPatch succeeded.2) patch파일 압축해제 (34416665)
Last login: Thu Mar 23 13:34:22 KST 2023 on pts/11
[racdr1|oracle:/home/oracle]> cd /u01/media/patch/19c
[racdr1|oracle:/u01/media/patch/19c]> ls -al
total 2672424
drwxrwxr-x. 2 oracle dba 93 Mar 23 13:39 .
drwxrwxr-x. 3 oracle dba 17 Mar 23 08:44 ..
-rw-r--r--. 1 oracle dba 2610825269 Mar 23 08:49 19.17_p34416665_190000_Linux-x86-64.zip
-rw-r--r--. 1 oracle dba 125734641 Mar 23 08:47 p6880880_190000_Linux-x86-64.zip
# 두 노드 모두 진행
[racdr1|oracle:/u01/media/patch/19c]> unzip 19.17_p34416665_190000_Linux-x86-64.zip
[racdr2|oracle:/u01/media/patch/19c]> unzip 19.17_p34416665_190000_Linux-x86-64.zip3) 패치 진행
##### grid profile로 진행
# 현재 상태 확인
[+ASM1|oracle:/u01/media/patch/19c]> opatch lspatches
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.
# 사전 충돌 검사
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/media/patch/19c/34416665/34419443
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/media/patch/19c/34416665/34444834
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/media/patch/19c/34416665/34428761
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/media/patch/19c/34416665/34580338
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/media/patch/19c/34416665/33575402# 여유 공간 체크
1. grid
- /tmp/patch_list_gihome.txt 생성
[+ASM1|oracle:/u01/media/patch/19c]> vi /tmp/patch_list_gihome.txt
/u01/media/patch/19c/34416665/34419443
/u01/media/patch/19c/34416665/34444834
/u01/media/patch/19c/34416665/34428761
/u01/media/patch/19c/34416665/34580338
/u01/media/patch/19c/34416665/33575402
- 체크
[+ASM1|oracle:/u01/media/patch/19c]> $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.33
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19c/grid
Central Inventory : /opt/oracle/oraInventory
from : /u01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.33
OUI version : 12.2.0.7.0
Log file location : /u01/app/19c/grid/cfgtoollogs/opatch/opatch2023-03-23_13-51-23PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
2. oracle
- /tmp/patch_list_dbhome.txt 생성
[+ASM1|oracle:/u01/media/patch/19c]> vi /tmp/patch_list_dbhome.txt
/u01/media/patch/19c/34416665/34419443
/u01/media/patch/19c/34416665/34444834
- 체크
[racdr1|oracle:/home/oracle]> $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.33
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /opt/oracle/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.33
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-03-23_13-53-19PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.# 패치 준비상태 확인
[+ASM1|oracle:/home/oracle]> cluvfy stage -pre patch
Verifying cluster upgrade state ...PASSED
Verifying Software home: /u01/app/19c/grid ...PASSED
Pre-check for Patch Application was successful.
CVU operation performed: stage -pre patch
Date: Mar 23, 2023 1:59:51 PM
CVU home: /u01/app/19c/grid/
User: oracle# OPatch Auto - root 계정으로 두노드 모두 진행
## racdr1
[racdr1|root:/root]> export PATH=$PATH:/u01/app/19c/grid/OPatch
[racdr1|root:/root]> opatchauto apply /u01/media/patch/19c/34416665 -oh /u01/app/19c/grid
[racdr1|root:/root]> export PATH=$PATH:/u01/app/oracle/product/19c/db_1/OPatch
[racdr1|root:/root]> opatchauto apply /u01/media/patch/19c/34416665 -oh /u01/app/oracle/product/19c/db_1
## racdr2
[racdr2|root:/root]> export PATH=$PATH:/u01/app/19c/grid/OPatch
[racdr2|root:/root]> opatchauto apply /u01/media/patch/19c/34416665 -oh /u01/app/19c/grid
[racdr2|root:/root]> export PATH=$PATH:/u01/app/oracle/product/19c/db_1/OPatch
[racdr2|root:/root]> opatchauto apply /u01/media/patch/19c/34416665 -oh /u01/app/oracle/product/19c/db_1
# 확인
## racdr1
### grid
[+ASM1|oracle:/home/oracle]> opatch lspatches
34580338;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34580338)
34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834)
34428761;ACFS RELEASE UPDATE 19.17.0.0.0 (34428761)
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
### database
[racdr1|oracle:/home/oracle]> opatch lspatches
34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834)
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
OPatch succeeded.
## racdr2
### grid
[racdr2|oracle:/home/oracle]> asm
[+ASM1|oracle:/home/oracle]> opatch lspatches
34580338;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34580338)
34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834)
34428761;ACFS RELEASE UPDATE 19.17.0.0.0 (34428761)
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
### database
[racdr2|oracle:/home/oracle]> opatch lspatches
34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834)
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
OPatch succeeded.
만약 수동 패치를 진행했다면
- 수정된 SQL 파일을 데이터베이스에 로딩
# RAC 환경에서 하나의 노드에서만 실행해도 됨. (oracle profile)
$ sqlplus /nolog
SQL> Connect / as sysdba
SQL> startup
SQL> quit
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose만약 RMAN을 사용한다면
- 카탈로그 업데이트 필요
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
RMAN> UPGRADE CATALOG;
RMAN> EXIT;
Database Configuration Assistant (Database 생성)
[racdr1|oracle:/u01/app/oracle/product/19c/db_1]> dbca
데이터베이스 생성
템플릿 관리
고급 구성
데이터 웨어하우스
사용자 정의 데이터베이스
일반 목적 또는 트랜잭션 처리 (OLTP업무)
노드선택
전역 데이터베이스 이름과 DB_SID 설정
컨테이너 db는 생성하지 않음
데이터베이스 저장 영역 속성 > 유형 : ASM / 위치 설정
OMF 사용 체크
빠른 복구 영역 지정 , 아카이브로그 모드 사용 (ADG 구축에 필요함 / 추후 변경 가능)
primary db와 동일하게 설치
구성 옵션 모두 primary db와 동일하게 구성함.
cvu check 주기적 실행 X
EM 구성 X
알았다구. 알았다구 !
데이터베이스 생성!!!
늬 FRA 크기가 권장값 2.817 MB *3 보다 작다..
되돌아가서 바꿔..
순순히 넘어감
스왑 사이즈 늬 자꾸 왜 나오는데 내가 못해준게 뭔데
무시할게 ㅎㅎ
크리에잇 데이뤄붸이스 인 프뤄구뤠수
끗
확인
1) CRS
[racdr1|root:/root]> crsctl stop crs
[racdr1|root:/root]> crsctl start crs
[racdr2|root:/root]> crsctl stop crs
[racdr2|root:/root]> crsctl start crs
[racdr1|oracle:/home/oracle]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.chad
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.net1.network
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
ora.ons
ONLINE ONLINE racdr1 STABLE
ONLINE ONLINE racdr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE racdr1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE racdr2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE racdr2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE racdr1 Started,STABLE
2 ONLINE ONLINE racdr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE racdr1 STABLE
2 ONLINE ONLINE racdr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE racdr2 STABLE
ora.qosmserver
1 ONLINE ONLINE racdr2 STABLE
ora.racdr.db
1 ONLINE ONLINE racdr1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE racdr2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.racdr1.vip
1 ONLINE ONLINE racdr1 STABLE
ora.racdr2.vip
1 ONLINE ONLINE racdr2 STABLE
ora.scan1.vip
1 ONLINE ONLINE racdr1 STABLE
ora.scan2.vip
1 ONLINE ONLINE racdr2 STABLE
ora.scan3.vip
1 ONLINE ONLINE racdr2 STABLE
--------------------------------------------------------------------------------2) Database
# 1번 노드
[racdr1|oracle:/home/oracle]> ss
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 23 14:48:00 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string racdr
SQL> select instance_name, status from v$instance ;
INSTANCE_NAME STATUS
---------------- ------------
racdr1 OPEN
# 2번 노드
[racdr2|oracle:/home/oracle]> ss
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 23 14:48:02 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string racdr
SQL> select instance_name, status from v$instance ;
INSTANCE_NAME STATUS
---------------- ------------
racdr2 OPEN
3) 리스너
# 1번 노드
[racdr1|oracle:/home/oracle]> lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-MAR-2023 14:49:19
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 23-MAR-2023 14:46:27
Uptime 0 days 0 hr. 2 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19c/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/racdr1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.101)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.201)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_FRA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "racdr" has 1 instance(s).
Instance "racdr1", status READY, has 1 handler(s) for this service...
Service "racdrXDB" has 1 instance(s).
Instance "racdr1", status READY, has 1 handler(s) for this service...
The command completed successfully
# 2번 노드
[racdr2|oracle:/home/oracle]> lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-MAR-2023 14:49:57
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 23-MAR-2023 14:46:06
Uptime 0 days 0 hr. 3 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19c/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/racdr2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.102)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.202)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_FRA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "racdr" has 1 instance(s).
Instance "racdr2", status READY, has 1 handler(s) for this service...
Service "racdrXDB" has 1 instance(s).
Instance "racdr2", status READY, has 1 handler(s) for this service...
The command completed successfully
728x90
'ORACLE > INSTALL' 카테고리의 다른 글
| [ORACLE] 19c Database Engine Silent Mode 설치 | runInstaller response file (0) | 2023.04.26 |
|---|---|
| [ORACLE] 19c Grid Silent Mode 설치 | gridSetup response file + ASM DISKGROUP 생성 (0) | 2023.04.26 |
| [ORACLE] Oracle Database 12c R1 RAC 설치 (0) | 2023.03.17 |
| [ORACLE] Oracle Database 12c R1 Single 설치 GUI 모드 (0) | 2023.03.15 |
| [ORACLE] Oracle Database 12c R2 Single 설치 GUI 모드 (1) | 2023.02.13 |
'ORACLE/INSTALL' Related Articles
more
