ORACLE RAC+AIX HACMP到底要几块网卡？

原文：
问一个关于rac的问题

我重做了rac,ibm aix rs6000,做好后应用正常，oracle升级到了9205，在客户端测试也能够实现透明fail over，load balance等功能,但是每天产生很多错误日志
/apps/oracle/product/9.2.0/admin/m85/bdump/m852_ora_975000.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /apps/oracle/product/9.2.0
System name: AIX
Node name:    ecsvr2
Release:       1
Version:       5
Machine:       000FFF6F4C00
Instance name: m852
Redo thread mounted by this instance: 2
Oracle process number: 0
975000

Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
m85-2:/apps/oracle/product/9.2.0/admin/m85/bdump
看着好像只起了一个节点，实际上两个节点都正常，谁能帮忙告诉我这是哪个地方检测时出了问题,os?oracle?怎么能去掉?谢谢

hacmp 的拓扑结构print 一份出来看看。

Cluster Description of Cluster ec_cluster
Cluster ID: 6599
There were 2 networks defined : ipnet, nipnet
There are 2 nodes in this cluster.

NODE ecsvr1:
      This node has 2 service interface(s):

      Service Interface ecsvr1:
            IP address:    10.98.110.145
            Hardware Address:
            Network:       ipnet
            Attribute:    public
            Aliased Address?:    False

      Service Interface ecsvr1 has no boot interfaces.
      Service Interface ecsvr1 has 1 standby interfaces.
            Standby Interface 1: ecsvr1i
            IP address:    10.98.111.1
            Network:       ipnet
            Attribute:    public


      Service Interface ecsvr1rs:
            IP address:    /dev/tty0
            Hardware Address:
            Network:       nipnet
            Attribute:    serial
            Aliased Address?:    False

      Service Interface ecsvr1rs has no boot interfaces.
      Service Interface ecsvr1rs has no standby interfaces.

NODE ecsvr2:
      This node has 2 service interface(s):

      Service Interface ecsvr2:
            IP address:    10.98.110.146
            Hardware Address:
               Network:       ipnet
            Attribute:    public
            Aliased Address?:    False

      Service Interface ecsvr2 has no boot interfaces.
      Service Interface ecsvr2 has 1 standby interfaces.
            Standby Interface 1: ecsvr2i
            IP address:    10.98.111.2
            Network:       ipnet
            Attribute:    public


      Service Interface ecsvr2rs:
            IP address:    /dev/tty0
            Hardware Address:
            Network:       nipnet
            Attribute:    serial
            Aliased Address?:    False

      Service Interface ecsvr2rs has no boot interfaces.
      Service Interface ecsvr2rs has no standby interfaces.




Breakdown of network connections:

Connections to network ipnet
      Node ecsvr1 is connected to network ipnet by these interfaces:
            ecsvr1
            ecsvr1i

      Node ecsvr2 is connected to network ipnet by these interfaces:
            ecsvr2
            ecsvr2i


Connections to network nipnet
      Node ecsvr1 is connected to network nipnet by these interfaces:
            ecsvr1rs
            Node ecsvr2 is connected to network nipnet by these interfaces:
            ecsvr2rs

hi
你们的rac 设计有问题，拿公网网卡作为cache fusion的网卡啊！
rac 至少3个网卡，一个Private Service的网卡作为cache fusion的啊！

呵呵，我们原来刚刚实施完就出了这个问题，我首先再metalink上提出了，后来又打oracle电话咨询，他们说需要一个私有网络，既private。但是后来我问了ibm，他们说他们里边可以设置，但是他们没有用过，最后有一个ibm工程师实施过，说需要三块。service，standby，private各一块。tnf需要首先检测private，如果没有就用service。但是他会不断的再日志中提示你。还好，我们当时弄了三块网卡，有一快主板上的没有用正好用上了。现在就没有问题了.

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

dong_jh

小富即安

论坛徽章:: 0

3楼 [报告]

发表于 2004-10-09 21:50 |只看该作者

ORACLE RAC+AIX HACMP到底要几块网卡？

怎么要3块网卡了？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

dong_jh

小富即安

论坛徽章:: 0

4楼 [报告]

发表于 2004-10-09 22:11 |只看该作者

ORACLE RAC+AIX HACMP到底要几块网卡？

以下是ORACLE的解释，谁能告诉我一下到底该如何配置RAC的HACMP

he information in this article applies to:
Oracle Server - Enterprise Edition - Version: 8.1 to 9.2.0
AIX5L Based Systems (64-bit)
AIX Based Systems (32-bit)
AIX 4.3 Based Systems (64-bit)

Symptoms
1) The alert-log contains the following messages are created on AIX/HACMP for OPS and RAC:

Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.

2) Tracefiles are created with the same message.

3) No network errors are visible at the OS

4) oradebug ipc shows just one network being available to Oracle
Cause
A) The cluster configuration just had two networks defined:

# usr/sbin/cluster/utilities/cllsif -S
db1tty service dbserial rs232 serial db1 /dev/tty1
db1 service gbether ether public db1 10.200.15.10 en6
db2tty service dbserial rs232 serial db2 /dev/tty1
db2 service gbether ether public db2 10.200.15.12 en6

You can see all interfaces in the cluster, one serial network for HACMP per node and a public interface per node.
The serial interface will not be used by Oracle, so just one network is left to be used.

B) The system is incorrectly configured
typically you see just one network in 'oradebug ipc' tracefiles

C) Interface/adapter is defined as standby
That is a setup where HACMP can do the failover
Fix
For A)
1) You may ignore the problem if the cluster is just for testing or development
Make sure to delete unused tracefiles that contain this message to avoid filling a disk
2) If the cluster is used for production add another network, which is setup as 'private' network.
The private network will be used by Oracle as interconnect for RAC (or OPS).

For B)
Make sure the cluster is correctly configured at the HACMP level

For C)
Oracle can not use 'standby' adapters. If you want to avoid that error in the alert-file and the traces then change the characteristics of the adapter from 'standby' to 'service'
References
<BUG:1941206>; - Alert Log Flooded By Messages Since Upgrading To 8.1.7.2
<BUG:3000985>; - Lot Of Trace Files Generated With Disabling Tnff Message