Re: Attack to a specific node in a RAC (jdbc connection)

From: Oliver <ofabelo_at_gmail.com>
Date: Wed, 10 Mar 2010 13:57:40 +0000
Message-ID: <fdd39f611003100557i36418b0fj9efca4800da3ec75_at_mail.gmail.com>

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

> 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_at_gmail.com> 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:_at_
>> (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...
>>
>
>

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

Received on Wed Mar 10 2010 - 07:57:40 CST