欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Oracle RAC 中vip网关引起错误的解决

程序员文章站 2024-02-15 22:44:22
...

在虚拟机上刚装完Oracle RAC,重新启动系统后。重新启动了oracle所有的服务,一开始所有的服务都正常。 但是过了一会,节点2的vi

在虚拟机上刚装完Oracle RAC,重新启动系统后。重新启动了oracle所有的服务,一开始所有的服务都正常。
但是过了一会,节点2的vip又再次飘移到了节点1上,并且节点2的监听服务也OFFLINE了。反复启动了几次都是同样的效果的。
[root@node2 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE node2
ora....b1.inst application ONLINE ONLINE node1
ora....b2.inst application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE OFFLINE
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node1

节点2上的监听没有起,并且节点2的vip起在节点1上。之前监听器是在节点1上建立的一个集群监听。
尝试将节点2的vip停止下来再重新启动,发现只能在节点1上启动。
/u01/app/oracle/crs/log/node2/crsd/crsd.log的日志报错:
2014-11-03 13:41:33.386: [ CRSRES][2659736480]0Attempting to start `ora.node2.vip` on member `node2`
2014-11-03 13:41:46.720: [ CRSAPP][2659736480]0StartResource error for ora.rac10g2.vip error code = 1
2014-11-03 13:41:51.405: [ CRSRES][2659736480]0Start of `ora.node2.vip` on member `node2` failed.
2014-11-03 13:41:51.532: [ CRSRES][2659736480]0Attempting to start `ora.node2.vip` on member `node1`
2014-11-03 13:41:55.388: [ CRSRES][2659736480]0Start of `ora.node2.vip` on member `node1` succeeded.
将所有服务都停止,然后一一重启就好了。
[root@node2 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE node2
ora....b1.inst application ONLINE ONLINE node1
ora....b2.inst application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2

但是过了一会,节点2的vip又再次飘移到了节点1上,并且节点2的监听服务也OFFLINE了。

在/u01/app/oracle/crs/log/node2/racg下的ora.node2.vip.log日志中发现如下报错:


[root@node2 bin]# cat /u01/app/oracle/product/crs/log/node2/racg/ora.node2.vip.log
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2014-11-03 09:58:20.864: [ RACG][3067430592] [8114][3067430592][ora.node2.vip]: Interface eth0 checked failed (host=node2)
Invalid parameters, or failed to bring up VIP (host=node2)

2014-11-03 09:58:20.864: [ RACG][3067430592] [8114][3067430592][ora.node2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/oracle/product/crs