SQL Developer Shows "NONE" For Both FAILOVER_METHOD And FAILOVER_TYPE In V$session
(Doc ID 1501397.1)
Last updated on JANUARY 14, 2020
Applies to:
Oracle SQL Developer - Version 3.0 and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A 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=<SERVICE_NAME>)(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
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 |
| Cause |
| Solution |