11gR2 RAC安装

0.配置网卡

0.1.配置rac01公网

vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0 
HWADDR=66:66:66:66:66:66 
TYPE=Ethernet 
UUID=2e423187-4212-4ee9-9ea1-63e4daf2bb9f 
ONBOOT=yes 
NM_CONTROLLED=yes 
BOOTPROTO=static 
IPADDR=192.168.12.31 
GATEWAY=192.168.12.6 
PREFIX=24

0.2.配置rac02公网

vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0 
HWADDR=66:66:66:66:66:66 
TYPE=Ethernet 
UUID=2e423187-4212-4ee9-9ea1-63e4daf2bb9f 
ONBOOT=yes 
NM_CONTROLLED=yes 
BOOTPROTO=static 
IPADDR=192.168.12.32 
GATEWAY=192.168.12.6 
PREFIX=24

0.3.配置rac01私网

vi /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1 
TYPE=Ethernet 
ONBOOT=yes 
NM_CONTROLLED=yes 
BOOTPROTO=static 
IPADDR=100.100.100.10 
PREFIX=24

0.4.配置rac02私网

vi /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1 
TYPE=Ethernet 
ONBOOT=yes 
NM_CONTROLLED=yes 
BOOTPROTO=static 
IPADDR=100.100.100.11 
PREFIX=24

2.关闭防火墙

service iptables stop 
chkconfig iptables off

3.关闭selinux

setenforce 0 
vi /etc/selinux/config

SELINUX=disabled

7.配置HOST

7.1.HOST文件修改

• 各节点都要配置 
  

vi /etc/hosts 

 #rac01 
192.168.12.31 jyk1.com jyk1 
100.100.100.10 jyk1-priv.com jyk1-priv 
192.168.12.33 jyk1-vip.com jyk1-vip 

#rac02 
192.168.12.32 jyk2.com jyk2 
100.100.100.11 jyk2-priv.com jyk2-priv 
192.168.12.34 jyk2-vip.com jyk2-vip 

#rac-scan 
192.168.12.35 jyk-scan.com jyk-scan

7.2.配置NETWORK

配置RAC1

vi /etc/sysconfig/network

NETWORKING=yes 
HOSTNAME=jyk1 
NOZEROCONF=yes

配置RAC2

vi /etc/sysconfig/network

NETWORKING=yes 
HOSTNAME=jyk2 
NOZEROCONF=yes

10.用户组准备

10.1.创建用户组

groupadd -g 500 oinstall 
groupadd -g 501 dba 
groupadd -g 502 oper 
groupadd -g 503 asmadmin 
groupadd -g 504 asmoper 
groupadd -g 505 asmdba

10.2.创建用户

useradd -s /bin/bash -g oinstall -G dba,asmdba,oper oracle 
useradd -s /bin/bash -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

10.3.更改密码

passwd grid 
passwd oracle

10.4.创建目录

mkdir -p /u01/app/grid/base 
mkdir -p /u01/app/grid/oraInventory 
mkdir -p /u01/app/grid/11.2.0 
chown -R grid:oinstall /u01/app/grid 
chmod -R 775 /u01/app/grid 
mkdir -p /u01/app/oracle 
chown -R oracle:oinstall /u01/app/oracle/ 
chmod -R 775 /u01/app/oracle/

1.安装依赖

1.1.CDROM中的依赖

mount /dev/cdrom1 /mnt/ 
cd /mnt/Packages 
rpm -ivh --nodeps unzip*.rpm 
rpm -ivh --nodeps binutils*.rpm 
rpm -ivh --nodeps compat-libstdc++-33*.rpm 
rpm -ivh --nodeps elfutils-libelf*.rpm 
rpm -ivh --nodeps elfutils-libelf-devel*.rpm 
rpm -ivh --nodeps gcc*.rpm 
rpm -ivh --nodeps gcc-c++*.rpm 
rpm -ivh --nodeps glibc*.rpm 
rpm -ivh --nodeps glibc-common*.rpm 
rpm -ivh --nodeps glibc-devel*.rpm 
rpm -ivh --nodeps glibc-headers*.rpm 
rpm -ivh --nodeps ksh*.rpm 
rpm -ivh --nodeps cvuqdisk*.rpm 
rpm -ivh --nodeps libaio*.rpm 
rpm -ivh --nodeps libaio-devel*.rpm 
rpm -ivh --nodeps libgcc*.rpm 
rpm -ivh --nodeps libgomp*.rpm 
rpm -ivh --nodeps libstdc++*.rpm 
rpm -ivh --nodeps libstdc++-devel*.rpm 
rpm -ivh --nodeps make*.rpm 
rpm -ivh --nodeps numactl-devel*.rpm 
rpm -ivh --nodeps sysstat*.rpm 
rpm -ivh --nodeps unixODBC*.rpm 
rpm -ivh --nodeps unixODBC-devel*.rpm 
rpm -ivh --nodeps cpp-4.4.6-4.el6.x86_64.rpm 
rpm -ivh --nodeps ppl-0.10.2-11.el6.x86_64.rpm 
rpm -ivh --nodeps cloog-ppl-0.15.7-1.2.el6.x86_64.rpm 
rpm -ivh --nodeps mpfr-2.4.1-6.el6.x86_64.rpm 
rpm -ivh --nodeps compat-libcap1-1.10-1.x86_64.rpm 
rpm -ivh --nodeps smartmontools-5.43-1.el6.x86_64.rpm 
rpm -ivh --nodeps oracle-rdbms-server-11gR2-preinstall-1.0-10.el6.x86_64.rpm

