11G搭建的高可用性模型---RAC

《11G搭建的高可用性模型---RAC》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、--安装RAC准备/usr/sbin/groupadd-g1000oinstall/usr/sbin/groupadd-g1020asmadmin/usr/sbin/groupadd-g1021asmdba/usr/sbin/groupadd-g1022asmoper/usr/sbin/groupadd-g1031dba/usr/sbin/groupadd-g1032oper/usr/sbin/useradd-u1100-goinstall-pgrid-Gasmadmin,asmdbagrid/usr/sbin/user

2、add-u1101-goinstall-poracle-Gasmdba,dbaoraclepasswdoraclepasswdgrid #!/bin/bashmkdir-p/u01/app/gridmkdir-p/u01/app/11.2.0/grid_homemkdir-p/u01/app/oracle/11.2.0/dbhome_1chown-Rgrid:oinstall/u01/app/gridchown-Rgrid:oinstall/u01/app/11.2.0/grid_homechown-Roracle:oi

3、nstall/u01/app/oraclechownroot:oinstall/u01chownroot:oinstall/u01/appchmod775-R/u01  mv/etc/ntp.conf/etc/ntp.conf.bak 编辑/etc/hosts#publicip192.168.1.50rac1192.168.1.51rac2#privateip10.0.0.1rac1-priv10.0.0.2rac2-priv#virtualip192.168.1.52rac1-vip192.168.1.53rac2-v

4、ip#scan-ip192.168.1.54rac-scan 编辑/etc/sysctl.conffs.aio-max-nr=1048576fs.file-max=6815744kernel.shmmni=4096kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wme

5、m_max=1048576 sysctl-pcat/proc/meminfo查看巨页内存配置 编辑/etc/grub.conf在kernelxxx最后加入transparent_hugepage=never 编辑/etc/security/limits.confgridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536gridsoftstack10240gridhardstack10240oraclesoftnproc2047oracl

6、ehardnproc16384oraclesoftnofile1024oraclehardnofile65536oraclesoftstack10240oraclehardstack10240*softmemlock<大于(DB_SGA+ASM_SGA)kb>*hardmemlock<大于(DB_SGA+ASM_SGA)kb> 修改文件/etc/pam.d/loginsessionrequiredpam_limits.so  编辑/etc/selinux/config，设置SELINUX=disabled(别误改SELI

7、NUXTYPE) 执行setenforce0关闭防火墙  创建目录脚本#!/bin/bash#createtheoracleInventorydirmkdir-p/u01/app/oraInventorychown-Rgrid:oinstall/u01/app/oraInventorychmod-R775/u01/app/oraInventory #creatingtheoraclegridinfrastructurehomemkdir-p/u01/11.2.0/gridchown-Rgrid:oinstall/u01/

8、11.2.0/gridchmod-R775/u01/11.2.0/grid #creatingtheoraclebasedirmkdir-p/u01/app/oraclemkdir-p/u01/app/oracle/cfgtoollogschown-Roracle:oinstall/u01/app/oraclechm