Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORA-02019: connection description for remote database not found

Posted on 2001-07-04
4
Medium Priority
?
7,168 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 40 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup
Suggested Courses

916 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