Re: TAF and JDBC connections
Date: Thu, 10 Jul 2008 10:32:49 -0500
Take the entry from (DESCRIPTION to the end and taek all whitespace and carriage returns out. Then use that as your JDBC URL
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)
-- Bradd Piontek Twitter: http://www.twitter.com/piontekdd Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd Last.fm: http://www.last.fm/user/piontekdd/ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 10 2008 - 10:32:49 CDT