Re: TNS:listner Error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 22 Nov 2000 07:05:10 +0100
Message-ID: <8vh43r$4is9e$6@ID-62141.news.dfncis.de>

It has to be exactly the same.
Probably you are not using the tnsnames.ora you think you are using. Check for multiple tnsnames.ora on your client and/or try to play with the TOAD options to ignore/include NET8.

Hth,

Sybrand Bakker, Oracle DBA

"kush" <kdhakal_at_eline.com> wrote in message news:tRFS5.3057$A26.138329_at_sjc-read.news.verio.net...
> Hi all, I just have successfully installed oracle 8i on solaris. Now when
I
> tried to connect it through Toad(development tool) from WindowNT it gave
me
> following error.
>
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
> I have checked tnsnames.ora file on my(NT) machine and it looks fine. My
> question is does tnsnames.ora in NT has to be exactly same as tnsnames.ora
> in Solaris(where the oracle database resides)? even if that is true, I
tried
> that it also and I am getting same error. Do I need to change anything on
> listener.ora file on Solaris(where the oracle database resides)?.
> Any hint will be appreciated. thanks in advance.
>
> kush
>
>
Received on Wed Nov 22 2000 - 00:05:10 CST