Solved

ORA-02019: connection description for remote database not found

Posted on 2001-07-04
4
4,942 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now