topic Re: ServiceGuard and ext. for RAC in Operating System - HP-UX

ServiceGuard and ext. for RAC

Christian Lafleur — Tue, 15 Feb 2005 15:21:46 GMT

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

Re: ServiceGuard and ext. for RAC

Uday_S_Ankolekar — Tue, 15 Feb 2005 15:33:37 GMT

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..

Re: ServiceGuard and ext. for RAC

Julio Yamawaki — Tue, 15 Feb 2005 17:08:51 GMT

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

Re: ServiceGuard and ext. for RAC

Christian Lafleur — Wed, 16 Feb 2005 09:07:12 GMT

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

Re: ServiceGuard and ext. for RAC

Julio Yamawaki — Wed, 16 Feb 2005 16:28:14 GMT

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,

Re: ServiceGuard and ext. for RAC

Christian Lafleur — Fri, 25 Feb 2005 15:26:15 GMT

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 ?

Re: ServiceGuard and ext. for RAC

Christian Lafleur — Fri, 11 Mar 2005 10:10:40 GMT