安裝11gr2 RAC

1.Oracle Installation Prerequisites
check software package 
rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh sysstat-9.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.* glibc-headers-2.*
rpm -Uvh ksh-2*
rpm -Uvh make-3.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-4.*.i686*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh gcc-4.*x86_64*
rpm -Uvh gcc-c++-4.*x86_64*
rpm -Uvh --allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*
rpm -Uvh elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*
rpm -Uvh libtool-ltdl*i686*
rpm -Uvh ncurses*i686*
rpm -Uvh readline*i686*
rpm -Uvh pdksh*
rpm -Uvh sysstat*
rpm -Uvh unixODBC*


configure kernel parameters(added to /etc/sysctl.conf file)
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#kernel.shmall = 2097152 
#kernel.shmmax = 1054504960
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
sysctl -p


configure limits(added to /etc/security/limits.conf file)
grid              soft    nproc   2047
grid              hard    nproc   16384
grid              soft    nofile  4096
grid              hard    nofile  65536
grid              soft    stack   10240
grid              hard    stack   32678


oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240
oracle              hard    stack   32678


configure pam module(added to /etc/pam.d/login file)
session    required     pam_limits.so


Create the new groups and users
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 asmadmin
groupadd -g 504 asmdba
groupadd -g 505 asmoper


useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
useradd -u 502 -g oinstall -G dba,asmdba oracle


echo oracle|passwd --stdin grid
echo oracle|passwd --stdin oracle


configure hosts file(added to /etc/hosts file)
# Public
192.168.1.31 rac1
192.168.1.32 rac2
# Private
192.168.2.31 rac1-priv
192.168.2.32 rac2-priv
# Virtual
192.168.1.131 rac1-vip
192.168.1.132 rac2-vip
# SCAN
192.168.1.231 rac-scan
192.168.1.232 rac-scan
192.168.1.233 rac-scan


configure ntp
service ntpd stop
chkconfig ntpd off
mv /etc/ntp.conf /etc/ntp.conf.bak


create directories for oracle software
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle/product/11.2.0/db_1
mkdir -p /u01/11.2.0/grid
chown -R grid:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oraInventory
chown -R grid:oinstall /u01/app/grid
chmod -R 775 /u01/app/grid
chown -R grid:oinstall /u01/11.2.0/grid
chmod -R 775 /u01/11.2.0/grid
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
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


configure environment for grid&oracle user(added to /home/$USER/.bash_profile)
su - grid
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/11.2.0/grid
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/bin:$PATH


su - oracle
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=RAC1
export PATH=$ORACLE_HOME/bin:$PATH


2.clone the second node


3.modify the second node
modify the hostname
modify the ip address


4.configure the shared storage using scsi rules(added to /etc/udev/rules.d/99-asm.rules)
run the following script and using the output as rules 
sum=1
for i in b c d e
do
echo "KERNEL==\"sd$i\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id -g -u -s /block/sd$i\", RESULT==\"`/sbin/scsi_id -g -u -s /block/sd$i`\", NAME=\"asm-disk$sum\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""
sum=$[$sum+1]
done


5.the addtional configure
install cvuqdisk package
export CVUQDISK_GRP=oinstall
rpm -ivh cvuqdisk*.rpm


run cluvfy script to verficate cluster environment
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose




6.install GI
./grid/runInstall.sh




7.install oracle software
./database/runInstall.sh


8.create asm diskgroup for database
./asmca


9.create database
./dbca