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?