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

Last updated on JULY 04, 2022

Applies to:

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:

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

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