Environment:
OS:RedHat 6.3
Oracle Media:11.2.3.0
Theory:
1.config host
192.168.1.165 zbdba1
192.168.1.167 zbdba2
192.168.1.178 zbdba3
192.168.1.166 zbdba1-vip
192.168.1.168 zbdba2-vip
192.168.1.179 zbdba3-vip
172.168.1.181 zbdba1-priv
172.168.1.182 zbdba2-priv
172.168.1.183 zbdba3-priv
192.168.1.169 node-cluster node-cluster-scan
2.firewall and selinux
service iptables stop
chkconfig iptables off
chkconfig --list iptables
3.kernel:
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
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
4.create user and group:
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 asmadmin
groupadd -g 504 asmdba
useradd -u 501 -g oinstall -G dba,asmdba -d /home/oracle oracle
useradd -u 502 -g oinstall -G asmdba,asmadmin,dba -d /home/grid grid
5.create dictionary:
mkdir -p /opt/oracle/products/
mkdir -p /opt/oracle/products/11.2.0
mkdir -p /opt/oracle/diag
mkdir -p /opt/ogrid
mkdir -p /opt/grid/products/
mkdir -p /opt/grid/oraInventory/
mkdir -p /opt/grid/products/11.2.0
mkdir -p /opt/oraInventory
chown -Rf oracle:oinstall /opt/oracle
chown -Rf grid:oinstall /opt/grid
chown -Rf grid:oinstall /opt/ogrid
chown -Rf grid:oinstall /opt/oraInventory
6.OpenSSH:
first: unzip the install-package
/database/grid/sshsetup/sshUserSetup.sh -user grid -hosts "zbdba1 zbdba2 zbdba3" -noPromptPassphrase -confirm -advanced
/database/database/sshsetup/sshUserSetup.sh -user oracle -hosts "zbdba1 zbdba2 zbdba3" -noPromptPassphrase -confirm -advanced
7.limits:
oracle soft nproc 4096
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 4096
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768
8.package
oracle recomends:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
you should have configed yum local source
yum install -y binutils-* compat-libcap1* compat-libstdc++-* gcc-* glibc-* glibc-devel-* ksh* libgcc-* libstdc++-* libstdc++-devel-* libaio-* libaio-devel-* make-* sysstat-* elfutils-libelf-devel-*
9.asmdisk:
use iscsid
yum install -y iscsi-initiator-utils
iscsi:
iscsiadm --mode discoverydb --type sendtargets --portal 192.168.1.201 --discover
iscsiadm --mode node --targetname zhaojingbo.woqutech.com --portal 192.168.1.201:3260 –login
注意设置开机自动生效：chkconfig iscsid on service iscsid start
udev:
for i in b c d a;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/s