Re: TAF and JDBC connections

Cant you just configure the service to be preferred on nodes 3 and 4?

On Thu, Jul 10, 2008 at 10:12 AM, Dba DBA <oracledbaquestions_at_gmail.com> wrote:

> I have developers connecting to my RAC database with jdbc. I want them to
> use nodes 3 and 4. I have a TAF tnsnames set up for them as follows:
> This is the tnsnames on the server. However, JDBC does not use tnsnames.
> How do I get them to take advantage of this ?
> I can use this locally on my RAC boxes.
>
> so what do I do with jdbc guys?
>
> JAVAGUYS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = node4-vip)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = JAVAGUYS)
> )
> )
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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