My Oracle Support Banner

Master Note for Oracle JDBC High Availability Features (Doc ID 1100024.1)

Last updated on APRIL 07, 2018

Applies to:

JDBC - Version 10.1.0.2 to 12.2.0.0.0 [Release 10.1 to 12c]
Information in this document applies to any platform.
 Scope and Application

Actions

 Master Note for Oracle JDBC High Availability Features

 1. Documentation

 1.1 JDBC Connection String to RAC System

 1.2 Fast Connection Failover

 1.2.1 Fast Connection Failover In Standalone JDBC Applications

 1.2.2 Fast Connection Failover in J2EE Applications

 1.2.2.1 Oracle Containers for J2EE (OC4J)

 1.2.2.2 Oracle Weblogic Server

 

 1.2.2.3 Third Party Application Servers

 1.3 Transparent Application Failover

 2. Best Practices

 3. Troubleshooting

 4. Common Problems

References


Applies to:


JDBC - Version 10.1.0.2 to 12.2 [Release 10.1 to 12.2]
Information in this document applies to any platform.

Details

Applies to:

JDBC - Version 10.x to 12.x
Information in this document applies to any platform.

Purpose

This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes, documentation, and troubleshooting with respect to high-availability features of Oracle JDBC: Fast Connection Failover and Transparent Application Failover (TAF) features.
In addition to the Support Notes below, you can get additional information here: JDBC Discussion Forum.

Scope and Application

This note is intended for developers of Java Database Connectivity (JDBC)-based applications to take advantage of the connection failover facilities.

Actions

Master Note for Oracle JDBC High Availability Features

1. Documentation

1.1 JDBC Connection String to RAC System


The following notes contain information for setting a valid JDBC connection string to a RAC system:

<Document 390923.1> Connection-String For Jdbc Thin-Client In A Data guard-Environment

<Document 414465.1> How to Set JDBC Thin Connection String to RAC Without Referencing Every Node in the Cluster

<Document 391015.1> How to Connect to a RAC Database from a Java Application That Takes a HOST PORT SID Argument

<Document 1081179.1> How to Access a RAC Database configured with SCAN via Java Thin Driver

<Document 1290193.1> Using SCAN With Oracle JDBC 11g Thin Driver

1.2 Fast Connection Failover


Fast Connection Failover offers a driver-independent way for your Java Database Connectivity (JDBC) application to take advantage of the connection failover facilities offered by the Oracle Database.
 With the desupport of Implicit Connection Cache, Oracle recommends you to use this feature with Universal Connection Pool. So, the Fast Connection Failover information has been removed from JDBC 12.1 release.

See Oracle Universal Connection Pool for JDBC Developer's Guide for more information about this feature.


The following documentation provides an overview of Fast Connection Failover, how it works and how to use it, and a comparison between Fast Connection Failover and Transparent Application Failover:

Version 12.1 Universal Connection Pool for JDBC Developer's Guide
Chapter 8: 8 Using Oracle RAC Features
Using Fast Connection Failover
https://docs.oracle.com/database/121/JJUCP/rac.htm#JJUCP08100
Version 11.2 Oracle® Database JDBC Developer's Guide, 11g Release 2 (11.2)
Chapter 27: Fast Connection Failover
http://download.oracle.com/docs/cd/E11882_01/java.112/e10589/fstconfo.htm
Version 11.1 Oracle® Database JDBC Developer's Guide and Reference, 11g Release 1 (11.1)
Chapter 26: Fast Connection Failover
http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/fstconfo.htm#CIHJBFFC
Version 10.2 Oracle® Database JDBC Developer's Guide and Reference 10g Release 2 (10.2)
Chapter 27: Fast Connection Failover
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/fstconfo.htm
Version 10.1

Oracle® Database JDBC Developer's Guide and Reference 10g Release 1 (10.1)
Chapter 8: Fast Connection Failover
http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/fastconnfail.htm



