Starting with 10g R2, TAF METHOD=BASIC is defined server-side, so what
you have on your client won't matter anyway (server settings override
client ones). Check out DBA_SERVICES and DBMS_SERVICE in the database.
The entry below doesn't define the required TAF parameters like
FAILOVER=ON, TYPE=SESSION, METHOD=BASIC. So, if you're using pre-10.2
and this entry, you won't have TAF enabled either.
I know I seem like a broken record, but all this stuff is covered in
Jeremy's (excellent) whitepaper at
http://www.ardentperf.com/pub/services-schneider07.pdf
Dan
Bradd Piontek wrote:
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@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)
)
)
--
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/
--
//www.freelists.org/webpage/oracle-l
|