Re: Database-Link

From: Jens Baumeister <invalid_at_spam.no>
Date: Fri, 11 May 2001 20:26:45 +0200
Message-ID: <9dharj$a02$1@news.netcologne.de>

Oliver Schubert <OSchubert_at_timocom.de> schrieb in im Newsbeitrag: 3afc2bc0$0$12254$45beb828_at_newscene.com...

> my problem is to get data from the database link (e.g. with select * from
> test_at_LINKNAME). Oracle prompt the error "ORA-12154: TNS:Der Servicename
> konnte nicht aufgelöst werden." ("Servicename can't resolve" imo).
>
> so what can i do?

Did you specify the service name for the DB you want to link to on the DB-Server or only on the client?

You say that you can log in from your client computer, so it sounds as if you have a correct tnsnames.ora file there. Perhaps the tnsnames.ora on the db server doesn't have an entry for the other db thus it can't connect. That ouldn't show when you try connecting from the client but it would produce the error you described.

Jens Received on Fri May 11 2001 - 13:26:45 CDT