ServiceGuard and ext. for RAC

[Christian Lafleur]

Hi,
2 server hpux 11.23 using SG with ext. for RAC. No package for RAC...

3 nic on each server (1 crossover and 2 pub) :
******************************************
NODE_NAME ppora1
NETWORK_INTERFACE lan0
HEARTBEAT_IP 1.1.1.1
NETWORK_INTERFACE lan1
HEARTBEAT_IP 192.168.220.10
NETWORK_INTERFACE lan2
FIRST_CLUSTER_LOCK_PV /dev/dsk/c5t0d4

NODE_NAME ppora2
NETWORK_INTERFACE lan0
HEARTBEAT_IP 1.1.1.2
NETWORK_INTERFACE lan1
HEARTBEAT_IP 192.168.220.11
NETWORK_INTERFACE lan2
FIRST_CLUSTER_LOCK_PV /dev/dsk/c5t0d4
******************************************

The cluster running well in normal time (when 2 node are up...) but if i unplug lan1 and lan2 the server is running very very very slow.

Also i cannot connect on any node using oracle instances...

do i need to specify cluster_interconnects parameter for node private network (heartbeat) ?

Thanks

[Uday_S_Ankolekar]

Check the speed settings on each NIC. Also check how it reaches to next node when you disconnect LAN1 or LAN2 by ping or traceroute.
Check the same for heartbeats.

-USA..

[Julio Yamawaki]

Hi,

If you don´t specify CLUSTER_INTERCONNECTS init.ora parameter, Oracle RAC will use your first IP address.
In your case, if you want to use lan0 to interconnect the nodes, put in your init.ora:
ppora1: CLUSTER_INTERCONNECTS="1.1.1.1"
ppora2: CLUSTER_INTERCONNECTS="1.1.1.2"
Also, if this lan0 is not enough to support intercluster traffic, you can speciy more than one address, separated by a :.

Regards

[Christian Lafleur]

i use shared spfile. how i acan specify cluster_interconenct for each node ?

[Julio Yamawaki]

Hi,

You can do in this way:

execute sqlplus, connect as system
> alter system set cluster_interconnects="10.1.1.1" scope=spfile sid=
> alter system set cluster_interconnects="10.1.1.2" scope=spfile sid=

As CLUSTER_INTERCONNECTS is a static parameter, you will have to stop and start the instances.

Regards,

[Christian Lafleur]

same problem with cluster_interconnects.

created metalink with Oracle...
Oracle say that is an SG issue.


can i run custom command on server in case of multiple lan failure ?

[Christian Lafleur]

.