Re: Help with creating db link

"????????? <drv_at_sibvaleo.com> wrote in message news:<9preln$12q$2_at_news.nsk.su>...
> Hello to everyone!
>
> Excuse me for maybe simple question, but I faced with the following problem.
> I have two Oracle8 servers under Red Hat 6.2 Linux on two different
> computers(all names and IPs are given for example):
> HOPE (100.100.100.1)
> ELVIS (100.100.100.10)
>
> Adding service to tnsnames.ora(HOPE):
> oranet =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= elvis)(Port= 1521))
> (CONNECT_DATA = (SID = orcl))
> )
> and executing on HOPE (under user SYSTEM)
> CREATE DATABASE LINK netln CONNECT TO user IDENTIFIED BY password USING
> 'oranet';
>
> After this, when I'm trying to execute
> select * from employee_at_netln;
> system says:
> ORA-02085: database link NETLN.WORLD connects to ORCL.WORLD
> and nothing else happens.
>
> Help please.
> Thanx a lot. Alexander

You have
init.ora global_names = true on the elvis database. This forces an unique database name and it also forces the link name should equal the database name and the domain. Either you need to rename your link to orcl, your database to netln, or change global_names to false and bounce the database. Please note this is a FAQ and a search on ORA-2085 on groups.google.com would have provided an answer.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Mon Oct 08 2001 - 04:44:55 CDT