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
....@databaseli nk , 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]

Re: data base link

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
...@databaselin k , 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