1.2.ASM lib包

rpm -ivh --nodeps oracleasm-support-2.1.8-1.el6.x86_64.rpm

1.3.CVU包

rpm -ivh --nodeps cvuqdisk-1.0.9-1.rpm

4.修改SHM

df -h /dev/shm 
umount tmpfs 
mount -t tmpfs shmfs -o size=6g /dev/shm 
vi /etc/fstab 
tmpfs /dev/shm tmpfs default,size=66G 0 0

5.关闭NTP

/sbin/service ntpd stop 
chkconfig ntpd off 
mv /etc/ntp.conf /etc/ntp.conf.old 
rm /var/run/ntpd.pid

8.配置内核参数

vi /etc/sysctl.conf

kernel.shmall = 4294967296 
kernel.shmmax = 34359738368 
fs.aio-max-nr = 1048576 
fs.file-max = 6815744 
kernel.shmmni = 65537 
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

9.设置oracle用户的shell限制

vi /etc/security/limits.conf

oracle soft nproc 2047 
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536 
grid soft nproc 2047 
grid hard nproc 16384 
grid soft nofile 1024 
grid hard nofile 65536

vi /etc/pam.d/login

session required /lib/security/pam_limits.so 
session required pam_limits.so

11.修改环境变量

11.1.grid用户执行

vi ~/.bash_profile

export TMP=/tmp 
export TMPDIR=$TMP 
export ORACLE_SID=+ASM1 
export ORACLE_BASE=/u01/app/grid/base 
export ORACLE_HOME=/u01/app/grid/11.2.0 
export ORACLE_TERM=xterm 
export TNS_ADMIN=$ORACLE_HOME/network/admin 
export PATH=$ORACLE_HOME/bin:$PATH 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib 
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 
export EDITOR=vi 
export LANG=en_US 
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 
umask 022

source ~/.bash_profile

11.2.oracle用户执行

vi ~/.bash_profile

export TMP=/tmp 
export TMPDIR=$TMP 
export ORACLE_HOSTNAME=jyk1 
export ORACLE_SID=jyk1 
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 
export ORACLE_UNQNAME=jyk 
export TNS_ADMIN=$ORACLE_HOME/network/admin 
export ORACLE_TERM=xterm 
export PATH=$ORACLE_HOME/bin:$PATH 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib 
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 
export EDITOR=vi 
export LANG=en_US 
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 
umask 022

source ~/.bash_profile

12.设置SSH互信

12.1.grid用户执行

ssh-keygen 
ssh-copy-id -i /home/grid/.ssh/id_rsa grid@jyk1 
ssh-copy-id -i /home/grid/.ssh/id_rsa grid@jyk2 
ssh-copy-id -i /home/grid/.ssh/id_rsa grid@jyk1-priv 
ssh-copy-id -i /home/grid/.ssh/id_rsa grid@jyk2-priv

12.2.oracle用户执行

ssh-keygen 
ssh-copy-id -i /home/oracle/.ssh/id_rsa oracle@jyk1 
ssh-copy-id -i /home/oracle/.ssh/id_rsa oracle@jyk2 
ssh-copy-id -i /home/oracle/.ssh/id_rsa oracle@jyk1-priv 
ssh-copy-id -i /home/oracle/.ssh/id_rsa oracle@jyk2-priv

12.3验证

ssh jyk1 date 
ssh jyk2 date 
ssh jyk1-priv date 
ssh jyk2-priv date

13.创建ASM磁盘

13.1.配置ASM库文件

/etc/init.d/oracleasm configure 
grid 
asmadmin 
y 
y

/etc/init.d/oracleasm enable --开启

13.2.创建ASM磁盘

13.2.1.格式化磁盘

fdisk /dev/sdb 
n p 1 回车 回车 w 
/etc/init.d/oracleasm createdisk ARCH /dev/sdb1

13.2.2 裸设备

vi /etc/sysconfig/rawdevices

/dev/raw/raw1 /dev/sdb1 
/dev/raw/raw2 /dev/sdc1

vi /etc/udev/rules.d/60-raw.rules

ACTION=="add", KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %N" 
ACTION=="add", KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw2 %N" 
ACTION=="add", KERNEL=="raw[1-3]", OWNER="oracle", GROUP="oinstall", MODE="660"

检验ASM磁盘组

oracleasm scandisks 
oracleasm listdisks

14.安装grid

14.1.解压grid包

unzip p13390677_112040_Linux-x86-64_3of7.zip

14.2.环境检查

./runcluvfy.sh stage -pre crsinst -n jyk1,jyk2 -fixup -verbose > runcluvfy.rst

15.安装软件

参照之前的单节点安装，直接选择RAC就行

快速安装ASM环境Oracle数据库