Help with creating db link
Date: Mon, 8 Oct 2001 12:46:11 +0600
Message-ID: <9prelm$12q$1_at_news.nsk.su>
[Quoted] Hello to everyone!
Excuse me for maybe simple question, but I faced with the following problem.
[Quoted] 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 - 08:46:11 CEST