Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help with creating db link

Help with creating db link

From: Иголкин Александр <drv_at_sibvaleo.com>
Date: Mon, 8 Oct 2001 12:47:16 +0600
Message-ID: <9preln$12q$3@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 - 01:47:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US