Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154: TNS:could not resolve service name

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

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Tue, 26 Mar 2002 14:29:37 -0600
Message-ID: <bfm1aus93f1ju86k32v3sip64efn0shb9e@4ax.com>

Just a reminder if you haven't checked:
db links use the tnsnames.ora file on the SERVER not the client...so be sure that one has the same info as the one on your client PC

adityanath_at_hotmail.com (Aditya) wrote:

>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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Mar 26 2002 - 14:29:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US