[테스트 환경]
OS : Oracle Linux 7.9
DB : Oracle 12cR2
[테스트 개요]
Oracle12cR2 Pre Install을 사용하지 않고 수동 설치하는 절차를 정리함
[테스트]
1. Oracle User 생성
--root os user
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54330 racdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle
[root@rdb01d][/root]$ id oracle
uid=54321(oracle) gid=54321(oinstall)
groups=
54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)<
/FONT>
2. /etc/sysctl.conf 설정
[root@rdb01d][/etc]$ vi sysctl.conf
[root@rdb01d][/etc]$ cat sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in
/usr/lib/sysctl.d/.
# To override a whole file, create a
new file with the same in
# /etc/sysctl.d/ and put new
settings there. To override
# only specific settings, add
a file with a lexically later
# name in /etc/sysctl.d/
and put new settings there.
#
#
For more information, see sysctl.conf(5) and
sysctl.d(5).
fs.file-max =
6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
#kernel.shmall =
1073741824
#kernel.shmall = 1310720 # for 10GB(50%)
Physical Memory
kernel.shmall = 2097152 # for 16GB(50%)
Physical Memory
-->
수정
#kernel.shmmax = 4398046511104
#kernel.shmmax = 5368709120 # for 10GB(50%) Physical
Memory
kernel.shmmax = 8589934592 # for 16GB(50%)
Physical Memory
--> 수정
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
#Added by KOLEE
kernel.pid_max = 10239
vm.min_free_kbytes = 524288
vm.swappiness=1
kernel.randomize_va_space = 0
kernel.sysrq = 1
--> 추가
[root@rdb01d][/etc]$ sysctl
-p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall =
2097152 # for 16GB(50%) Physical Memory
kernel.shmmax =
8589934592 # for 16GB(50%) Physical Memory
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
kernel.pid_max = 10239
vm.min_free_kbytes = 524288
vm.swappiness = 1
kernel.randomize_va_space = 0
kernel.sysrq = 1
3. limits.d 설정
[root@rdb01d][/etc]$ vi
/etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf
[root@rdb01d][/etc]$ cat
/etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf
--> 19c인 경우 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 hard memlock
15099494 # For 16GB(90%) Physical Memory
--> 수정
#oracle soft memlock 134217728
oracle soft memlock 15099494 # For 16GB(90%) Physical
Memory
--> 수정
4. /etc/default/grub 설정
[root@rdb01d][/etc/default]$ cat
/proc/cmdline
BOOT_IMAGE=/vmlinuz-5.4.17-2102.201.3.el7uek.x86_64
root=/dev/mapper/ol-root ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet
LANG=en_US.UTF-8
[root@rdb01d][/etc/default]$ vi /etc/default/grub
[root@rdb01d][/etc/default]$ cat /etc/default/grub
GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g'
/etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb
quiet numa=off
transparent_hugepage=never"
GRUB_DISABLE_RECOVERY="true"
--> 위와 같이 세팅
[root@rdb01d][/etc/default]$
grub2-mkconfig -o /boot/grub2/grub.cfg
Generating grub configuration file ...
Found linux image:
/boot/vmlinuz-5.4.17-2102.201.3.el7uek.x86_64
Found
initrd image: /boot/initramfs-5.4.17-2102.201.3.el7uek.x86_64.img
Found linux image: /boot/vmlinuz-3.10.0-1160.el7.x86_64
Found initrd image:
/boot/initramfs-3.10.0-1160.el7.x86_64.img
Found linux
image: /boot/vmlinuz-0-rescue-48f4886082c55e4583f6e3a8feea311b
Found initrd image:
/boot/initramfs-0-rescue-48f4886082c55e4583f6e3a8feea311b.img
done
[root@rdb01d][/etc/default]$ grep -i numa
/boot/grub2/grub.cfg
linux16
/vmlinuz-5.4.17-2102.201.3.el7uek.x86_64 root=/dev/mapper/ol-root ro
rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off
transparent_hugepage=never
linux16
/vmlinuz-3.10.0-1160.el7.x86_64 root=/dev/mapper/ol-root ro rd.lvm.lv=ol/root
rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never
linux16
/vmlinuz-0-rescue-48f4886082c55e4583f6e3a8feea311b root=/dev/mapper/ol-root ro
rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off
transparent_hugepage=never
[root@rdb01d][/etc/default]$ grep -i hugepage
/boot/grub2/grub.cfg
linux16
/vmlinuz-5.4.17-2102.201.3.el7uek.x86_64 root=/dev/mapper/ol-root ro
rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off
transparent_hugepage=never
linux16
/vmlinuz-3.10.0-1160.el7.x86_64 root=/dev/mapper/ol-root ro rd.lvm.lv=ol/root
rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never
linux16
/vmlinuz-0-rescue-48f4886082c55e4583f6e3a8feea311b root=/dev/mapper/ol-root ro
rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off
transparent_hugepage=never
[root@rdb01d][/etc/default]$ reboot
[root@rdb01d][/root]$ cat
/proc/cmdline
BOOT_IMAGE=/vmlinuz-5.4.17-2102.201.3.el7uek.x86_64
root=/dev/mapper/ol-root ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet
numa=off transparent_hugepage=never
[root@rdb01d][/root]$ cat
/sys/kernel/mm/transparent_hugepage/enabled
always madvise
[never]
5. /etc/sysconfig/network 설정
[root@rdb01d][/root]$ vi /etc/sysconfig/network
[root@rdb01d][/root]$ cat /etc/sysconfig/network
# Created by anaconda
NOZEROCONF=yes
[root@rdb01d][/root]$ sudo systemctl
restart NetworkManager
[root@rdb01d][/root]$ cat
/etc/sysconfig/network | grep NOZEROCONF
NOZEROCONF=yes