Centos6.5 + Oracle 11g R2 + NFS build RAC Environment one

• Environmental requirements:

1.2 system for Centos6.5 machines , of which 1 do NFS (hard disk size at least 4T)

2. At least 2 NICs per machine

3. Prepare 5 available IP addresses (one for scan, two for each configuration public and private address)

4. Memory at least 2G or less, we recommend using 4G or higher

• Address planning:

First Host: Rac1 Network card eth0 IP address: 172.16.0.1/24 card eth1 address: 192.168.1.192/24

First Host: Rac1 Network card eth0 IP address : 172.16.0.2/24 Nic Eth1:192.168.1.193/24

Virtual IP Address: 192.168.1.200

• Turn off NTP and configure Yum the local source

Close service #/etc/init.d/ntpd stop#chkconfig ntpd off#mv/etc/ntp.conf/etc/ntp.conf.org#mkdir/mnt/cdrom/#mount/dev/cdrom/ mnt/cdrom/#vim/etc/yum.repos.d/centos-media.reponame=centos-$releasever-mediabaseurl=file:///mnt/cdrom/ Gpgcheck=0enabled=1

• Installing dependent Packages  

#yum  -y install binutils-2*.rpm      compat-libstdc++-33*.rpm       elfutils-libelf-0.*.rpm       elfutils-libelf-devel-*.rpm      gcc-4*.rpm       gcc-c++-4*.rpm      glibc-2.*.rpm       glibc-common-2*.rpm      glibc-devel-2*.rpm       libaio-0*.rpmlibgcc-4*.rpm      libstdc++-4*.rpm       libstdc++-devel*.rpm      make-3*.rpm       pdksh-*.rpm      sysstat-7*.rpm      libaio-devel- *.rpm      unixodbc-2*.rpm      unixodbc-devel-2*. Rpm    \

• Configuring the Host File

#vim/etc/hosts#public 172.16.0.1 rac1-priv 172.16.0.2 rac2-priv#virtual 192.168.1.194 rac1-vip192.168.1.195 RAC2-VIP # Scan 192.168.1.200 rac-scan#nas192.168.1.194 NAS1

• modifying kernel parameters

#vim/etc/sysctl.conf Add fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912 on the last side Kernel.shmmni = 4096kernel.sem = 32000 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144n Et.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576#sysctl-p

• Limitations of modifying file descriptors

#vi/etc/security/limits.conf Oracle Soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536 Grid soft Nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard Nofile 65536

• Add pam_limits.so Module  

Vim/etc/pam.d/login Add session required pam_limits.so at the end

• Adding profile environment Profiles

#vim/etc/profile at the end of the add if [$USER = "Oracle"] | | [$USER = "Grid"]; thenif [$SHELL = "/bin/ksh"]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fiumask 022fi

• Create users and groups and create the appropriate passwords

#/usr/sbin/groupadd-g 501 OINSTALL#/USR/SBIN/GROUPADD-G 502 dba#/usr/sbin/groupadd-g 503 oper#/usr/sbin/groupadd-g 50 4 asmadmin#/usr/sbin/groupadd-g 505 asmoper#/usr/sbin/groupadd-g 506 Asmdba#/usr/sbin/useradd-g OINSTALL-GDBA,ASMDBA , Oper oracle#/usr/sbin/useradd-g oinstall-gasmadmin,asmdba,asmoper,oper,dba grid#passwd oracle#passwd grid

Create a directory and set appropriate permissions

#mkdir  -p /u01/app/oracle#chown -r oracle:oinstall /u01/app/oracle#chmod -r  775 /u01/app/oracle#mkdir -p /u01/app/oracle/product/11.2.0/db_1#chown -R  Oracle:oinstall/u01/app/oracle/product/11.2.0/db_1#chmod -r 775/u01/app/oracle/product/11.2.0/db_1   #mkdir  -p /u01/app/grid#chown -r grid.oinstall /u01/app/grid#chmod -r  775 /u01/app/grid#mkdir -p /u01/app/11.2.0/grid#chown -r grid:oinstall / u01/app/11.2.0/grid#chmod -r 775 /u01/app/11.2.0/grid  #mkdir  -p /u01/app/ orainventory#chown -r grid:oinstall/u01/app/orainventory#chmod -r 775 /u01/app/ Orainventory#mkdir -p /u01/oradata#mkdir -p /u01/shared_config#chown -r oracle:o install /u01/oradata#chown -r grid:oinstall /u01/ shared_config#chmod -r  775 /u01/oradata/u01/shared_config

• < /span> Modify the grid user environment variable

