Re: Database link Help

Ooops, sorry, pls neglect my message below. My reply was out of scope <g>. I was so quick to look for replies to my previous message about dataabse link hangs. /Johan Thorselius

Johan Thorselius wrote:

> 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:05:47 CDT