The link works fine you say, but yet you are unable "to read the db on
my windows machine from the db on the linux box" [where the link was
created].

That makes it look to me like the link does not work "fine". How did
you determine that the link worked at all? Just the fact that Oracle
did not complain with an error when you created the link *DOES NOT*
means that is "works fine".

We do have a dblink to an Oracle10 Express Edition database on a Windows
machine from our production (Oracle10) database on Linux, and this link
works for us and allows our Linux-based database to both read and write
data to/from the Oracle Express database, so this can be done. But the
tnsnames.ora file on the Linux machine must be configured correctly to
support the link.

The entry in our tnsnames.ora file on our Linux server for the Express
database looks like this:

[alias_name] =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = [host_name])(PORT = 1521))
(CONNECT_DATA =
(SID = XE)
)
)

-----Original Message-----
From: Chris Ermlich
[mailto:oracledba-ezmlmshield-x21738316.[Email address protected]
Sent: Thursday, August 30, 2007 11:39 AM
To: LazyDBA Discussion
Subject: RE: dblink/tnsnames problem

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





---------------------------------------------------------------------
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



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page