SQL Developer Shows "NONE" For Both FAILOVER_METHOD And FAILOVER_TYPE In V$session

(Doc ID 1501397.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

Trying to create an advanced connection with a custom JDBC URL for HA (High Availability) testing.

* "New / Select Database Connection" with
* Connection type = "Advanced"
* Role="Default"
* Custom JDBC URL (on one single line) :

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=<FULLY QUALIFIED HOST>)(PORT=1522))
(ADDRESS=(PROTOCOL=TCP)(HOST=<FULLY QUALIFIED HOST>)(PORT=1522)))
(CONNECT_DATA=(SERVICE_NAME=SRVC_CLOUD12_HA)(SERVER=DEDICATED))(FAILOVER_MODE=(TYPE=select)(METHOD=basic)))

Getting the following in SQL Developer:
When querying from v$session, the connection does show the proper value for the  SERVICE_NAME but NOT for the FAILOVER_METHOD and FAILOVER_TYPE.
(those values are returned 'NONE' instead of 'SELECT' and 'BASIC').

That is, select SERVICE_NAME, FAILOVER_METHOD, FAILOVER_TYPE from v$session;
Gives "NONE" for both FAILOVER_METHOD and  FAILOVER_TYPE in SQL Worksheet.

However, the same query gives correct output in SQLPLUS:

SERVICE_NAME             FAILOVER_METHOD    FAILOVER_TYPE
---------------------------------------------------------------------------------------------
<SERVICENAME>           BASIC                     SELECT


Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms