荆棘载途 RAC安装之NFS篇
这两天在NFS上配置一套RAC玩，实在没有好的机器就是三台PC，内存2G，每个PC还单块物理网卡，不过最终安装成功。下面记录安装过程中的一些小问题。
CENTOS5.8 X64 + ORACLE GRID /DATABASE 11203
虚拟一块物理网卡做private network,一台机器做NFS SERVER，两台PC分别为两个节点，两节点ORACLE_HOME是shared 模式（Oracle recommends local home），shared模式就是一套共享的ORACLE_HOME，占用空间小，看到一人说曾经做过安装6nodes 只花半小时，就是这种模式。
安装细节另参考其它站点。（oracle-base.com上一篇很好）
安装成功后如下。
[root@rac1 ~]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:24:1D:31:CC:75
inet addr:192.168.168.33 Bcast:192.168.168.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:24124544 errors:0 dropped:0 overruns:0 frame:0
TX packets:28754493 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:7668946830 (7.1 GiB) TX bytes:19450598151 (18.1 GiB)
Interrupt:233 Base address:0xe000
eth0:0 Link encap:Ethernet HWaddr 00:24:1D:31:CC:75
inet addr:192.168.8.33 Bcast:192.168.8.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:233 Base address:0xe000
eth0:1 Link encap:Ethernet HWaddr 00:24:1D:31:CC:75
inet addr:169.254.82.195 Bcast:169.254.255.255 Mask:255.255.0.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:233 Base address:0xe000
eth0:2 Link encap:Ethernet HWaddr 00:24:1D:31:CC:75
inet addr:192.168.168.233 Bcast:192.168.168.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:233 Base address:0xe000
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:77044 errors:0 dropped:0 overruns:0 frame:0
TX packets:77044 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:31594833 (30.1 MiB) TX bytes:31594833 (30.1 MiB)
[root@rac1 ~]#
[root@rac1 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# 80 NFS SERVER
192.168.168.80 www.test.com test.com tel.test.com
192.168.168.33 rac1.localdomain rac1
192.168.168.34 rac2.localdomain rac2
192.168.8.33 rac1-priv.localdomain rac1-priv
192.168.8.34 rac2-priv.localdomain rac2-priv
192.168.168.233 rac1-vip.localdomain rac1-vip
192.168.168.234 rac2-vip.localdomain rac2-vip
问题一，安装GRID过程中root.sh遇PKI-02003，PKI-02002，
解决：
$ORACLE_HOME=/u01/app/11.2.0/grid
1./u01/app/11.2.0/grid/root.sh — on node2 （不确定是否是关键）
Configure Oracle Grid Infrastructure for a Cluster … succeeded
2./u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose — on node1
3./u01/app/11.2.0/grid/root.sh –try again on node1
当时只是为了测试NODE2是不是也出现次问题，所以就先在node2上运行，所以也就引起了问题3.（ran root.sh in wrong node order）
问题二，DBCA遇
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux Error: 37: No locks available
问题是NFS的一致性修改问题，只会出现在NFS上，解决方法是在NFS服务器端和客户端都启动NFS Lock服务
对NFS lock 的解释
The Network File System (NFS) is a client/server protocol that allows a directory hierarchy located on an NFS server to be mounted on one or more NFS clients. Once this is
done, the NFS client can transparently access the NFS server files. The NFS server-side daemons arbitrate simultaneous access by multiple clients. Entire files, or individual
regions of files, can be locked by a client to avoid race conditions caused by concurrent modification or by viewing partial updates.
[root@rac1 ~]# /etc/init.d/nfslock start 启动 NFS statd： [确定] [root@rac1 ~]# chkconfig --list nfslock nfslock 0:关闭 1:关闭 2:关闭 3:关闭 4:关闭 5:关闭 6:关闭 [root@rac1 ~]# chkconfig --level 35 nfslock on [root@rac1 ~]# chkconfig --list nfslock nfslock 0:关闭 1:关闭 2:关闭 3:启用 4:关闭 5:启用 6:关闭
DBCA建库成功后检查一下RAC状态。
[oracle@rac1 database]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@rac1 database]$ srvctl status nodeapps
VIP rac1-vip 已启用
VIP rac1-vip 正在节点上运行: rac1
VIP rac2-vip 已启用
VIP rac2-vip 正在节点上运行: rac2
网络已启用
网络正在节点上运行: rac2
网络正在节点上运行: rac1
GSD 已禁用
GSD 没有运行的节点: rac2
GSD 没有运行的节点: rac1
ONS 已启用
ONS 守护程序正在节点上运行:rac2
ONS 守护程序正在节点上运行:rac1
[oracle@rac1 database]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2 Instance Shutdown
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.cvu
1 ONLINE ONLINE rac2
ora.oc4j
1 ONLINE ONLINE rac2
ora.rac.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
[oracle@rac1 database]$ srvctl status database -d rac
实例 rac2 正在节点 rac1 上运行
实例 rac1 正在节点 rac2 上运行
问题三，实例与节点顺序是交叉的。实例2在节点1上。
解决方法
[oracle@rac1 ~]$ srvctl stop database -d rac
[oracle@rac1 ~]$ srvctl modify instance -d rac -i rac1 -n rac1
PRCD-1069 : 无法修改数据库 rac 的节点 rac1 上的实例 rac1
PRCD-1051 : 无法将实例添加到数据库 rac
PRCD-1023 : 实例已添加到数据库rac的节点rac1
[oracle@rac1 ~]$ srvctl remove instance -d rac -i rac1
是否从数据库 rac 中删除实例? (y/[n]) yes
PRKO-2007 : 实例名无效: rac1
[oracle@rac1 ~]$ srvctl modify instance -d rac -i rac1 -n rac1
PRKO-3032 : 无效的实例名: rac1
[oracle@rac1 ~]$ srvctl modify instance -d rac -i rac2 -n rac2
[oracle@rac1 ~]$ srvctl add instance -d rac -i rac1 -n rac1
[oracle@rac1 ~]$ srvctl status database -d rac
实例 rac1 没有在 rac1 节点上运行
实例 rac2 没有在 rac2 节点上运行
[oracle@rac1 ~]$ srvctl start database -d rac
[oracle@rac1 ~]$ srvctl status database -d rac
实例 rac1 正在节点 rac1 上运行
实例 rac2 正在节点 rac2 上运行
SQL> select inst_id,instance_name,status,database_status from gv$instance;
INST_ID INSTANCE_NAME STATUS DATABASE_STATUS
---------- ---------------- ------------ -----------------
1 rac1 OPEN ACTIVE
2 rac2 OPEN ACTIVE
总结：
如果不是太无聊不要让费保贵的时间。
微信扫一扫，打赏作者吧～上一篇： 力挺一下sqluldr
对不起，这篇文章暂时关闭评论。