Re: Help with creating db link
Date: Mon, 8 Oct 2001 14:58:40 +0400
Message-ID: <9ps0s7$2dtb$1_at_inn.elektra.ru>
Hi Aleksandr
[Quoted] You should set global_names in false in you init.ora file.
global_names = FALSE
wbr
"Иголкин Александр" <drv_at_sibvaleo.com> wrote in message
news:9prelm$12q$1_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 Mon Oct 08 2001 - 12:58:40 CEST