Oracle 11gR2构建RAC之(1)--配置系统环境
来源:互联网 发布:java模拟器安卓版5.0 编辑:程序博客网 时间:2024/06/07 02:36
Oracle 11gR2构建RAC之(1)--配置系统环境
系统环境:
操作系统:RedHat EL5
Cluster: Oracle GI(Grid Infrastructure)
Oracle: Oracle 11.2.0.1.0
如图所示:RAC 系统架构
对于Oracle 11G构建RAC首先需要构建GI(Grid Infrastructure)的架构
一、配置系统环境
1、网络环境(all nodes)[root@node1 ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost192.168.8.21 node1192.168.8.23 node1-vip10.10.10.21 node1-priv192.168.8.22 node2192.168.8.24 node2-vip10.10.10.22 node2-priv192.168.8.25 rac_scan--对于11g的RAC可以通过DNS服务器配置SCAN IP的解析,通过客户端连接时,实现负载均衡;如果没有配置DNS服务器,需在hosts文件解析SCAN IP,但不能实现负载均衡效果。--对于DNS的配置,见另一博文:http://tiany.blog.51cto.com/513694/1421917Oracle 11g RAC SCAN ip的原理及配置2、建立用户和组(all nodes)[root@node1 ~]# cat user.shgroupadd -g 200 oinstallgroupadd -g 201 dbagroupadd -g 202 opergroupadd -g 203 asmadmingroupadd -g 204 asmopergroupadd -g 205 asmdbauseradd -u 200 -g oinstall -G dba,asmdba,oper oracleuseradd -u 201 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid--尽量保证每个node上oracle和grid用户的UID一致。3、配置oracle和grid用户的环境变量(all nodes)oracle用户:[grid@node1 ~]$ cat .bash_profile export EDITOR=viexport ORACLE_SID=prod1 //node2 为prod2export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022grid用户:[grid@node1 ~]$ cat .bash_profile export EDITOR=viexport ORACLE_SID=+ASM1 //node2 为+ASM2export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/11.2.0/gridexport GRID_HOME=/u01/11.2.0/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport THREADS_FLAG=nativeexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 0224、建立CRS和Oracle软件主目录(all nodes)[root@node1 ~]# cat mkdir.shmkdir -p /u01/app/oraInventorychown -R grid:oinstall /u01/app/oraInventory/chmod -R 775 /u01/app/oraInventory/mkdir -p /u01/11.2.0/gridchown -R grid:oinstall /u01/11.2.0/grid/chmod -R 775 /u01/11.2.0/grid/mkdir -p /u01/app/oraclemkdir -p /u01/app/oracle/cfgtoollogsmkdir -p /u01/app/oracle/product/11.2.0/db_1chown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01/app/oracle5、配置系统内核参数(all nodes)[root@node1 ~]# cat /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586内核参数修改生效:[root@node1 ~]# sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 10485866、建立oracle和grid用户访问系统资源的限制(all nodes)[root@node1 ~]# cat /etc/security/limits.conf oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 102407、配置用户会话访问资源的限制(all nodes)[root@node1 ~]# cat /etc/pam.d/loginsession required /lib/security/pam_limits.so8、配置全局shell访问限制[root@node1 ~]#cat /etc/profileif [ $USER = "oracle" ]||[ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifi9、配置时间同步(all nodes) 在11g的RAC中GI自带了,时间同步的功能,所以不再需要操作系统同步的ntp service,在所有node关闭ntp service。[root@node1 ~]# chkconfig ntpd off[root@node1 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak
--未完待续
本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1422683
0 0
- Oracle 11gR2构建RAC之(1)--配置系统环境
- Solaris 10(x86)构建Oracle 11gR2 RAC之--配置系统环境(1)
- Solaris 10(x86)构建Oracle 11gR2 RAC之--配置系统环境(2)
- Oracle 11gR2构建RAC之(3)--安装grid前环境检测
- Oracle 11gR2构建RAC之(4)--安装GI
- Oracle 11gR2构建RAC之(2)--配置共享存储
- Solaris 10(x86)构建Oracle 10g RAC之--配置系统环境(1)
- Solaris 10(x86)构建Oracle 10g RAC之--配置系统环境(2)
- Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(1)
- Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(2)
- Oracle 11gR2构建RAC之(5)--安装Oracle并建库
- 构建AIX环境下的RAC之--配置系统环境(1)
- Oracle Study之--Oracle 11gR2构建RAC之hosts文件故障
- oracle 11gR2 RAC Client 配置
- Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(1)
- Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(2)
- Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(3)
- Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(4)
- IOS开发中常见的关键字
- Linux下配置DNS服务器之一--Master服务器
- Oracle 11g RAC SCAN ip的原理及配置
- Oracle动态SQL和静态SQL比较
- 动态SQL和静态SQL及绑定变量性能对比
- Oracle 11gR2构建RAC之(1)--配置系统环境
- Oracle 11gR2构建RAC之(2)--配置共享存储
- Oracle 11gR2构建RAC之(3)--安装grid前环境检测
- Oracle 11gR2构建RAC之(4)--安装GI
- Oracle 11gR2构建RAC之(5)--安装Oracle并建库
- Oracle RAC FailOver配置
- RMAN深入解析之--内存中的RMAN
- linux 压缩和打包
- RMAN深入解析之--控制文件