The path is set in the Database->Advanced->Tnsnames Directory (c:\app). There are no files in that path that are like tnsnames.ora. The Use Oracle Client and OCI/Thick driver are unchecked.
SQLPLUS and TOAD are working fine.
sqlcl also does not find the tnsnames file either.
Also, the connections that were set in the previous version imported and work fine. It's just when I want to create a new connection, I have to use the basic style.
i'm out of ideas.
Ok - I'm confused.
You point the preference setting to a folder that does NOT have a tnsnames.ora and then ask why you can't find the tnsnames.ora file?
What am I missing?
The 'basic' connection type is a type 4 driver - that is, pure Java. It does NOT use tnsnames.ora and therefore does NOT know about any aliases.
If you want to use the OCI/thick driver you need to point the preference setting to a folder that DOES have a tnsnames.ora file.
I meant only the tnsnames.ora is in that path, not other files like tnsnames.
Are you sure that is all that changed? Maybe you were actually relying on the TNS_ADMIN environment variable previously and that got unset?
Do you really have the tnsnames.ora file in C:\app? Normally it would something like...
Yes, I really have tns_admin set at c:\app and yes the tnsnames.ora file is in that directory.
am I sure that is all that changed, YES. Like I stated, my other tools continue to work fine and they rely on tns_admin, as does sqlplus.
figured this out, i had an extraneous character in the tnsnames.ora.
Do you mean an extraneous character within the tnsnames.ora file itself? That would make sense -- SQL Developer is known to be finicky about reading it.
Otherwise, in my environment, even launching from a
1. Windows CMD console with TNS_ADMIN and ORACLE_HOME unset and
2. SQL Developer Database > Advanced preferences not pointing to any Tnsnames directory
the Network Alias list in the New Connection dialog is still populated. Apparently the code that searches for tnsnames.ora from before the existence of that preference still works fine.
Then please mark the thread ANSWERED.
And clarify: are you saying that sql developer won't work with that extraneous character in the file but sql*plus will work for the SAME file?
It certainly seemed to, I only have one tnsnames file on my laptop.