Re: CREATE DATABASE LINK

From: Bastiaan Schaap <bschaap_at_desyde.nl>
Date: 2000/07/23
Message-ID: <newscache$o4z4yf$w25$1@lnews.actcom.co.il>#1/1

Hi Christian,

We had a similar problem with a database link, and it turned out to be that we needed to set the GLOBAL_NAMES setting on the target database to FALSE. It had something to do with the .world extension in the TNS configuration. We also could connect with SQL*Plus, but not through a database link. Setting the GLOBAL_NAMES=FALSE, solved out problems.

HTH, Bastiaan Schaap
Oracle web development,
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31355411711

Christian Bielzer <christian.bielzer_at_sawis.de> wrote in message news:39755BA0.5ACA8949_at_sawis.de...
> I am having two 8.0.5 databases running on separate hardware. In each
> database I have created a user with dba previleges. I than create a
> databaselink:
>
> CREATE DATABASE LINK toRemoteDb CONNECT TO chris IDENTIFIED BY tiger
> USING 'wds';
>
> This stament was processed successful. I than wanted to access a table
> on the remote database, so I launched the following statement:
>
> select * from standortliste_at_toRemoteDb ;
> ORA-12154: TNS:could not resolve service name
>
> Since the error implies that the service is not specified in the
> tnsname.ora, I added the service and still get the error-message.
>
> What am I doing wrong?
>
> Thanks in advance
>
> Christian Bielzer
>
Received on Sun Jul 23 2000 - 00:00:00 CDT