Re: ORA-12154: TNS:could not resolve service name

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 27 Mar 2002 00:31:44 -0000
Message-ID: <3ca228b8$1_2@mk-nntp-1.news.uk.worldonline.com>

"Aditya" <adityanath_at_hotmail.com> wrote in message news:4a5a78d4.0203261212.87a5c07_at_posting.google.com...
> Hi!
>
> I have to connect to a remote oracle database.
>
> I created a database link with the following syntax on my local
> database.
>
> create public database link dblink_dash connect to dash identified by
> board using 'prodsysadm'
>
> Link was created sucessfully.
>
> dash is the login for the remote database and board is its password.
> prodsysadm is the service name which I created on my PC using Net8
> Assistant.
>
> I am able to connect to the remote database from sqlplus
> connect dash_at_prodsysadm
>
> But When I try to connect through my sql using database link it gives
> this error
>
> Select count(*) from employees_at_dblink_dash
>
> ORA-12154: TNS:could not resolve service name
>
> I checked the global_names parameter on my local database, it is set
> to false.
>
> I will highly appretiate any suggestions on this problem.
> Thanks in advance.
>
> Regards,
> Aditya

Copy your tnsnames.ora and sqlnet.ora to the server. It's the server that needs to make the link.

HTH.
Paul Received on Tue Mar 26 2002 - 18:31:44 CST