Oracle 10g RAC 添加节点

Oracle 10g RAC 添加节点

目前环境是一个版本为Oracle 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", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB4dcf4abf-0266b2fc_", NAME="asm-diskh", OWNER="oracle", GROUP="oinstall", MODE="0660" 
[root@racnode3 ~]# 
[root@racnode3 ~]# start_udev 
Starting udev:                                            [  OK  ] 
[root@racnode3 ~]# ls -l /dev/raw/raw* 
crw-rw---- 1 oracle oinstall 162, 1 Dec 24 14:31 /dev/raw/raw1 
crw-rw---- 1 oracle oinstall 162, 2 Dec 24 14:31 /dev/raw/raw2 
crw-rw---- 1 oracle oinstall 162, 3 Dec 24 14:31 /dev/raw/raw3 
crw-rw---- 1 oracle oinstall 162, 4 Dec 24 14:31 /dev/raw/raw4 
crw-rw---- 1 oracle oinstall 162, 5 Dec 24 14:31 /dev/raw/raw5 
[root@racnode3 ~]# ls -l /dev/asm-disk* 
brw-rw---- 1 oracle oinstall 8,  48 Dec 24 14:31 /dev/asm-diskd 
brw-rw---- 1 oracle oinstall 8,  64 Dec 24 14:31 /dev/asm-diske 
brw-rw---- 1 oracle oinstall 8,  80 Dec 24 14:31 /dev/asm-diskf 
brw-rw---- 1 oracle oinstall 8,  96 Dec 24 14:31 /dev/asm-diskg 
brw-rw---- 1 oracle oinstall 8, 112 Dec 24 14:31 /dev/asm-diskh