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

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Mar 2002 09:03:50 +1100
Message-ID: <a7qrab$vlt$1@lust.ihug.co.nz>

Whilst the connection string works for you on your PC using sqlplus, a database link means that it's the *server* itself that has to be able to resolve the name. So a copy of your PC's tnsnames has to reside on the server (in the $ORACLE_HOME/network/admin directory, by default, or wherever your TNS_ADMIN environment variable is pointing).

You should probably also have a copy of your PC's sqlnet.ora on the server (same location), because that can do rather fiendish things, such as silently supply a default domain name to any tnsnames alias that is supplied without one. So the server requests a connection to 'prodsysadmin', and sqlnet.ora gets in there and tacks a '.world' or something equally awkward onto the end of it. Unless your tnsnames then has an alias for 'name.domain', the silently-expanded alias is unresolvable.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.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

Received on Tue Mar 26 2002 - 16:03:50 CST