Re: database link

The service names should be in the tnsnames.ora on the server, but that's not your problem here. It is able to connect (and get the error) because both databases are on the same system.
Your global_names parameter in init<sid1>.ora is true. This means the database name should be unique within your network, and the link name should be db_name||'.'||db_domain.
Either switch that parameter of your change the link name or the database name.

Hth,

--
Sybrand Bakker, Oracle DBA
Larry Pettit <larry.pettit_at_ps.net> wrote in message news:25Bz3.357$e8.49288_at_news.uswest.net...
> 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 Thu Sep 02 1999 - 16:45:12 CDT