data base link

[Search]

I have oracle 8.1.7.
the tnsnames.ora is ok .
With the connect function I can connect to the remote database.
BUT when I use the create database link command then it goes wrong.

I can create the database link but when I try a simple select * from
....@databaselink , I
recieve following error : tns servicename could not be resolved.

But that is not true because I configured the tnsnames.ora well and that
works.

Could it be the the database link uses another file then tnsnames.ora ?

How could I fix this problem?
rgds
Gerry

[Frank van Bortel]

Search wrote:

I have oracle 8.1.7.
the tnsnames.ora is ok .
With the connect function I can connect to the remote database.
BUT when I use the create database link command then it goes wrong.

I can create the database link but when I try a simple select * from
...@databaselink , I
recieve following error : tns servicename could not be resolved.

But that is not true because I configured the tnsnames.ora well and that
works.

Could it be the the database link uses another file then tnsnames.ora ?

How could I fix this problem?
rgds
Gerry

Your tnsnames is NOT ok - you are looking at the wrong
one (assumption made - not enough details).
Check your tnsnames on the SERVER, not the client

--

Regards,
Frank van Bortel