• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7859
  • Last Modified:

ORA-02019: connection description for remote database not found

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
Jetso
Asked:
Jetso
  • 2
1 Solution
 
edvinkvCommented:
configure your tnsnames.ora file properly.

Thanks
Edvin.
0
 
gotjaliCommented:
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
 
JetsoAuthor Commented:
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
 
gotjaliCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now