We recently moved from one UNIX box to another. Since the move, I have been unable to connect. I have changed my tnsnames.ora file to reflect the new server name and I can connect to it using SQL + fine, but when I try to connect now using SQL Nav I get this message:
ora-12505: TNS: listener could not resolve SID given in connect descriptor.
Make sure connection parameters are correct and try again.
I had my DBA put the db back up on the old Unix box, and I can connect to it without changing my tnsnames.ora file back to the old server. Why? I removed my old connections to this db from my workspace. I then tried copying the tnsnames.ora file from a co-worker who can connect to this database on top of my own nad I still cant connect. Nav works for all my other database, except this one whose location was recently changed
WORKAROUND 1:
Please go to C:\Documents and Settings\<persona></persona>\Application Data\Quest Software.Find your SQL Navigator file for your current install and find your workspace#.WSF file(s). If you are working with a Nav version 4.1 or lower, please check the SQL Nav install directory for the workspace files. If you need, do a system search for all .WSF files and note the path and rename them.
Rename them (like workspace#.WSFold) and then launch SQL Nav. Test your connection again.
WORKAROUND 2:
SQL Nav basically reads from the tnsnames file and whats saved on the workspace files. Please do a system search for all tnsnames.ora files and make sure you only have one and that it is the correct one located in the path of your client install so that Nav can access it.
(Review common connection issue with sol7712 -- SQL Nav connection is similar to Toad for Oracle.)
WORKAROUND 3:
Do a custom uninstall of SQL Nav to clear our registry of possible locations of where connection information is kept.
(Review common connection issue with sol21743 -- this will walk you though the removal of registry entries for SQL Nav.)
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center