Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

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

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.

Dig Deeper on Oracle database administration

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close