Solved

ORA-02019: connection description for remote database not found

Posted on 2001-07-04
4
5,897 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
DB migration from Mssql to 12c oracle , data not loading. 3 48
Fill Null values 5 36
Error in creating a view. 8 35
scheduler notification 9 42
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

726 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