Redhat 7数据库集群rac环境搭建.docx

Redhat 7.3 安装oracle 12c R2 RAC 步骤 Oracle RAC网络规划 服务器名称 网卡名称 IP用途 IP地址 别名 DXQFPT-01 eth0 公共IP 10.242.212.148 eth1 私用IP 192.168.1.148 vip 服务IP 10.242.212.154 DXQFPT-02 eth0 公共IP 10.242.212.149 eth1 私用IP 192.168.1.149 vip 服务IP 10.242.212.155 scan-ip ScanIP 10.242.212.156 rac-scan 2、Oracle RAC存储规划 磁盘名称 设备文件 磁盘数量 磁盘大小 OCR_VOTE01 /dev/sdc5 1 2G OCR_VOTE02 /dev/sdc6 1 2G OCR_VOTE03 /dev/sdc7 1 2G GIMR /dev/sdc8 1 40G DATA1 /dev/sdc9 1 2000G 关闭防火墙和selinux 关闭和禁用防火墙 systemctl stop firewalld systemctl disable firewalld 修改selinux vi /etc/selinux/config SELINUX=disabled 关闭ntp service ntpd stop systemctl disable ntpd.service mv /etc/ntp.conf /etc/ntp.conf.org rm /var/run/ntpd.pid 3、修改hostname 两台主机均修改 主机1： hostnamectl set-hostname db-rac-01 bash 主机2： hostnamectl set-hostname db-rac-02 bash 4、网络ip修改 1配置私用ip vi ifcfg-ens160 TYPE=Ethernet BOOTPROTO=none IPADDR=192.168.1.150 PREFIX=24 DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_PEERDNS=yes IPV6_PEERROUTES=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=ens160 UUID=37e2bfa8-7e81-47b0-830f-13bac3ece921 DEVICE=ens160 ONBOOT=yes 5、修改hosts vi /etc/hosts #public IP 10.242.212.148 DXQFPT-01 10.242.212.149 DXQFPT-02 #private ip 192.168.1.148 DXQFPT-01-priv 192.168.1.149 DXQFPT-02-priv #virtual ip 10.242.212.154 DXQFPT-01-vip 10.242.212.155 DXQFPT-02-vip #Scan ip 10.242.212.156 rac-scan 6、修改内核参数sysctl vi /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall =kernel.shmmax = 42949672960 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 /sbin/sysctl -p 备注： 以上配置为40G tmpfs 配置 kernel.shmmax 计算方式 64*1024*1024*1024*90% = 61847529062 kernel.shmall 计算方式 kernel.shmmax/4096 =7.修改limits参数 vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft