Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS:listner Error
Hi!
Make sure the TNS_ADMIN Variable is set in all oracle_homes on your
NT-BOX correctly in the Registry
(Hkey_local_machine->software->oracle) ...
Unfortunately I get the same error using TOAD unless I copied the tnsnames.ora (normally stored on a common path given in the TNS_ADMIN) into each oracle_home on my local box.
The tnsnames-file has nothing to do with the one on the database-server-machine.
I hope some of this will help you :)
Sandra
In article <tRFS5.3057$A26.138329_at_sjc-read.news.verio.net>,
"kush" <kdhakal_at_eline.com> wrote:
> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 22 2000 - 06:29:49 CST