Re: Database link Help

Thanks. But the TNSNAMES.ORA part we have tested and it works well. The server is used by other projects with public database links. The name of the database link is project specific and just like ABCD_EFGH

Johan Thorselius

Ulrik Hoffmann wrote:

> > 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?
>
> 1. Is he TNSNAMES.ORA on the server available? Must be in the Net80/Admin
> directory on the server.
>
> 2. 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 - 03:02:46 CDT