1.2.1 Fast Connection Failover In Standalone JDBC Applications


The following notes contain information for using Fast Connection Failover in standalone JDBC applications:

<Document 386752.1> Step by Step Description for Setting Up FAN And FCF for 10g JDBC

<Document 414199.1> How To Implement (Fast Connection Failover) FCF Using JDBC driver

<Document 364005.1> How To Use JDBC FCF Feature To Detect That a RAC Node Instance Has Been Shutdown

<Document 752595.1> Questions about How ONS and FCF work with JDBC

<Document 566573.1> Fast Connection Failover (FCF) Test Client Using 11g JDBC Driver and 11g RAC Cluster

<Document 433827.1> How to Verify and Test Fast Connection Failover (FCF) Setup from a JDBC Thin 10g Client Against a 10.2.x RAC Cluster

<Document 1064652.1> How to Verify Universal Connection Pool (UCP) / Fast Connection Failover (FCF) Setup


1.2.2 Fast Connection Failover in J2EE Applications

1.2.2.1 Oracle Containers for J2EE (OC4J)

The following note contains information for using Fast Connection Failover in J2EE applications (running within Application Servers):

<Note 388448.1> How to Setup Fast Connection Failover within OAS 10.1.3 OC4J instances


Viewlet showing FCF configuration and functionality in OC4J 10.1.3:
OC4J 10.1.3 Fast Connection Failover Viewlet


The following article gives an overview of the level of support and configuration for both Implicit Connection Caching and Fast Connection Failover in OC4J data sources, in Oracle Application Server 10g 9.0.4.x, 10.1.2, and 10.1.3:
OC4J Data Sources: Implicit Connection Caching and Fast Connection Failover

1.2.2.2 Oracle Weblogic Server


The following documentation provides information on configuring Fast Connection Failover within Oracle Weblogic Server:

Version 10.3.1

Oracle® Fusion Middleware Configuring and Managing JDBC for Oracle WebLogic Server 11g Release 1 (10.3.1)
http://download.oracle.com/docs/cd/E15523_01/web.1111/e13737/oracle_rac.htm#i108447

Version 10.3.3

Oracle® Fusion Middleware Configuring and Managing JDBC for Oracle WebLogic Server 11g Release 1 (10.3.3)
http://download.oracle.com/docs/cd/E14571_01/web.1111/e13737/oracle_rac.htm#i1084473

Version 10.3.6

Oracle® Fusion Middleware Configuring and Managing JDBC for Oracle WebLogic Server 11g Release 1 (10.3.3)
http://docs.oracle.com/cd/E23943_01/web.1111/e13737/fastconnect.htm#sthref115

Version 12.1

Oracle® Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server
E Using Fast Connection Failover with Oracle RAC
https://docs.oracle.com/cd/E24329_01/web.1211/e24367/fastconnect.htm#JDBCA496

 

 



The following White Paper includes the configuration of Oracle JDBC Implicit Connection Cache’s feature of Fast Connection Failover in Oracle Weblogic:
Oracle WebLogic Server 10.3 and Oracle Real Application Clusters (RAC)

1.2.2.3 Third Party Application Servers

The following note discusses the setup of Fast Connection Failover (FCF) within a JBOSS application server:
<Note:738122.1> Does JBOSS Support Fast Connection Failover (FCF) to a 10g RAC cluster?


1.3 Transparent Application Failover


Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. In this case, the active transactions roll back.

The following documentation provides an overview of Transparent Application Failover (TAF), Failover Type Events,TAF Callbacks, and Java TAF Callback Interface:

Version 12.1

Oracle® Database JDBC Developer's Guide 12c Release 1 (12.1)
Chapter 28: Transparent Application Failover
http://docs.oracle.com/cd/E16655_01/java.121/e17657/ocitaf.htm#JJDBC27000

Version 11.2

Oracle® Database JDBC Developer's Guide, 11g Release 2 (11.2)
Chapter 28: Transparent Application Failover
http://download.oracle.com/docs/cd/E11882_01/java.112/e10589/ocitaf.htm#BABGIDEE

