Re: RAC Configuration - Websphere Configuration

From: Alex Gorbachev <>
Date: Tue, 1 Apr 2008 17:04:15 -0400
Message-Id: <>


LOAD_BALANCE has only effect on how client chooses an address from the list you provided in your connection string. In your case it makes no difference as there is only one IP.

Now, depending on configuration of the server side connection load balancing and whether you have remote listener registration, session might still go to any of the instances providing this service.

Can you provide the output of "lsnrctl service {listener_name}" ?


On 1-Apr-08, at 3:48 PM, Sanjay Mishra wrote:

> Hi
> I had 5 node RAC and it is configured with pspsrv service which is
> Preferred for all Nodes
> If I am specifying only 1 node in the Websphere configuration but
> Load balance is on, and service_name is preferred for all nodes as
> show below : Question is that Is the following setting will go to
> only one Node like psvr1-vip server or it will go to any of the 5
> node as LOAD_BALANCE is on and Service is preferred for all nodes
> jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on)
> (ADDRESS=(PROTOCOL=TCP)(HOST=psvr1-vip)(PORT=1521))
> If I change the LOAD_BALANCE=OFF
> What will be the effect of the change. Is it goes now to only psvr1-
> vip or is that goes to all nodes
> Sanjay
> You rock. That's why Blockbuster's offering you one month of
> Blockbuster Total Access, No Cost.

Received on Tue Apr 01 2008 - 16:04:15 CDT

Original text of this message