When I setup my first tns connection, I’d just installed sqldeveloper and ran it by executing the shell script ( sqldeveloper.sh) from a Terminal Window. However, when I run SQLDeveloper from the Ubuntu desktop menu, I’m not starting a shell, so my. The rest all rely on environment variables being set. Only one of these places is has an absolute path. $ORACLE_HOME/network/admin/tnsnames.ora.In Sue’s article, it states that SQLDeveloper looks for a tnsnames.ora in the following places in this order : Status: Failure – Test failed : no ocijdbc11 in When testing an existing TNS connection you get :.Empty Network Alias list when defining a TNS connection.Remember, this problem had two primary symptoms :. If you’re hitting this problem on Windows, then you may want to follow the instructions there to set up a TNS_ADMIN environment variable. Having had a bit of a dig around, it would seem that this problem is not platform specific and affects Windows in the same way.Īt this point, I’d like to say a big “thank you” to Grzegorz Wilczura, who referred me to this article by Sue Harper.
This is a follow up to my earlier post about SQLDeveloper being moody and suddenly refusing to connect to a database via TNS.
