SQL Developer Changes Connection Type Details After Password Change
(Doc ID 2893047.1)
Last updated on SEPTEMBER 07, 2022
Applies to:
Oracle SQL Developer - Version 22.2 and laterInformation in this document applies to any platform.
Symptoms
SQL Developer changes Connection Type Details after password change
Users are seeing their connection information change from Connection Type: TNS > Details: Network Alias: OUR_NETWORK_ALIAS to a Connect Identifier, which appears to be copied from the tnsnames.ora somehow. This is causing an issue because it triggers errors with JDBC drivers, etc.
The expectation is that when a connection configuration option is set it will stay set that way rather than changing for unknown reasons.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select a connection that has TNS connection type and Network alias defined
2. From the context menu, select Reset Password option
3. Change the password
4. Verify the connection options and it will show TNS Connection Type, but specify a "Connection Identifier" rather that the "Network Alias"
This was reported in SQL Developer 21.4, but also reproduces in latest 22.2
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 |
| References |