Re: TAF and JDBC connections

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: oracledbaquestions@xxxxxxxxx
  • Date: Thu, 10 Jul 2008 10:40:05 -0500

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@xxxxxxxxx>
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.'

Other related posts: