Hi, I'm facing this error "ORA-02019: connection description for remote database not found" during making a connection with the DB link.
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.
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.
TipConnect 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 email@example.com
- ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST
- Delete RMAN Backups
- ORA-02019: connection description for remote database not found
- How to Recover lost datafile with no backup
- Oracle RMAN Backup Types
- ORA-12954: The request exceeds the maximum allowed database size of 12 GB
- Rman full database backup script
- crosscheck archivelog all
- ORA-19913 unable to decrypt backup
- RMAN BACKUP SCRIPT