RE: Problem in creating DB Link

Hi Aleem,

Just try to create a simple link without PUBLIC and SHARED keywords if you don't really need them.
Login as user B and issue the following command:

CREATE DATABASE LINK mydblink
CONNECT TO userA IDENTIFIED BY password_of_userA USING 'abc';

If you get ORA-02019 then check if the correct service name (abc in that case) exists in your tnsnames.ora on server B. You can use TNSPING abc to ensure that your service name points remote db properly.

Regards,
Ed

>
> 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: Edward Shevtsov
  INET: eshevtsov_at_detmir.ru

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