Oracle-L: RE: Problem in creating DB Link

From: Nicoll, Iain \(Calanais\) <iain.nicoll_at_calanais.com>
Date: Mon, 26 Aug 2002 02:53:20 -0800
Message-ID: <F001.004BF6C2.20020826025320@fatcity.com>

Aleem,

Cany you tnsping the abc database from the server which the database with the link resides on.

Can you do a select * from dba_db_links and see if you can see the link and the owner.

Also can you advise exactly how you are doing the drop and from which user?

Iain Nicoll

-----Original Message-----
Sent: Monday, August 26, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Nicoll, Iain \(Calanais\)
INET: iain.nicoll_at_calanais.com

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