简单描述一下,在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