Entries from TNSNAMES.ORA not Displayed in TNS Connections

(Doc ID 432790.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle SQL Developer - Version 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