Entries from TNSNAMES.ORA not Displayed in TNS Connections
Last updated on AUGUST 18, 2017
Applies to:Oracle SQL Developer - Version 126.96.36.199 to 4.0 [Release 1.1 to 4]
Information in this document applies to any platform.
This problem can occur on any platform.
When using TNSNAMES.ORA file for a new TNS connection in SQL Developer, not all entries from the file tnsnames.ora are displayed. Only first X entries are displayed, and the rest are ignored.
Same TNSNAMES.ORA file works fine in SQLPLUS and all entries are valid.
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