SQLDeveloper stubbornly refuses to see my tnsnames.ora changes...
raindogDec 13 2010 — edited Dec 15 2010Win32 x86 32-bit running SQLDeveloper 2.1.1
Previously, I had a tnsnames.ora file in place with several hundred entries. SQLDeveloper worked fine.
Then I deleted that file and created a new tnsnames.ora file with only one entry.
When I try to define a new Database Connection (Connection Type: TNS), I still see all the old entreis under Network Alias. (Yes, I've quit and restarted SQL Developer).
I do not have a tnsnames.ora file in my home directory...in fact, the only one on the whole box lives in $ORACLE_HOME/network/admin (I searched ;-) I have setup a TNS_ADMIN environment variable...no change.
I suspect there is something cached somewhere, but I did a registry search for "TNS" and didn't find it.
I've since uninstalled the client and reinstalled it, and ran a fresh copy of SQLDeveloper...and it's still showing the old entries!
What am I missing? Some preferences/properties cache file somewhere? Is there a way in SQLDeveloper to say "go refresh your list of tns entries"?