Linux_+_Oracle_11g_R2_RAC_安装配置详细过程

环境：OracleLinuxAS5.5两台Oracle11gR21、IP规划127.0.0.1localhost.localdomainlocalhost#publicip192.168.10.211rac1192.168.10.212rac2#privip10.10.10.211rac1prv10.10.10.212rac2prv#vipip192.168.10.213rac1vip192.168.10.214rac2vip#scanip192.168.10.215racscan2、磁盘规划+CRS三个2G的盘+DGDATA三个10G的盘+DGRECOVERY两个5G的盘/usr/sbin/groupadd-g501oinstall/usr/sbin/groupadd-g502dba/usr/sbin/groupadd-g503oper/usr/sbin/groupadd-g504asmadmin/usr/sbin/groupadd-g505asmoper/usr/sbin/groupadd-g506asmdba/usr/sbin/useradd-goinstall-Gdba,asmdba,operoracle/usr/sbin/useradd-goinstall-Gasmadmin,asmdba,asmoper,oper,dbagrid[root@ora1~]#idoracleuid=501(oracle)gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),506(asmdba)[root@ora1~]#idgriduid=502(grid)gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)mkdir/oracle/app/chown-Rgrid:oinstall/oracle/app/chmod-R775/oracle/app/mkdir-p/oracle/app/oraInventorychown-Rgrid:oinstall/oracle/app/oraInventorychmod-R775/oracle/app/oraInventorymkdir-p/oracle/app/gridmkdir-p/oracle/app/oraclechown-Rgrid:oinstall/oracle/app/gridchown-Roracle:oinstall/oracle/app/oraclechmod-R775/oracle/app/oraclechmod-R775/oracle/app/gridpasswdgridpasswdoracle2、操作系统版本：[root@rac1~]#lsb_release-aLSBVersion::core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarchDistributorID:EnterpriseEnterpriseServerDescription:EnterpriseLinuxEnterpriseLinuxServerrelease5.5(Carthage)Release:5.5Codename:Carthage[root@rac1~]#uname-aLinuxrac12.6.18-194.el5#1SMPMonMar2920:06:41EDT2010i686i686i386GNU/Linux[root@rac1~]#修改系统参数：vi/etc/security/limits.conf#ORACLESETTINGgridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536vi/etc/pam.d/login#ORACLESETTINGsessionrequiredpam_limits.so#vi/etc/sysctl.conf#ORACLESETTINGfs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmax=536870912kernel.shmmni=4096kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586gird时间同步所需要的设置(11gR2新增检查项)#NetworkTimeProtocolSetting/sbin/servicentpdstopchkconfigntpdoffrm/etc/ntp.confmv/etc/ntp.confto/etc/ntp.conf.org/dev/shm共享内存不足的处理解决方法：例如：为了将/dev/shm的大小增加到1GB，修改/etc/fstab的这行：默认的：none/dev/shmtmpfsdefaults00改成：none/dev/shmtmpfsdefaults,size=1024m00size参数也可以用G作单位：size＝1G。重新mount/dev/shm使之生效：#mount-oremount/dev/shm或者：#umount/dev/shm#mount-a马上可以用df-h命令检查变化。修改gird、oracle用户的.bash_profile文件：#grid用户配置文件ORACLE_HOSTNAME请自行设置TMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_SID=+ASM1;exportORACLE_SIDORACLE_BASE=/oracle/app/oracle;exportORACLE_BASEORACLE_HOME=/oracle/app/grid/product/11.2.0;exportORACLE_HOMENLS_DATE_FORMAT=yyyy-mm-ddHH24:MI:SS;exportNLS_DATE_FORMATTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHif[$USER=oracle]||[$USER=grid];thenif[$SHELL=/bin/ksh];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi#oracle用户配置文件ORACLE_HOSTNAME请自行设置#OracleSettingsoracleTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_BASE=/oracle/app/oracle;exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0;exportORACLE_HOMEORACLE_SID=racdb1;exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TERMPATH=/usr/sbin:$PATH;exportPATHPATH=$ORACLE_HOME/bin:$PATH;exportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;exportCLASSPATHNLS_DATE_FORMAT=yyyy-mm-ddHH24:MI:SS;exportNLS_DATE_FORMATNLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANGif[$USER=oracle]||[$USER=grid];thenif[$SHELL=/bin/ksh];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi配置信任关系设置SSH，1).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙#pingrac2-eth0#pingrac2-eth1#su-oracle$mkdir~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa2).在副节点RAC2、RAC3上执行相同的操作，确保通信无阻#pingrac1-eth0#pingrac1-eth1#su-oracle$mkdir~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa3).在主节点RAC1上oracle用户执行以下操作$cat~/.ssh/id_rsa.pub./.ssh/authorized_keys$cat~/.ssh/id_dsa.pub./.ssh/authorized_keys$sshrac2cat~/.ssh/id_rsa.pub~/.ssh/authorized_keys$sshrac2cat~/.ssh/id_dsa.pub~/.ssh/authorized_keys$scp~/.ssh/authorized_keysrac2:~/.ssh/authorized_keys4).主节点RAC1上执行检验操作$sshrac1date$sshrac2date$sshrac3date$sshrac1privdate$sshrac2privdate$sshrac3privdate5).在副节点RAC2上执行检验操作$sshrac1date$sshrac2date$sshrac3date$sshrac1privdate$sshrac2privdate$sshrac3privdate安装ASMoracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpmoracleasmlib-2.0.4-1.el5.i386.rpmoracleasm-support-2.1.3-1.el5.i386.rpm格式化硬盘Disk/dev/sdd:2147MB,2147483648bytes255heads,63sectors/track,261cylindersUnits=cylindersof16065*512=8225280bytesDeviceBootStartEndBlocksIdSystem/dev/sdd11261209645183LinuxDisk/dev/sde:2147MB,2147483648bytes255heads,63sectors/track,261cylindersUnits=cylindersof16065*512=8225280bytesDeviceBootStartEndBlocksIdSystem/dev/sde11261209645183LinuxDisk/dev/sdf:2147MB,214748