My Oracle Support Banner

Transparent Application Failover (TAF) Is Not Successful For SQL Developer Connections On Node Failover (Doc ID 2754268.1)

Last updated on FEBRUARY 24, 2021

Applies to:

Oracle SQL Developer - Version 20.2 and later
Information in this document applies to any platform.

Symptoms

You have two Node RAC setup with Transparent Application Failover (TAF) implemented. You have SQL Developer, SQLcl , SQL*Plus session connected to same database.

On triggering failover, SQL Developer does not fail over and throws message as:

"Your database connection has been reset"

Whereas SQLcl and SQL*Plus both show failover has succeeded.

Changes

 TAF is being tested with two Node RAC.

Here are detailed steps to set up testcase.

1.Ensure to have two node RAC database.
2.Start SQL Developer and configure for TAF. Refer to:
               How to Setup SQL Developer to support Transparent Application Failover (TAF) <Doc ID 1389747.1>

3. Ensure to have OCI drivers configured. Refer to:
               How To Integrate the Oracle Client and OCI Thick Drivers with SQL Developer <Doc ID 2121278.1>

4. Start Session with SQL Developer and Open up worksheet. Verify the node to which it connects.

It shows ""Your database connection has been reset".

Query returns as
PROGRAM         SID          FAILOVER_TYPE      FAILOVER_METHOD   FAILED_OVER
------------       ---------- -------------            ---------------            ------------
sqldevxxx          xxx         SELECT                   BASIC                        NO

Similar steps when performed from SQLcl or SQL*Plus returs

PROGRAM        SID        FAILOVER_TYPE       FAILOVER_METHOD     FAILED_OVER
------------     -------     -------------              ---------------            ------------
sqldevxxx         xxx        SELECT                    BASIC                          YES

Cause

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
Symptoms
Changes
Cause
Solution
References


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