简单描述一下,在Oracle 10203 for Solaris sparc的RAC双节点环境中,新增一个节点的过程。共享存储已经在第三个节点上配置完成,这里主要介绍操作系统上和Oracle上的配置。

这一篇介绍准备过程。



首先是将主机的IP地址,调整到RAC服务器IP地址附近,方便管理。修改目标主机IP地址到172.25.198.226。

# ifconfig ce0 172.25.198.226 netmask 255.255.0.0 broadcast 172.25.255.255


然后修改/etc/hosts文件中的IP地址。

下面将主机名也修改为配套的主机名信息racnode3:

# hostname      


supingsol


# hostname racnode3


利用hostname设置主机名后,还要分别修改/etc/hosts、/ect/nodename、/etc/hostname.ce0、/etc/net/ticlts/hosts、/etc/net/ticots/hosts、/etc/net/ticotsord/hosts这6个文件:

# more /etc/hosts


#


# Internet host table


#


127.0.0.1       localhost      


172.25.198.226  racnode3        loghost


192.168.192.109 rw    


# more /etc/nodename


racnode3


# more /etc/hostname.ce0


racnode3


# more /etc/net/ticlts/hosts


#


# Copyright 2003 Sun Microsystems, Inc.  All rights reserved.


# Use is subject to license terms.


#


# ident "@(#)hosts      1.3    03/12/07SMI"


#


# NOTE: This file is no longer consulted and may be removed from a future


#       release of Solaris.


#


racnode3


# more /etc/net/ticots/hosts


#


# Copyright 2003 Sun Microsystems, Inc.  All rights reserved.


# Use is subject to license terms.


#


# ident "@(#)hosts      1.3     03/12/07 SMI"


#


# NOTE: This file is no longer consulted and may be removed from a future


#       release of Solaris.


#


racnode3


# more /etc/net/ticotsord/hosts


#


# Copyright 2003 Sun Microsystems, Inc.  All rights reserved.


# Use is subject to license terms.


#


# ident "@(#)hosts      1.3     03/12/07 SMI"


#


# NOTE: This file is no longer consulted and may be removed from a future


#       release of Solaris.


#


racnode3


下面添加用户和组信息,根据RAC节点的组信息和用户信息在当前节点创建用户和组:

# groupadd -g 100 oinstall


# groupadd -g 101 dba


# mkdir /export/home/oracle


# useradd -u 100 -g oinstall -G dba -d /export/home/oracle oracle


# chown oracle:oinstall /export/home/oracle


# mkdir /data


# chown -R oracle:oinstall /data


# id nobody


uid=60001(nobody) gid=60001(nobody)


# passwd oracle


用Oracle用户登陆,设置环境变量:

# su - oracle


Sun Microsystems Inc.   SunOS 5.10      Generic January 2005


$ vi .profile


".profile"[新文件]


umask 022


ORACLE_SID=testrac3


export ORACLE_SID


ORACLE_BASE=/data/oracle


export ORACLE_BASE


ORACLE_HOME=/data/oracle/product/10.2/database


export ORACLE_HOME


NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'


export NLS_LANG


PATH=$PATH:$ORACLE_HOME/bin


export PATH


DISPLAY=172.25.6.201:1.0


export DISPLAY


修改/etc/hosts文件添加public id, private id和vitual id:

# vi /etc/hosts


"/etc/hosts"[只读取]13行,300字符


#


# Internet host table


#


127.0.0.1       localhost


172.25.198.226 racnode3 loghost


172.25.198.227 racnode3-vip


10.0.0.3 racnode3-priv


172.25.198.222 racnode1


172.25.198.224 racnode1-vip


10.0.0.1 racnode1-priv


172.25.198.223 racnode2


172.25.198.225 racnode2-vip


10.0.0.2 racnode2-priv


在其他两个节点,分别添加下面的内容:

172.25.198.226 racnode3


172.25.198.227 racnode3-vip


10.0.0.3 racnode3-priv


在节点1、节点2和当前节点,编辑/export/home/oracle/.rhosts文件,内容如下:

racnode1


racnode1-vip


racnode1-priv


racnode2


racnode2-vip


racnode2-priv


racnode1


racnode1-vip


racnode1-priv


racnode2


racnode2-vip


racnode2-priv


racnode3


racnode3-vip


racnode3-priv


在当前服务器上,添加PRIVATE IP地址:

# ifconfig -a


lo0: flags=2001000849 mtu 8232 index 1


       inet 127.0.0.1 netmask ff000000


ce0: flags=1000843 mtu 1500 index 2


       inet 172.25.198.226 netmask ffff0000 broadcast 172.25.255.255


       ether 0:3:ba:2c:d8:da


# ifconfig ce1 plumb


# ifconfig ce110.0.0.3 netmask 255.255.255.0 broadcast 10.0.0.255 up


为了启动后,ce1可以自动配置,编辑/etc/hostname.ce1文件:

racnode3-priv


然后添加相应的掩码和广播地址,在/etc/netmasks文件后面添加:

10.0.0.0        255.255.0.0


另外需要添加默认的网关/etc/defaultrouter:

172.25.13.1


检查nscd进程是否启动:

# ps -ef|grep nscd


   root   162     1   0   3月12 ?           1:13 /usr/sbin/nscd


   root  4498  4418   0 17:33:49 pts/1       0:00 grep nscd


如果没有启动,可以使用/etc/init.d/nscd start来启动。

在两个节点上下面检查软件包是否都已经安装:

# uname -r


5.10


# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWxwfnt


system      SUNWarc   Lint Libraries (usr)


system      SUNWbtool CCS tools bundled with SunOS


system      SUNWhea   SunOS Header Files


system      SUNWi1of  ISO-8859-1 (Latin-1) Optional Fonts


system      SUNWlibC  Sun Workshop Compilers Bundled libC


system      SUNWlibm  Math & Microtasking Library Headers & Lint Files (Usr)


system      SUNWlibms Math & Microtasking Libraries (Usr)


system      SUNWsprot Solaris Bundled tools


system      SUNWtoo   Programming Tools


system      SUNWxwfnt X Window System platform. required fonts


编辑/etc/system,设置核心参数:

set noexec_user_stack=1


set semsys:seminfo_semmni=100


set semsys:seminfo_semmns=1024


set semsys:seminfo_semmsl=256


set semsys:seminfo_semvmx=32767


set shmsys:shminfo_shmmax=21474836479


set shmsys:shminfo_shmmin=1


set shmsys:shminfo_shmmni=100


set shmsys:shminfo_shmseg=10


检查UDP协议配置:

# ndd /dev/udp udp_xmit_hiwat


57344


# ndd /dev/udp udp_recv_hiwat


57344


这个值已经很接近Oracle的推荐值了,这里就不修改了。

下面重启系统,安装的准备工作到此结束。

# init 6


oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html