Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Not all entries from tnsnames.ora are shown in LOV

KayKMar 13 2025

Hi,
i'm using SQL Developer 23.1.1, but i'm facing this issue in past too.

The directory of my tnsnames.ora is saved under preferences. TNS_ADMIN is set to this directory.
My tnsnames.ora has over 700 lines and the size is 100k.

If i try to add a new connection via connection TNS not all my databases where show in the LOV.

If i add a new entry in the tnsnames.ora at line 200, i can see it.
If i add the same new entry at line 210+ i can't see it.

Is there any limitation of lines or size or formatting of the tnsnames.ora that prevent to show me all entries ?

kind regards
Kay

Comments

Post Details

Added on Mar 13 2025
1 comment
31 views