#su  - grid$ vim /home/zkyg/.bash_profile alias df= ' df -h ' alias du= ' du  -sh ' alias la= ' Ls -lha ' oracle_sid=nfs1; export oracle_sidjava_home=/usr/local/java;  export JAVA_HOMEORACLE_BASE=/u01/app/grid; exportORACLE_BASEORACLE_HOME=/u01/app/11.2.0/grid;  exportORACLE_HOMEORACLE_PATH=/u01/app/oracle/common/oracle/sql;export ORACLE_PATHORACLE_TERM=xterm;  export oracle_termnls_date_format= "Dd-mon-yyyyhh24:mi:ss";  export nls_date_formattns_ admin= $ORACLE _home/network/admin;export tns_adminora_nls11= $ORACLE _home/nls/data; exportora_ Nls11path=.:${java_home}/bin:${path}: $HOME/bin: $ORACLE _home/binpath=${path}:/usr/bin:/bin:/usr/bin/x11:/usr/ Local/binpath=${path}:/u01/app/common/oracle/binexport pathld_library_path= $ORACLE _home/libld_library_ Path=${ld_library_path}: $ORACLE _home/oracm/libld_library_path=${ld_library_path}:/lib:/usr/lib:/usr/local/ Libexport ld_library_pathclassPath= $ORACLE _home/jreclasspath=${classpath}: $ORACLE _home/jlibclasspath=${classpath}: $ORACLE _home/rdbms/ Jlibclasspath=${classpath}: $ORACLE _home/network/jlibexport classpaththreads_flag=native; export  threads_flagexport temp=/tmpexport tmpdir=/tmpumask 022

• modify Oracle user environment variables

alias df= ' df -h ' alias du= ' du -sh ' alias la= ' Ls -lha ' ORACLE_SID=racdb1;  export oracle_sidoracle_unqname=racdb; export oracle_unqnamejava_home=/usr/local/java;  Export java_homeoracle_base=/u01/app/oracle; exportoracle_baseoracle_home= $ORACLE _base/product/ 11.2.0/db_1;export oracle_homeoracle_path=/u01/app/common/oracle/sql;export oracle_pathoracle_term= xterm; export oracle_termnls_date_format= "Dd-mon-yyyyhh24:mi:ss";  export nls_date_ formattns_admin= $ORACLE _home/network/admin;export tns_adminora_nls11= $ORACLE _home/nls/data;  Exportora_nls11path=.:${java_home}/bin:${path}: $HOME/bin: $ORACLE _home/binpath=${path}:/usr/bin:/bin:/usr/bin/ X11:/usr/local/binpath=${path}:/u01/app/common/oracle/binexport pathld_library_path= $ORACLE _home/libld_ Library_path=${ld_library_path}: $ORACLE _home/oracm/libld_library_path=${ld_library_path}:/lib:/usr/lib:/usr/ Local/libexport ld_library_pathclasspath= $ORACLE _home/jreclasspath=${classpath}: $ORACLE _home/jlibclasspath=${classpath}: $ORACLE _home/rdbms/ Jlibclasspath=${classpath}: $ORACLE _home/network/jlibexport classpaththreads_flag=native; export  threads_flagexport temp=/tmpexport tmpdir=/tmpumask 022

• config dual-machine Trust ( user to configure) to

$ ssh-keygen-t rsa$ ssh-keygen-t DSA $ ssh-keygen-t rsa$ ssh-keygen-t DSA $ cat. Ssh/id_rsa.pub >> Ssh/authoriz ed_keys$ cat. Ssh/id_dsa.pub >>.ssh/authorized_keys$ ssh rac2 cat. Ssh/id_rsa.pub >>.ssh/authorized_keys$ SSH rac2 cat. Ssh/id_dsa.pub >>.ssh/authorized_keys$ Scp.ssh/authorized_keys Rac2:.ssh/authorized_keys

• Test in two machines is normal

$ssh Rac1 date$ssh Rac2 Date

The above operation needs to be operated on two machines

• Configuration NFS

Rac1 use fdisk /dev/sdb  to 2 zones sdb1, SDB2, and format #mkfs.ext3 /dev/sdb1#mkfs.ext3 /dev/ Create a shared directory on Sdb2rac1 #mkdir -p /shared_config#mkdir -p /shared_data#vi /etc/fstab     Add the following:/dev/sdb1         /shared_config          ext3 defaults   0 0/dev/sdb2          /shared_data            ext3 defaults   0 0#vi /etc/exports  set up shared/shared_config     * (Rw,sync,no_wdelay,insecure_locks,no_root_squash)/shared_data        * (Rw,sync,no_wdelay,insecure_locks,no_root_squash) #chkconfig  nfs on to turn on NFS services #service  Nfs restart#vi /etc/fstab Add the following boot Mount shared directory Nas1:/shared_config /u01/shared_config  nfs  rw,bg,hard,nointr,noac,tcp,vers=3,timeO=600,rsize=32768,wsize=32768,actimeo=0  0 0nas1:/shared_data   /u01/oradata  nfs  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0  0  0 mount the appropriate directory #mount /u01/shared_config#mount /u01/oradata#chown grid:oinstall /u01/shared _config#chown oracle:oinstall /u01/oradata#chmod 775 /u01/oradata#chmod 775 /u01 /app/11.2.0/grid

• installation Grid Software

Unzip grid-xxx.zip under root enter Xhost + #su –grid$cd grid-xxx$./runcluvfy.sh stage-pre crsinst-n rac1,rac2-fixup-verbose | Tee Check_grid.txt If the last hint: the pre-check of the Cluster service setting is successful. You can start to install the grid otherwise check if the failure is resolved after the command line is executed again. Run the runinstaller$./runinstaller in the installation directory

This article is from the "junly" blog, make sure to keep this source http://junly917.blog.51cto.com/2846717/1919015

Centos6.5 + Oracle 11g R2 + NFS build RAC Environment one