Re: Attack to a specific node in a RAC (jdbc connection)
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: Oliver <ofabelo@xxxxxxxxx>
- Date: Wed, 10 Mar 2010 15:06:17 +0100
load_balance=on means turns on client load balancing which means use any of
entries defined in your tns
so if you want to ensure the first entry is always used just put
load_balance=off
Thanks
On Wed, Mar 10, 2010 at 2:57 PM, Oliver <ofabelo@xxxxxxxxx> wrote:
> Hello,
> I'm sorry for top posting.
> Ok, thank you very much, it works. I see that if I do many connections with
> Toad to my Oracle RAC, with load_balance=on and failover=on, it always
> attack to the first node. Is it normal? I understand that if I put the same
> in the jdbc string (balance on and failover on), it will always attack to
> first node, isn't it? I should delete "balance on" in all entries of jdbc
> connections, isn't it?
> Thanks beforehand.
>
> Cheers...
>
> 2010/3/10 LS Cheng <exriscer@xxxxxxxxx>
>
> If I understand correctly your question you have to put LOAD_BALANCE=OFF
>> and x2 first
>>
>>
>> Thanks
>>
>> --
>> LSC
>>
>>
>>
>> On Wed, Mar 10, 2010 at 2:21 PM, Oliver <ofabelo@xxxxxxxxx> wrote:
>>
>>> Hello,
>>> I have a Oracle RAC, with 2 nodes (Oracle 9i under AIX). Is it possible
>>> that in a jdbc connection (an application under Apache Tomcat) I can choose
>>> the primary server where it may connect? I have in the jdbc connection:
>>>
>>> "jdbc:oracle:thin:@
>>> (DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.xxx.xx.x1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.xxx.xx.x2)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxx)))"
>>>
>>> I have the same in my tnsnames.ora. If I put x2 before than x1, it uses
>>> the x1 again ... I want that it connects to x2 firstly, and if it fails, it
>>> uses x1 ...
>>> I'm sorry for my bad english :-) Thanks beforehand.
>>>
>>> Cheers...
>>>
>>
>>
>
Other related posts:
