Problem in creating DB Link

From: Abdul Aleem <dmit_at_beaconhouse.edu.pk>
Date: Mon, 26 Aug 2002 02:08:22 -0800
Message-ID: <F001.004BF64A.20020826020822@fatcity.com>

Hi,

I have created a Database Link under the scenario detailed below: but when I try to access tables through the link it gives error ORA-02019: connection description for remote database not found.

If I try to drop the link it gives error ORA-02024: database link not found

TIA! Aleem

This is the scenario:
We have two db servers running on our LAN, for simplicity 'A', connect string 'abc' and 'B', connect string 'xyz'.

Some of the tables on A in schema UserA1 are required (read only) by schema UserB1 on server B. As suggested by someone I tried to create a dblink. Using SQL*Plus connected as 'System' to Server B (since it requires to access tables from the other db) and applied the following command.

CREATE SHARED PUBLIC DATABASE Link my_link

   CONNECT TO UserA1 IDENTIFIED BY abc
   AUTHENTICATED BY UserB1 IDENTIFIED BY def    USING 'abc'

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
  INET: dmit_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 26 2002 - 05:08:22 CDT