Shulou(Shulou.com)06/01 Report--

Construction of RAC by Oracle 11gR2 (1)-- configuring system Environment

System environment:

Operating system: RedHat EL5

Cluster: Oracle GI (Grid Infrastructure)

Oracle: Oracle 11.2.0.1.0

As shown in the figure: RAC system architecture

For Oracle 11G to build RAC, we first need to build the architecture of GI (Grid Infrastructure).

I. configure the system environment

1. Network environment (all nodes) [root@node1 ~] # cat / etc/hosts# Do not remove the following line For 11g RAC, 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-- can configure SCAN IP parsing through DNS server. Achieve load balancing when connecting through the client If the DNS server is not configured, the SCAN IP needs to be parsed in the hosts file, but the load balancing effect cannot be achieved. -- for DNS configuration See another blog post: principle and configuration of http://tiany.blog.51cto.com/513694/1421917Oracle 11g RAC SCAN ip 2. Establish users and groups (all nodes) [root@node1] # cat user.shgroupadd-g 200oinstallgroupadd-g 201dbagroupadd-g 202opergroupadd-g 203asmadmingroupadd-g 204asmopergroupadd-g 205asmdbauseradd-u 200-g oinstall-G dba,asmdba,oper oracleuseradd-u 201-g oinstall-G asmadmin,asmdba,asmoper,oper Dba grid-- tries to ensure that the UID of oracle and grid users on each node is the same. 3 、 Configure environment variables for oracle and grid users (all nodes) oracle user: [grid@node1 ~] $cat .bash _ profile export EDITOR=viexport ORACLE_SID=prod1 / / node2 is 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 user: [grid@node1 ~ ] $cat .bash _ profile export EDITOR=viexport ORACLE_SID=+ASM1 / / node2 is + 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, Establish CRS and Oracle Software Home Directory (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, Configure system kernel parameters (all nodes) [root@node1 ~] # cat / etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 32000 100 128net.ipv4.ip_local_port_range = 9000100 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586 kernel parameter modification takes effect: [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 = 25032000 100 128net.ipv4.ip_local_port_range = 900065500net. Core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 10485866, Establish restrictions on oracle and grid users' access to system resources (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 、 Configure user session access restrictions (all nodes) [root@node1 ~] # cat / etc/pam.d/loginsession required / lib/security/pam_limits.so8, configure global shell access restrictions [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, configuration time synchronization (all nodes) GI comes with the function of time synchronization in 11g RAC, so the ntp service synchronized by the operating system is no longer needed, and turn off ntp service in all node. [root@node1 ~] # chkconfig ntpd off [root@node1 ~] # mv / etc/ntp.conf / etc/ntp.conf.bak

-- to be continued

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.