You have global naming turned on. Either turn it off or your DBLINK must be
ORCL
The parameter for global naming is in the init.ora file
HTH
"Иголкин Александр" <drv_at_sibvaleo.com> wrote in message
news:9preln$12q$3_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
>
>
>
Received on Tue Oct 09 2001 - 13:51:26 CDT
