logo1
OCP TECHNOLOGY

ORA-02019: connection description for remote database not found

Posted on by Shripal

Hi, I'm facing this error "ORA-02019: connection description for remote database not found" during making a connection with the DB link.

Table of Contents

ORA-02019

SQL> select sysdate from dual@xdb_link;
select sysdate from dual@xdb_link
*
ERROR at line 1:
ORA-02019: connection description for remote database not found

This could be happening because of the wrong DB link name or a TNS entry missing of the remote database.

In my case my DB link name is xdb_link.

ORA-02019: connection description

Find DB Link

Using the below commands check the DB link details.

select * from dba_db_links;
select * from all_db_links;

I'm using the following command:

SQL> select * from dba_db_links where db_link='xdb_link';

no rows selected

If you didn't find a DB link with the above name then create a DB link. Check my previous post on how to create a DB link.

If the DB link exists and TNS entry is also available then recreate the DB link using IP address, port number, and service name, follow the below steps.

Note:

If the DB link exists and TNS entry is also available then recreate the DB link using IP address, port number, and service name, follow the below steps.
SQL> CREATE PUBLIC DATABASE LINK xdb_link CONNECT TO ocpx IDENTIFIED BY ocpx USING '192.168.1.10:1521/ocp';

Now try to connect with the DB link. If you still facing the same issue then follow the below tip.

Tip

Connect with source database and change the password of user (ocpx) and then recreate the DB Link and try, this time defenetly your issue will resolve. In my case this is worked.
$ sqlplus sys@ocp as sysdba

SQL> alter user ocpx identified by ocpz;

If you have other ways to solve "ORA-02019: connection description" issue please share with us at info@ocptechnology.com

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top