Re: Strange database link behavior

I had the same problem... First of all, you have to have that service name configured in SQL*Net, and besides, the parameter GLOBAL_NAMES in init.ora has to be set to FALSE in order to give the database link the name which differs from the name of the database it points too. This parameter GLOBAL_NAMES you can change for the running session with ALTER SYSTEM SET GLOBAL_NAMES command, and later change it in init.ora for the next times.

> I think your link name has to correspond to the name in the tnsnames.ora
> file.
>
> Will Hartung wrote in message ...
> >I'm trying to create a database link between two servers.
> >
> >I've executed the following command:
> >
> >create public database link serverb connect to username by password
using
> >'serverb';
> >
> >In the USING clause, I'm entering the service name.
> >
> >However, when I try to do something like:
> >
> >select * from table_at_serverb
> >
> >I get a:
> >
> >ORA-02085: database link SERVERB.WORLD connects to BALAK.WORLD
> >
> >The error messages manual says that the link name must be the same as
the
> >database name. But I *THINK* that's what I'm doing.
> >
> >Any advice would be appreciated.
> >
> >
> >
> >
>
>
>
Received on Wed Dec 30 1998 - 03:41:25 CST