1. 로그인 후 linux x86-64 RPM 파일 다운로드
mkdir -p /app/media
curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
2. preinstall 패키지 설치
cd /app/media
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
3. preinstall 패키지 설치(root 계정)
yum install -y oracle-database-preinstall-19c
4. 자동 설정 후 수동설정 파일 확인필요
4.1. /etc/sysctl.conf 에 아래 내용 추가
vi /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
4.2. 확인 /sbin/sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
4.3. vi /etc/security/limits.d/oracle-database-preinstall-19c.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
4.4. 유저 생성
groupadd dba
useradd -g dba -G dba oracle
유저 및 그룹 수정(자동 생성시)
usermod -g dba -G dba oracle
패스워드 설정
passwd oracle
4.5. selinux disable 설정
vi /etc/selinux/config
SELINUX=disabled
4.6. 불필요한 서비스 정지
systemctl stop firewalld
systemctl disable firewalld
systemctl stop bluetooth
systemctl disable bluetooth
systemctl stop chronyd
systemctl disable chronyd
mv /etc/chrony.conf /etc/chrony.conf.bak
systemctl stop ntpdate
systemctl disable ntpdate
systemctl stop avahi-daemon.socket
systemctl disable avahi-daemon.socket
systemctl stop avahi-daemon
systemctl disable avahi-daemon
systemctl stop libvirtd
systemctl disable libvirtd
'Oracle' 카테고리의 다른 글
| oracle 세션 변경 확인 테스트 (0) | 2025.03.13 |
|---|---|
| oracle pdb로 세션 스위칭 (0) | 2025.03.13 |
| oracle system 유저 패스워드 변경 (cdb,pdb) (0) | 2025.03.13 |
| oracle rpm 설치 (0) | 2025.03.13 |