yuantong

windows 2k3 + 10G RAC 安装的一些注意事项

hosts的配置

127.0.0.1 localhost.com localhost
# Public
1x1.33.14.3 w2k3rac1.com w2k3rac1
1x1.33.14.4 w2k3rac2.com w2k3rac2
#Private
10.255.235.13 w2k3rac1-priv.com w2k3rac1-priv
10.255.235.14 w2k3rac2-priv.com w2k3rac2-priv
#Virtual
1x1.33.14.7 w2k3rac1-vip.com w2k3rac1-vip
1x1.33.14.11 w2k3rac2-vip.com w2k3rac2-vip

运行
runcluvfy.bat stage -pre crsinst -n rac01,rac02 -verbose
检查安装条件
如果报
找不到用于 VIP 的合适接口集。
有两个原因:
public 网卡不能是 10*,192*,172*; public网卡一定要设置一个gateway

要注意的地方(两台机都要做):
1. 查看是否有多余的网卡,有时vmware会冒出另一个网卡.
set devmgr_show_nonpresent_devices=12
set devmgr_show_nonpresent_devices=1
devmgmt.msc

用view--->show hidden devices 查看

2. 打开网络连接页面,在高级设置那将public 网卡设为第一个.

3.在cmd下 ,打入 diskpart
然后输入 automount enable
(注意在这里是查看共享磁盘的,你可以在两台机上都用list volume查看一下结果是否一致,要保持一致)

4. ocr 和 voting 磁盘一定要放两份,否则会遇到
安装crs时，安装到配置助手这一步时，就不能进行下去了。
这是因为bug:5027463

5.时间同步

升级10.2.0.4 的crs 要注意
安装完后,然后停止所有的oracle 服务,然后下载一个listdlls.exe 查看ons.exe 的pid
然后用
ntsd -c q -p pid 来停止ons.exe
再运行
C:oracleproduct10.2.0crsinstallpatch102.bat
否则这个运行不了的.

RAC运行在Windows平台,并且用ASM来管理存储, 在某一节点运行ASMCMD会遇到以下错误
===========================
ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)
===========================
solution
1.设定环境变量
set oracle_home=C:oracleproduct10.2.0db_1
set oracle_sid=+AMS2

2.将当前OS帐号加入到ORA_DBA这个组中.通常在非运行安装程序节点中,没有将OS帐号加入到ORA_DBA组中.

进行ASMCMD命令行
C:>%oracle_home%binasmcmd

srvctl add service -d rac -s write -r rac1 -a rac2
srvctl add service -d rac -s read -r rac2 -a rac1

RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w2k3rac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
)

appread =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w2k3rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = w2k3rac2-vip)(PORT = 1521))
(LOAD_BALANCE = NO)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = read)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
(BACKUP = rac1)
)
))

应用服务器连接串 写成这样试下

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE1_VIP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE2_VIP)(PORT = 1521))
(SOURCE_ROUTE = yes) ***这个的作用是让其按照上面列出的地址一个一个连接*********
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACDB)
)
)