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

That indicates a network problem - Are there different routers for the client and server; If so, be sure the router(s) between the host server and the target server do not block the packets...( Firewall maybe ? ) Or maybe the address cannot be resolved by the server ( not using DNS or some such) so try using explicit dot notation for the host address in the tnsnames.ora file on the server...  

try it also without sqlnet.ora
adityanath_at_hotmail.com (Aditya) wrote:

>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

-----= 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 Wed Mar 27 2002 - 10:35:09 CST