Do you have a matching entry in your tnsnames file for the specification
used in your dblink?

Michael Peel

-----Original Message-----
From: Paul Schiltz
[mailto:oracledba-ezmlmshield-x54982677.[Email address protected]
Sent: 30 August 2007 16:12
To: LazyDBA Discussion
Subject: dblink/tnsnames problem

I have installed Oracle Express Edition on my windows machine and it is
working exactly as expected. I have also created a dblink to this database
on one of my linux boxes and the link works fine. My problem is that I am
unable to read the db on my windows machine from the db on the linux box. I
keep getting error ora-12154 TNS: Could not resolve service name.

I have created a dblink on the in the windows db but apparently not
correctly.



Paul Schiltz

[Email address protected]





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page