Wednesday, April 16, 2008

Which tnsnames?

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.

No comments: