RHEL 7.6 安装 Oracle 18c RAC
第一部分 安装规划
虚拟环境 |
VirtualBox 6.0 |
OS 版本 |
Red Hat Enterprise Linux Server release 7.6 (Maipo) |
数据库版本 |
18.3.0.0.0 |
安装介质 |
LINUX.X64_180000_db_home.zip LINUX.X64_180000_grid_home.zip |
软件安装目录 |
grid: /u01/app/18.0.0/grid |
oracle: /u01/app/oracle/product/18.0.0/db_1 |
|
用户和组 |
grid: oinstall,asmadmin,asmdba,racdba,asmoper |
oracle: oinstall, dba,asmdba,backupdba,dgdba,kmdba,racdba,oper |
|
网络规划 |
192.168.56.11 rac1 #一节点public ip 192.168.56.12 rac2 #二节点public ip
192.168.56.13 rac1-vip #一节点virtual ip 192.168.56.14 rac2-vip #二节点virtual ip
172.16.56.11 rac1-priv #一节点private ip 172.16.56.12 rac2-priv #二节点private ip
192.168.56.15 rac-scan # scan ip |
ASM磁盘组 |
OCRVT: 2G * 3 MGMT: 40G * 1 DATA: 8G * 1 ARCH: 5G * 1 |
安装操作系统,添加ASM共享磁盘省略
第二分部 操作系统环境配置
2.1 更改IO调度为deadline,关闭numa和透明大页
(1).vi /etc/default/grub(编辑 /etc/default/grub 文件,在GRUB_CMDLINE_LINUX 条目后面添加"elevator=deadline","transparent_hugepage=never" 和”numa=off”,
执行grub2-mkconfig -o /boot/grub2/grub.cfg 最后重启操作系统)
GRUB_CMDLINE_LINUX="crashkernel=auto rd.lvm.lv=rootvg/root rd.lvm.lv=rootvg/swap rhgb quiet elevator=deadline transparent_hugepage=never numa=off net.ifnames=0 biosdevname=0"
grub2-mkconfig -o /boot/grub2/grub.cfg
(2). 重启操作系统使配置生效.
2.2 使用CTSS时钟同步
/sbin/service ntpd stop
chkconfig ntpd off
mv /etc/ntp.conf /etc/ntp.conf.org
systemctl stop chronyd
systemctl disable chronyd
2.3 配置/etc/hosts解析表
vi /etc/hosts添加
#config for 18c RAC
192.168.56.11 rac1
192.168.56.12 rac2
192.168.56.13 rac1-vip
192.168.56.14 rac2-vip
172.16.56.11 rac1-priv
172.16.56.12 rac2-priv
192.168.56.15 rac-scan
2.4 关闭防火墙
systemctl disable firewalld.service
systemctl stop firewalld.service
2.5 关闭selinux
vi /etc/selinux/config
SELINUX=disabled
2.6 关闭NetworkManager
systemctl disable NetworkManager
systemctl stop NetworkManager
2.7 停止avahi-daemon
systemctl stop avahi-daemon.socket avahi-daemon.service
systemctl disable avahi-daemon.socket avahi-daemon.service
2.8 配置NOZEROCONF
vi /etc/sysconfig/network 添加
NOZEROCONF=yes
2.9 内核参数修改
vi /etc/sysctl.conf
#kernel configuration for oracle 18c
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 268435456
kernel.shmmax = 549755813760
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
是配置生效
sysctl -p
2.10 添加用户和组
/usr/sbin/groupadd -g 54321 oinstall
/usr/sbin/groupadd -g 54322 dba
/usr/sbin/groupadd -g 54323 oper
/usr/sbin/groupadd -g 54324 backupdba
/usr/sbin/groupadd -g 54325 dgdba
/usr/sbin/groupadd -g 54326 kmdba
/usr/sbin/groupadd -g 54327 asmdba
/usr/sbin/groupadd -g 54328 asmoper
/usr/sbin/groupadd -g 54329 asmadmin
/usr/sbin/groupadd -g 54330 racdba
/usr/sbin/us