Re: Database link Help

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 18 Jun 1999 08:33:28 +0100
Message-ID: <7kcp7b$2mk$1@freeside.cls.net>

> I'm having a problem connecting to Oracle 8.0.5.1 through a database
> link. I have no problems connecting to a 7.3.4 database from the
> version 8. However, when I try to connect from 8 to another 8
> database, I get a TNS unable to connect to resolve service name. We
> just upgraded to version 8.0.5.1 from 7.3.4.
>
> create database link test connect to scott identified by tiger using
> 'CONNECT_STRING';
>
> I've tried using various combinations for the CONNECT_STRING but to no
> avail.
>
> Connections to each of the version 8 databases through SQL*Plus
> succeeds every time using the service names created with Net 8 easy
> config. Any ideas?

Is he TNSNAMES.ORA on the server available? Must be in the Net80/Admin directory on the server.
What kind of name did you coose? Maybe you have to set the global_names=false in the initorcl.ora file.

Bye
Uli Received on Fri Jun 18 1999 - 02:33:28 CDT