Solved

ORA-02019: connection description for remote database not found

Posted on 2001-07-04
4
5,592 Views
Last Modified: 2012-06-21
I'm in an oracle8 database and want to describe a table which is in oracle7. I created a db link named "GEN" and issued the SQL below:

SQL> select count(*) from users@gen;
                                   
  COUNT(*)                          
----------                          
       870                          


However, when I DESC the table, it returned me an error:
SQL> desc users@gen                                            
ERROR:                                                          
ORA-02019: connection description for remote database not found
0
Comment
Question by:Jetso
  • 2
4 Comments
 
LVL 1

Expert Comment

by:edvinkv
ID: 6254482
configure your tnsnames.ora file properly.

Thanks
Edvin.
0
 

Expert Comment

by:gotjali
ID: 6254490
You might have been creating a db_link that is privat!

If the 'PUBLIC' option is not specified in the create
database link statement, the database link will be created as a private database link and will only be accessible to the user who created it.

select * from all_db_links;

- If you query ALL_DB_LINKS and receive 'no rows selected' or no rows returned where the owner is PUBLIC, the database link was created without the 'PUBLIC' option.  

Create a public database link as follows:

   - Log in to SQL*Plus or SVRMGR.

   - Create the public database link:

     SQL> create public database link <dblink name>
       2  connect to <user> identified by <password>
       3  using '<connect string>';

   - Query ALL_DB_LINKS and verify that the owner is PUBLIC.
0
 

Author Comment

by:Jetso
ID: 6254500
My doubt is that the select statement is working fine but the SQLplus "DESC" not works. They are issued under the same user account which created the private db link.
0
 

Accepted Solution

by:
gotjali earned 20 total points
ID: 6254529
Quite right! It seem that you have hit a Bug.

BUG: 1530562 DESC ON A DATABASE LINK FAILS WITH ORA-2019
BUG: 1509361 DESCRIBE OVER DBLINK.DOMAIN USES DB_DOMAIN    
             INSTEAD OF DOMAIN GIVEN
             IN LINK NAME
BUG: 1282056 DESCRIBE ON SYNONYMS REFERENCING OBJECTS OVER
             DB LINKS FAILS WITH ORA-2019

possible workaround:

Try to Create a view on the tablename@dblink and then describe the view.

SQL> Create view as test_view as select *  from emp@mydb;
View created

SQL > desc test_view;
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question