虚拟机 安装RAC 步骤总结

0.定义2台主机名dbp,dbs.安装 rhel4,关闭防火墙和SELINUX服务
添加共享磁盘,选择scsi1:1,independence.

1.编辑虚拟机的配置文件,添加
disk.locking = "FALSE"
diskLib.dataCacheMaxSize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
scsi1.sharedBus = "virtual"

2.创建用户,更改密码
groupadd -g 1001 dba
groupadd -g 1002 oinstall
useradd -u 1001 -g oinstall -G dba oracle
passwd oracle

3.检查系统的rpm包,更新缺少的rpm包
rpm -q sysstat glibstdc++-33
rpm -ivh sysstat*

4.安装ASM的rpm包,编辑hosts文件,添加vip,priv
rpm -ivh oracleasm*
vi /etc/hosts
127.0.0.1       localhost.localdomain   lxocalhost
192.168.123.154       dbp
192.168.123.155       dbs
192.168.123.130       dbp-vip
192.168.123.131       dbs-vip
10.10.10.1            dbp-priv
10.10.10.2            dbs-priv

5.格式化共享磁盘,配置裸设备,配置asm
fdisk /dev/sdb
vi /etc/sysconfig/rawdevices
vi /etc/udev/permissions.d/50-udev.permissions
/sbin/service rawdevices restart

/etc/init.d/oracleasm configure
/etc/init.d/oracleasm createdisk VOL1 /dev/sdb5
/etc/init.d/oracleasm scandisks

6.配置系统内核参数
vi /etc/sysctl.conf

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

/sbin/sysctl –p

vi /etc/pam.d/login
session required /lib/security/pam_limits.so

vi /etc/security/limits.conf
oracle    soft  nproc  2047
oracle    hard  nproc  16384
oracle    soft  nofile  1024
oracle    hard  nofile  65536

7.hangcheck模块
find /lib/modules -name "hangcheck-timer.ko"
vi /etc/rc.d/rc.local
modprobe hangcheck-timer
vi /etc/modprobe.conf
options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
grep hangcheck /var/log/messages | tail -2

8.配置.bash_profile文件

umask=022
# User specific environment and startup programs
ORACLE_BASE=/home/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db; export ORACLE_HOME
ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs; export ORA_CRS_HOME
# Each RAC node must have a unique ORACLE_SID.(i.e. dbserver1, dbserver2,...)
ORACLE_SID=racdb2; export ORACLE_SID
PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin; export PATH
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin; export PATH
ORACLE_TERM=xterm; export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE; export CLASSPATH
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib; export CLASSPATH
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib; export CLASSPATH
#export THREADS_FLAG=native
TEMP=/tmp; export CLASSPATH
TMPDIR=/tmp; export CLASSPATH

9.复制第二个节点,添加第二块网卡.修改网卡ip

10.配置两台机器的网卡,能互相ping通

11.配置时间同步
vi /etc/rc.local
while [ 1 ];
do ntpdate dbp 1>/dev/null 2>&1;
sleep 2;
done &

dbp:
chkconfig -- level 2345 ntpd on
service ntpd start
dbs:
chkconfig -- level 2345 ntpd off
循环同步dbp的时间

12.配置ssh
ssh-keygen -t rsa
ssh-keygen -t dsa

13.修改第二个节点的.bash_profile的ORACLE_SID
vi .bash_profile

14.修改第二个节点的hostname
vi /etc/sysconfig/network

15.集群安装前检查
./runcluvfy.sh stage -post hwos -n dbp,dbs -verbose

16.手工建库
在节点1输入racdb1.sh,输入密码
在节点2运行racdb2.sh,输入密码

16.关闭下列linux服务
chkconfig --level 2345 pcmcia off
chkconfig --level 2345 kudzu off
chkconfig --level 2345 isdn off
chkconfig --level 2345 sendmail off
chkconfig --level 2345 rhnsd off
chkconfig --level 2345 cups off
chkconfig --level 2345 cups-config-daemon off
chkconfig --level 2345 cpuspeed off
chkconfig --level 2345 gpm off
chkconfig --level 2345 apmd off
chkconfig --level 2345 lm_sensors off
chkconfig --level 2345 mdmonitor off

crs起不来

/etc/init.d/init.crs stop

/etc/init.d/init.crs start
控制台 emctl start dbconsole

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16313359/viewspace-682464/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16313359/viewspace-682464/