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

Thanks, I did both the things.
1. Added service name for remote databse in sever's tnsnames.ora 2. Also copied the sqlnet.ora to the server Now when I try to run the same query, I get error

ORA-12543: TNS:destination host unreachable ORA-12543: TNS:destination host unreachable

Regards,
Aditya

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7qrab$vlt$1_at_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 Wed Mar 27 2002 - 10:23:39 CST