Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help with creating db link
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:46:55 CDT
![]() |
![]() |