RAC 설치

• OS : Oracle Linux 7.6
• Database : Oracle 19c

1) Node 1 VM 생성

OS 설정

CPU 프로세스 설정

메모리 설정

네트워크 타입 설정

디스크 용량 설정

호스트 전용 어댑터 1개 추가 생성

iso 파일 선택 및 시작

언어 설정

소프트웨어 선택

파티션 설정

KDUMP 비활성화

보안 정책 해제

네트워크 설정

설치 시작

재부팅

라이센스 동의

네트워크 재설정(설정 후 어댑터 껐다 다시 켜기)

Private IP로 putty 접근 확인

확인완료

2) Node 1 환경 설정

Linux 설치 정보 확인

[root@rac1 ~]# uname -a
Linux rac1 4.14.35-1818.3.3.el7uek.x86_64 #2 SMP Mon Sep 24 14:45:01 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux
[root@rac1 ~]# cat /etc/os-release
NAME="Oracle Linux Server"
VERSION="7.6"
ID="ol"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.6"
PRETTY_NAME="Oracle Linux Server 7.6"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:6:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.6
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.6

불필요한 서비스 정리

[root@rac1 ~]# systemctl stop firewalld
[root@rac1 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@rac1 ~]# systemctl stop bluetooth
[root@rac1 ~]# systemctl disable bluetooth
Removed symlink /etc/systemd/system/dbus-org.bluez.service.
Removed symlink /etc/systemd/system/bluetooth.target.wants/bluetooth.service.
[root@rac1 ~]# systemctl stop chronyd
[root@rac1 ~]# systemctl disable chronyd
Removed symlink /etc/systemd/system/multi-user.target.wants/chronyd.service.
[root@rac1 ~]# mv /etc/chrony.conf /etc/chrony.conf.bak
[root@rac1 ~]# systemctl stop ntpdate
[root@rac1 ~]# systemctl disable ntpdate
[root@rac1 ~]# systemctl stop avahi-daemon.socket
[root@rac1 ~]# systemctl disable avahi-daemon.socket
Removed symlink /etc/systemd/system/sockets.target.wants/avahi-daemon.socket.
[root@rac1 ~]# systemctl stop avahi-daemon
[root@rac1 ~]# systemctl disable avahi-daemon
Removed symlink /etc/systemd/system/multi-user.target.wants/avahi-daemon.service.
Removed symlink /etc/systemd/system/dbus-org.freedesktop.Avahi.service.
[root@rac1 ~]# systemctl stop libvirtd
[root@rac1 ~]# systemctl disable libvirtd
Removed symlink /etc/systemd/system/multi-user.target.wants/libvirtd.service.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlogd.socket.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlockd.socket.

보안 설정

[root@rac1 ~]# vi /etc/selinux/config
...
SELINUX=disabled
...

hosts 파일 수정

[root@rac1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

### Public
192.168.137.131 rac1	rac1
192.168.137.132 rac2	rac2

### Private
192.168.213.130 rac1-priv	rac1-priv
192.168.213.131	rac2-priv	rac2-priv

### Virtual
192.168.137.150	rac1-vip	rac1-vip
192.168.137.160	rac2-vip	rac2-vip

### SCAN
192.168.137.20	rac-scan	rac-scan
192.168.137.21	rac-scan	rac-scan
192.168.137.22	rac-scan	rac-scan

dnsmasq 활성화

[root@rac1 ~]# vi /etc/dnsmasq.conf
...
local=/localdomain/
...

resolv.conf 내용 확인 및 dnsmasq 활성화

[root@rac1 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
nameserver 127.0.0.1

[root@rac1 ~]# systemctl start dnsmasq
[root@rac1 ~]# systemctl enable dnsmasq
Created symlink from /etc/systemd/system/multi-user.target.wants/dnsmasq.service to /usr/lib/systemd/system/dnsmasq.service.

-- dnsmasq가 활성화 되어야 nslookup으로 조회됨
[root@rac1 ~]# nslookup rac-scan
Server:		127.0.0.1
Address:	127.0.0.1#53

Name:	rac-scan
Address: 192.168.137.21
Name:	rac-scan
Address: 192.168.137.20
Name:	rac-scan
Address: 192.168.137.22

!dnsmasq 활성화 도중 에러 발생

[root@rac1 ~]# systemctl start dnsmasq
[root@rac1 ~]# systemctl status dnsmasq
● dnsmasq.service - DNS caching server.
   Loaded: loaded (/usr/lib/systemd/system/dnsmasq.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since 월 2023-11-20 11:25:26 KST; 1s ago
  Process: 32698 ExecStart=/usr/sbin/dnsmasq -k (code=exited, status=2)
 Main PID: 32698 (code=exited, status=2)
11월 20 11:25:26 rac1 systemd[1]: Started DNS caching server..
11월 20 11:25:26 rac1 dnsmasq[32698]: dnsmasq: failed to create listening socket for port 53: Address already in use
11월 20 11:25:26 rac1 systemd[1]: dnsmasq.service: main process exited, code=exited, status=2/INVALIDARGUMENT
11월 20 11:25:26 rac1 systemd[1]: Unit dnsmasq.service entered failed state.
11월 20 11:25:26 rac1 systemd[1]: dnsmasq.service failed.

확인 결과 53번 포트를 쓰고 있는 것으로 확인됨
53번 포트 사용현황 조회 후 해당 프로세스 삭제

[root@rac1 ~]# netstat -ntlp | grep :53
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      6396/dnsmasq        
[root@rac1 ~]# kill -9 6396
[root@rac1 ~]# netstat -ntlp | grep :53

필수 패키지 설치
=> https://mirrors.dotsrc.org/oracle-linux/OL7/u6/x86_64/

OracleLinux-R7-U6-Server-x86-64-dvd.iso 다운로드

VM에 ISO 파일 삽입

Temp 파일 시스템 할당

[root@rac1 dev]# vi /etc/fstab
...
tmpfs	/dev/shm	tmpfs	size=4g	0 0
...

[root@rac1 dev]# mount -o remount /dev/shm

[root@rac1 dev]# df -h | grep shm
tmpfs                4.0G     0  4.0G   0% /dev/shm

Oracle 추가 패키지 설치