I have a large TNSNames.ora file with dozens of entries. When trying to create a new connection:
Change Connection Type to TNS
Use pull-down on Network Alias
Start typing your TNSName
The first letter you type will bring you to all entries starting with that letter. The next letter you type will bring you to all entries starting with that letter. I would have expected it to list to all entries starting with both of those letters - i.e concatenate those two letters to build the start of the name of the entry.
For example, if I have a TNSNames file that looks like
If I type the letter P, I would jump to PAA01 in the list. But if I follow that with an "R" it jumps to the entry RALPH.
This behaviour exists in both 3.2.20.09 AND 184.108.40.206.30. Only tried on Windows 32-bit.
How large is your TNSNames.ora and how fast do you type? Mine has over 100 entries, and I modified it temporarily to include ranges of entries like:
I was able to jump around randomly typing up to the first 3 letters without too much of a problem if I typed quickly. Sometimes it would seem to stick a bit (switching to a different first letter, then switching back helped), and keep in mind that repeating the same second or third character (rapidly) just scrolls through that range.
Hope this helps. If there is something specific to your environment you suspect may be a factor, please let us know.
SQL Developer Team