Paul,

Do you have an entry for the db on your windows box in the tnsnames.ora file on your Linux box ?
Try a tnsping from your linux box and see if it can resolve the DB on your Windows machine.

Chris.

-----Original Message-----
From: Paul Schiltz [mailto:oracledba-ezmlmshield-x54982677.[Email address protected]
Sent: Thursday, August 30, 2007 10:12 AM
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




Oracle LazyDBA home page