Re: SQL Navigator, TNS error

Tools are not consistent in which Oracle_Home they use..so Modify your PC by adding an environment variable called TNS_ADMIN and 'point it' to the Oracle_Home/network/admin location you want to use and then all your tools will use this one to find tnsnames.ora, sqlnet.ora etc...

roseliang_at_yahoo.com (Rose) wrote:

>Hi;
>
>I installed SQL Navigator3.0 and try to connect a remote database. I
>set up the tnsnames.ora entry for that database and test on 'tnsping',
>successfully. But when I start SQL Navigator and put the correspond
>user and password, as well as connect string( same as the name for the
>tnsnames.ora entry) on the login window. It prompt :" ORA-12514: TNS:
>listner could not resolve SERVICE_NAME given in connect descriptor".
>
>I have 3 version of ORACLE (8.0, 8.15, 8.16) in this machine and the
>Oracle_Home is for the Oracle 8.16 which the listener is active. I add
>the entry for the listner.ora, tnsnames.ora for this Oracle version. I
>anded the IP address for the server that database is sitting in the
>host file. I ping and tnsping the server successfully. I don't know
>what else I should do to solve this problem.
>
>Any help will be appreciated.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Aug 02 2001 - 19:26:29 CEST