ORA-02019: connection description for remote database not found

oracle database-link
Deepansh Anand picture Deepansh Anand · Sep 1, 2016 · Viewed 86.1k times · Source

I have created a db link AM_ADMIN throufh SQL Developer:

enter image description here

I am trying to check if it is a valid database link. When I test it from the SQL Developer wizard it is successfull. But when I use the below command:

SELECT * FROM dual@AM_ADMIN

I'm getting the error:

ORA-02019: connection description for remote database not found

How can I rectify this error?

Answer

Alex Poole picture Alex Poole · Sep 1, 2016

According to your screenshot you created the database link as AM_ADMIN.INT.xxx. You are calling it without the domain, just as @AM_ADMIN. Unless you have a sqlnet.ora which defines names.default_domain with the same domain value (and have SQL Developer configured to recognise that), you will need to fully-quality the link name when you use it:

SELECT * FROM dual@AM_ADMIN.INT.xxx

Related questions

How do I create a Database Link where remote and local are the same server

I have a need to create a database link that is a link to a schema on the same server. Is there a special keyword to use for this? ( like local or localhost ) I am not entirely sure what the …

Read More
How to create a database link in MySQL to connect to Oracle?

I need to create a database link in MySQL to connect to an Oracle database to use a table present in the Oracle database. I am not able to find any code or method of creating a database link in …

Read More
Can't create Database Link to remote DB in Oracle-DB

We have a CRM system in our company, which uses an Oracle 11g database. It is developed by a third party vendor. We do not have access to the server which runs the CRM system. But nevertheless, we have working …

Read More