Version 11.1

Oracle® Database JDBC Developer's Guide and Reference, 11g Release 1 (11.1)
Chapter 27: Transparent Application Failover
http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/ocitaf.htm#BABGIDEE

Version 10.2

Oracle® Database JDBC Developer's Guide and Reference 10g Release 2 (10.2)
Chapter 28 Transparent Application Failover
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/ocitaf.htm#BABGIDEE

Version 10.1

Oracle® Database JDBC Developer's Guide and Reference 10g Release 1 (10.1)
Chapter 19.2 OCI Driver Transparent Application Failover
http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/oci_func.htm#sthref1723




The following notes contain information about Transparent Application Failover and Oracle JDBC:

<Note.297490.1> Is Transparent Application Failover (TAF) Supported on the JDBC Thin Driver?

<Note.276225.1> JDBC Sample on How to Implement OCI TAF callbacks with DML and PL/SQL

<Note.428515.1> How To Use TAF With Instant Client

<Note:334471.1> Understanding Transparent Application Failover (TAF) and Fast Connection Failover (FCF)


2. Best Practices


This white paper provides Oracle Maximum Availability Architecture (MAA), instructions and best practices for configuring automatic client failover for OCI, OLE DB, and JDBC clients in a Data Guard configuration.

Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 10g Release 2

3. Troubleshooting


The following how-to notes demonstrate a simple java client that shows how to use and verify the Implicit
Connection Cache with Fast Connection Failover (FCF) against a 10g and 11g RAC cluster. It does this through a java demo as well as various debug techniques used to ensure a correct setup exists:

<Note:566573.1> Fast Connection Failover (FCF) Test Client Using 11g JDBC Driver and 11g RAC Cluster

<Note.433827.1> How To Verify And Test Fast Connection Failover (FCF) Setup From a JDBC Thin Client Against a 10.2.x RAC Cluster


This demo shows how to validate the UCP JDBC connection pool to confirm your FCF setup:

<Note.1064652.1> How to Verify Universal Connection Pool (UCP) / Fast Connection Failover (FCF) Setup

4. Common Problems


The following notes discuss some common problems found on using High Availability features in Oracle JDBC:

<Note.468068.1> Intermittent TNS-01153 and NL-00305 Using a JDBC/Thin Connection to a 3-Node RAC Database

<Note.460426.1> Only One ONS Registration Is Effective When Calling setONSConfiguration() Method

<Note.371822.1> Fan Implicitcache Does Not Support Minlimit After Instance Crash

<Note.563213.1> OracleAS 10.1.3 OPMN Intermittently Spins CPU After Enabling Fast Connection Failover (FCF)

<Note.399096.1> How to Choose the Oracle JDBC Version that is Compatible with a 10.1.X RAC Cluster to Enable Fast Connection Failover (FCF)

<Note.406626.1> Hang When Using 10.2 JDBC Driver FCF Feature Against 10.1 Database RAC Cluster

<Note.555714.1> java.lang.NoSuchMethodError oracle.ons.ONS.buildServerList With FCF And JDBC Configuration (ONS)

<Note.473325.1> Exception "Missing class oracle.ons.ONSException" When Using Fast Connection Failover

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Applies to:
 Purpose
 Scope and Application
Actions
 Master Note for Oracle JDBC High Availability Features
 1. Documentation
 1.1 JDBC Connection String to RAC System
 1.2 Fast Connection Failover
 1.2.1 Fast Connection Failover In Standalone JDBC Applications
 1.2.2 Fast Connection Failover in J2EE Applications
 1.2.2.1 Oracle Containers for J2EE (OC4J)
 1.2.2.2 Oracle Weblogic Server
 
 1.2.2.3 Third Party Application Servers
 1.3 Transparent Application Failover
 2. Best Practices
 3. Troubleshooting
 4. Common Problems
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.