Why am I getting the ORA-02019 error?

An Oracle user asks why they are getting the ORA-02019 error when trying to create a link between databases.

Published: 29 Feb 2008

We have two databases in the network. I want to access a table in the second database user table from the first...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

database user. I tried to create a database link to connect to the second database, but I am getting the following error: ORA-02019: connection description for remote database not found.

When you create a database link, you use the following command:

CREATE DATABASE LINK link_name CONNECT TO username IDENTIFIED BY password USING 'tns_entry';

In the above, the USING clause specifies a TNS entry in your TNSNAMES.ORA configuration file. So you have to update your config file. The ORA-2019 error is indicating that the tns entry is not found in this file. And database links always look for the tnsnames.ora config file in the ORACLE_HOME/network/admin directory. So make sure the file exists in this entry and the file is updated.

Battle through the recurring Oracle TNS mistakes admins make

How to create an Oracle database link

ORA-12535 error connecting to local database through VPN

ORA-12535: Operation times out when trying to connect to database