Transparent Application Continuity(TAC) Is Not Successful For SQL Developer Connections On Node Failover (Doc ID 2859802.1)

Last updated on FEBRUARY 16, 2023

Applies to:

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

Symptoms

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

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

Your database connection has been reset. Any pending transactions or sessions state has been lost.

But checking v$session with below query shows failover has not succeeded for SQL Developer.

select program,sid,failover_type,failover_method,failed_over from v$session where sid=sys_context('userenv', 'sid');

PROGRAM SID FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER
----------------------------------------------------------------------------------
SQL Developer <SID> NONE NONE NO

PROGRAM SID FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER
--------------------------------------------------------------------------------------
sqlplus@<NODE_NAME> (TNS V1-V3) <SID> AUTO BASIC YES

Whereas SQL*Plus shows failover has succeeded.