SQL Navigator 5.5 - Creating Sessions
-
I receive the following rather vague error message when I try to open a session in SQL Navigator... I don't have a lot of patience for trying to figure this out myself now that I finally received a license for this software (after waiting 5 months). I know that my tnsnames.ora file is correct because I obtained it from another developer.
ORA-12154: TNS:could not resolve the connect identifier specified
Make sure connection parameters are correct and try again
I'm trying to connect to Oracle 10g. Has anyone seen this before?
-
Just because you got the tnsnames.ora from another developer doesn't mean it's right for your machine.
Can you tnsping the database using the alias specified in your tnsnames file?