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

目前环境是一个版本为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_",, OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB2048e338-447949c0_",, OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB6d6f72b0-997f769f_",, OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB867b3aae-2e3a3f0b_",, OWNER="oracle", GROUP="oinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB4dcf4abf-0266b2fc_",, 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

【数据库】Oracle 10g RAC 添加节点