Re: RAC Configuration - Websphere Configuration

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 1 Apr 2008 20:36:55 -0700 (PDT)
Message-ID: <771958.25157.qm@web51307.mail.re2.yahoo.com>

Alex

I checked and found that it is using Server-side Load balancing. Can you please provide your expertise on the following.

If I set the Load Balance =off on Websphere level

• Service pspsrv is meant to run on 3 node
  -> Is the connection will go to all 5 nodes even pspsrv is supposed to go for three node. I had Servder Side Load balancing on and both Local and Remote Listener is defined.
  

TIA
Sanjay

• Original Message ---- From: Alex Gorbachev <ag_at_oracloid.com> To: smishra_97_at_yahoo.com Cc: oracle-l_at_freelists.org Sent: Tuesday, April 1, 2008 5:04:15 PM Subject: Re: RAC Configuration - Websphere Configuration

Sanjay,

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}" ?

Alex

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))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=pspsrv)))  

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  

TIA
Sanjay

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 01 2008 - 22:36:55 CDT