Re: database link

From: Michael Ju. Tokarev <mjt_at_tls.msk.ru>
Date: Tue, 07 Sep 1999 16:59:02 +0400
Message-ID: <37D50C16.A8F2847A@tls.msk.ru>

Look to Oracle Messages and Codes manual -- it explains this error cleanly enouth:

02085, 00000, "database link XXX connects to YYY" *Cause: a database link connected to a database with a different name. The connection is rejected.
*Action: create a database link with the same name as the database it connects to, or set global_names=false.

Larry Pettit wrote:
>
> I'm running two instances on an NT machine and want to connect from one to
> the other. Both are using Beq.
>
> I'm able to create a database link in database 1 for database 2, but when I
> try to do a select on data using the sqlnet string set up in database 1, I
> get ORA-02085: database link xxxxxxxxxx.WORLD connects to SALES.WORLD.
>
> I've granted "create session" privileges in database 2 for the connect to
> username used in database 1. Both service names are in tnsnames.ora file on
> my machine.
>
> Any suggestions?
>
> Thanks.
Received on Tue Sep 07 1999 - 07:59:02 CDT