日期:2014-05-16  浏览次数:20555 次

Oracle 10g RAC 添加节点

目前环境是一个版本为10.2.0.5的双节点RAC,hostname分别为racnode1,racnode2需要添加新节点racnode3。

OS版本是Oracle Linux 5.7 x86_64



保证RAC正常运行

配置public IP,private IP,VIP,将这些信息配置到/etc/hosts文件中

192.168.1.51            racnode1
192.168.1.151           racnode1-vip
172.168.1.51            racnode1-priv

192.168.1.52            racnode2
192.168.1.152           racnode2-vip
172.168.1.52            racnode2-priv

192.168.1.53            racnode3
192.168.1.153           racnode3-vip
172.168.1.53            racnode3-priv

安装相关的rpm包,配置系统内核参数,我这里使用的是Oracle Linux5提供的的oracle-validated包进行安装配置

[root@racnode3 ~]# yum -y install oracle-validated
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
Setting up Install Process
Package oracle-validated-1.1.0-15.el5.x86_64 already installed and latest version

同步各节点的时间,我这里使用的是NTP服务

[root@racnode3 ~]# crontab -l
*/5 * * * * /usr/sbin/ntpdate 0.asia.pool.ntp.org > /dev/null 2>&1

配置共享磁盘

[root@racnode3 ~]# cat /etc/udev/rules.d/60-raw.rules 
# Enter raw device bindings here.
#
# An example would be:
#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sdc2", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="sdc3", RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="oinstall", MODE=="0660"
[root@racnode3 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules 
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB5407c582-c0bbcc9c_", NAME="asm-diskd", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB2048e338-447949c0_", NAME="asm-diske", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB6d6f72b0-997f769f_", NAME="asm-diskf", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB867b3aae-2e3a3f0b_", NAME="asm-diskg", OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi",