ORA-02019: CONNECTION DESCRIPTION FOR REMOTE DATABASE NOT FOUND.

DESCRIPTION:

In this blog,we are going to know about how to overcome ORA-02019 error in database.

CAUSE:

An attempt was made to connect or log in to a remote database using a connection description that could not be found.

SQL> select * from EMPL1@DB_link;

select * from EMPL1@DB_link

*

ERROR at line 1:ORA-02019: connection description for remote database not found.

SOLUTION:

First check database link ( dblink ) name ( DB_link ) if it exists or not in the database using the following script.

select * from dba_db_links;

select * from all_db_links;

 

If you check the dblink doesn’t exist as follows.

SQL> select * from dba_db_links where db_link=’DB_link’;

no rows selected

 

Then create the database link as follows. we can create the dblink both private and public.

Private dblink is created as follows.

CREATE DATABASE LINK DB_link

CONNECT TO Datalink

IDENTIFIED BY Datalink

USING '192.#####:1521/DEVECI';

Public dblink is created as follows.

CREATE PUBLIC DATABASE LINK DB_link

CONNECT TO Datalink

IDENTIFIED BY Datalink

USING '192.####:1521/DEVECI';