RE: Problem in creating DB Link

Do you have a public synonym for the link? Otherwise try: desc table_name_at_public.link_name.

John P Weatherman
Database Administrator
Replacements Ltd.

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

Thank you Edward,

As suggested, I have tried the following command (since PUBLIC is required) CREATE PUBLIC DATABASE LINK my_link

   CONNECT TO UserA1 IDENTIFIED BY passwordA    USING 'abc'

The Server B from where I am issuing this command, connects to the Server A using the same connect string 'abc'. After this connection I am able to view tables, data etc. But the command describe table1_at_my_link seems to be liking the error
ora-02019: connection description for remote database not found.

The view all_db_links lists this link but appends us.oracle.com to my_link under db_link column. Any more suggestions

For dropping the link, I was missing "PUBLIC" keyword

Aleem

 -----Original Message-----

Sent:	Monday, August 26, 2002 4:03 PM
To:	Multiple recipients of list ORACLE-L
Subject:	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).
-- 
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: John Weatherman
  INET: john.weatherman_at_replacements.com

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