It seems to come up often that some people are unsure where the list of connections get picked up from. So, if your not sure which tnsnames file sqldev is using try this:
1) Open any worksheet
Sqldev just needs someplace to process the next command and doesn't actually use the connection for anything.
2) Enter : setloglevel oracle.dbtools.raptor.utils INFO
This sets the java logging level on for this package so you can avoid putting the entire tool into debug and being inundated withe log messages. setloglevel is something I put in to help debugging using the same method I had blogged on before.
3) open the new connection dialog
The tnsnames are read everytime the dialog opens. This is handy for testing changes to the tns files.
4) check the log
You should end up with something like this. The log will show where it's checking for the tnsnames. Share: TwitterFacebookLinkedIn