How do I actually get the tnsnames.ora file to import?
I've read the instructions on how to get the tnsnames.ora file to import, but nothing is working.
I've seen conflicting information on the net about exactly where SQLDev looks for the tnsnames.ora file. I've seen both %HOME%\tnsnames.ora and %HOME%\.tnsnames.ora mentioned, but neither of those appear in the SQLDev online help.
I don't have Oracle installed, so I tried setting the environment variable TNS_ADMIN to my home directory and putting "tnsnames.ora" in that directory and restarting SQLDev. No difference.
I actually have some connections already, which I think I must have imported from this file at one point, but I don't remember how I did it. I've noticed the "Import Connections" dialog, but that appears to be useless, as it only allows importing from some XML or Properties format.
What is the simplest way to get this done?