ORACLE11GR2在REDHAT63环境中搭建RAC集群及简单维护VIP免费

1、系统环境1.1、硬件环境服务器：vmware10，新建２个虚拟机主机名分别为rac1和rac2，每个虚拟机分配40G磁盘空间，添加两个网络适配器。其中第二个适配器网络连接调整为自定义，且两个节点保持一致。。Widonws本机ip：192.168.6.11.2、软件环境数据库：oracle11.2.0.4database-x86-64GRID：oracle11.2.0.4_grid-x86-64操作系统：rhel-server-6.3-x86_64采用最小化安装PAGE\*MERGEFORMAT151.3、网络环境Ip地址规划分配为IP名称子网掩码IP地址Rac1-public255.255.255.0192.168.6.11Rac2-public255.255.255.0192.168.6.12Rac1-private255.255.255.02.2.2.2Rac2-private255.255.255.02.2.2.3Rac1-vip255.255.255.0192.168.6.13Rac2-vip255.255.255.0192.168.6.14SCAN255.255.255.0192.168.6.151.4、共享磁盘分区计划创建四个共享磁盘sdb、sdc、sdd、sde，每个磁盘计划分三个分区2、前期环境准备2.1配置静态ＩＰ地址vi/etc/sysconfig/network-scripts/ifcfg-eth0修改ip地址。每个虚拟机eth0网卡为public，DEVICE="eth0"BOOTPROTO="static"PAGE\*MERGEFORMAT15HWADDR="00:0C:29:D1:4E:A6"NM_CONTROLLED="yes"ONBOOT="yes"TYPE="Ethernet"*UUID="e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027"IPADDR=192.168.6.11NETMASK=255.255.255.0GATEWAY=192.168.6.1vi/etc/sysconfig/network-scripts/ifcfg-eth1修改ip地址。每个虚拟机eth1网卡位privateDEVICE="eth1"BOOTPROTO="static"HWADDR="00:0C:29:D1:4E:A6"NM_CONTROLLED="yes"ONBOOT="yes"TYPE="Ethernet"*UUID="e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027"IPADDR=2.2.2.2NETMASK=255.255.255.0修改完成后执行servicenetworkrestart2.2在rac1和rac2上分别关闭防火墙serviceiptablesstop--停止防火墙chkconfigiptablesoff--禁用防火墙2.3在rac1和rac2上分别修改主机名PAGE\*MERGEFORMAT15vi/etc/sysconfig/network重启生效，一个rac1，另一个rac2HOSTNAME=rac12.4在rac1和rac2上分别改hostsvi/etc/hosts添加对应的ip信息#public192.168.6.180rac1192.168.6.181rac2#private2.2.2.1rac1-priv2.2.2.2rac2-priv#virtual192.168.6.182rac1-vip192.168.6.183rac2-vip#scan192.168.6.184cluster-scan2.5在rac1和rac2上分别执行配置内核参数vi/etc/sysctl.conf加入以下内容fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2147483648kernel.shmmax=68719476736kernel.shmmni=4096kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304PAGE\*MERGEFORMAT15net.core.wmem_default=262144net.core.wmem_max=1048586使修改参数立即生效：sysctl-p2.6在rac1和rac2上分别执行修改limitsvi/etc/security/limits.conf加入以下信息gridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile655362.7在rac1和rac2上分别修改/etc/pam.d/loginvi/etc/pam.d/login加入以下信息sessionrequired/lib/security/pam_limits.sosessionrequiredpam_limits.so2.8在rac1和rac2上分别执行修改/etc/profilevi/etc/profile加入以下信息if[$USER="oracle"]||[$USER="grid"];thenPAGE\*MERGEFORMAT15if[$SHELL="/bin/ksh"];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi2.9在rac1和rac2上分别执行禁用selinuxvi/etc/selinux/config修改SELINUX值SELINUX=disabled2.10在rac1和rac2上分别执行停止ntp服务servicentpdstopchkconfigntpdoffmv/etc/ntp.conf/etc/ntp.conf.bak2.11在rac1和rac2上分别处理/dev/shm共享内存不足的处理df-h查看tmpfs分区是否大于1G，如果过小需增加。vi/etc/fstab默认的：tmpfs/dev/shmtmpfsdefaults00改成：tmpfs/dev/shmtmpfsdefaults,size=1024m00PAGE\*MERGEFORMAT15mount-oremount/dev/shm2.12在rac1和rac2上分别检查软件是否全部安装rpm-qa|grepbinutils-rpm-qa|grepcompat-libstdc++-rpm-qa|grepelfutils-libelf-rpm-qa|grepelfutils-libelf-devel-rpm-q...