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

把数据库从Oracle迁移到Postgres Plus Advanced ServerOracle EXP-00011 导出数据时空表报错的解决相关资讯 Oracle 10g RAC

Oracle 10G RAC一节点系统重做后修（06月26日）
Oracle 10g RAC OCFS2集群存储迁移（01/22/2015 20:19:51）
Oracle 10g下修改RAC地址（07/29/2014 20:54:32）

Oracle 10g RAC修改IP/VIP地址示例（04月27日）
搭建Oracle 10g RAC过程中出现 OUI （08/08/2014 11:04:18）
Oracle 10g RAC 节点自动重启故障（07/03/2014 21:33:11）

本文评论查看全部评论（0）