搜索
11、系统环境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采用最小化安装1.3、网络环境2Ip地址规划分配为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=eth0BOOTPROTO=staticHWADDR=00:0C:29:D1:4E:A6NM_CONTROLLED=yesONBOOT=yesTYPE=Ethernet*UUID=e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027IPADDR=192.168.6.113NETMASK=255.255.255.0GATEWAY=192.168.6.1vi/etc/sysconfig/network-scripts/ifcfg-eth1修改ip地址。每个虚拟机eth1网卡位privateDEVICE=eth1BOOTPROTO=staticHWADDR=00:0C:29:D1:4E:A6NM_CONTROLLED=yesONBOOT=yesTYPE=Ethernet*UUID=e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027IPADDR=2.2.2.2NETMASK=255.255.255.0修改完成后执行servicenetworkrestart2.2在rac1和rac2上分别关闭防火墙serviceiptablesstop--停止防火墙chkconfigiptablesoff--禁用防火墙2.3在rac1和rac2上分别修改主机名vi/etc/sysconfig/network重启生效，一个rac1，另一个rac2HOSTNAME=rac142.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=41943045net.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/profile6加入以下信息if[$USER=oracle]||[$USER=grid];thenif[$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，如果过小需增加。7vi/etc/fstab默认的：tmpfs/dev/shmtmpfsdefaults00改成：tmpfs/dev/shmtmpfsdefaults,size=1024m00mount-oremount/dev/shm2.12在rac1和rac2上分别检查软件是否全部安装rpm-qa|grepbinutils-rpm-qa|grepcompat-libstdc++-rpm-qa|grepelfutils-libelf-rpm-qa|grepelfutils-libelf-devel-rpm-qa|grepglibc-rpm-qa|grepglibc-common-rpm-qa|grepglibc-devel-rpm-qa|grepgcc-rpm-qa|grepgcc-c++-rpm-qa|greplibaio-rpm-qa|greplibaio-devel-rpm-qa|greplibgcc-rpm-qa|greplibstdc++-rpm-qa|greplibstdc++-devel-rpm-qa|grepmake-rpm-qa|grepsysstat-rpm-qa|grepunixODBC-rpm-qa|grepunixODBC-devel-2.13在rac1和rac22分别将未安装的包通过yum安装8mkdir/yummount/dev/cdrom/yumvi/etc/yum.repos.d/chenbin.repo添加以下内容[rhel-chenbin]name=RedHatEnterpriseLinux$releasever-$basearch-Debugbaseurl=file:///yum/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-releaseyumlist--查看可用包yum-yinstallbinutils*compat-*elfutils-libelf*gcc-*gcc-*kernel-*ksh-*libaio-*libgcc-*libgomp-*libstdc++-*make-*numactl-devel-*sysstat-*unixODBC-*pdksh*2.14在oradb1和rac2上分别关闭不需要的服务chkconfigautofsoffchkconfigacpidoffchkconfigsendmailoffchkconfigcups-config-daemonoffchkconfigcpusoffchkconfigxfsoffchkconfiglm_sensorsoffchkconfiggpmoffchkconfigopenibdoffchkconfigpcmciaoffchkconfigcpuspeedoffchkconfignfslockoff9chkconfigip6tablesoffchkconfigrpcidmapdoffchkconfigapmdoffchkconfigsendmailoffchkconfigarptables_jfoffchkconifgmicrocode_ctloffchkconfigrpcgssdoffchkconfigntpdoff3、添加组和用户3.1在rac1和rac2上分别添加oracle和grid用户和组groupadd-g501oinstallgroupadd-g502dbagroupadd-g503opergroupadd-g504asmadmingroupadd-g505asmopergroupadd-g506asmdbauseradd-goinstall-Gdba,asmdba,operoracleuseradd-goinstall-Gasmadmin,asmdba,asmoper,oper,dbagrid3.2在rac1和rac2上分别为oracle和grid用户设密码passwdoraclepasswdgrid3.3在rac1和rac2上分别创建目录grid和oracle用户的10mkdir-p/u01/app/oraclemkdir-p/u01/app/gridmkdir-p/u01/app/11.2.0/gridchown-Rgrid:oinstall/u01/app/gridchown-Rgrid:oinstall/u01/app/11.2.0chown-Roracle:oinstall/u01/app/oraclechmod-R775/u01mkdir-p/u01/app/oraInventorychown-Rgrid:oinstall/u01/app/oraInventorychmod-R775/u01/app/oraInventory3.4在rac1和rac2上分别修改oracle用户的.bash_profile文件vi/home/oracle/.bash_profileexportORACLE_SID=rac1exportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportLD_LIBRARY_PATH=$ORACLE_HOME/libexportNLS_DATE_FORMAT=yyyy-mm-ddHH24:MI:SSexportTMP=/tmpexportTMPDIR=$TMPexportPATH=$PATH:$ORACLE_HOME/bin3.5在rac1和rac2上分别修改grid用户的.bash_profile文件11vi/home/grid/.bash_profileexportORACLE_SID=+ASM1exportORACLE_BASE=/u01/app/gridexportORACLE_HOME=/u01/app/