Re: RAC failover and JDBC string

From: Dan Norris <dannorris_at_dannorris.com>
Date: Tue, 19 Aug 2008 10:23:19 -0500
Message-ID: <48AAE567.6060000@dannorris.com>

I didn't try it in production, but I did create an experiment to validate the functionality and it worked as advertised. As you mentioned, it doesn't provide SELECT failover, but it is an excellent set of features and especially useful for those using connection pools.

Dan

Roman Podshivalov wrote:

To refresh my memory, I did some research too. Starting from 10.2 thin JDBC driver could utilize FAN events and perform Fast Connection Failover according to the documentation: http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/hafeats.htm#BABFCFHA

It's not TAF, and reading sessions will be disconnected, but other features look very similar, especially for app server/connection pool/JDBC type of setups . I personally never tested or tried this feature. Any early adopters ?

 

thanks

--romas

 

On 8/19/08, Dan Norris <dannorris@dannorris.com> wrote:

You're not mistaken (at least according to the docs):

10.2:
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/ocitaf.htm#BABGIDEE
11.1:
http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/ocitaf.htm#BABGIDEE
ML:
297490.1 (which reprints the 10.2 docs)

Roman Podshivalov wrote:

Hi,

 

If I'm not mistaken to get an advantage of TAF with JDBC you need to use JDBC thick (OCI) driver and connection string should be either properly configured TNS alias or fully qualified TNS entry (TAF aware) specified in JDBC connection string. Thin driver wasn't TAF aware last time I've checked, but it could have changed since then.

 

--romas

 

On 8/14/08, John Dunn <JDunn@sefas.com> wrote:

I need to understand how RAC handles hostnames in JDBC connection strings.

 

If I have an application that uses a JDBC connection string(that contains a hostname) to connect to the Oracle database, what happens if there is a failover to another server in the RAC cluster?

 

 

 

 

 

-- http://www.freelists.org/webpage/oracle-l Received on Tue Aug 19 2008 - 10:23:19 CDT