ORA-02085: database link string connect to string

I got ” ORA-02085: database link string connect to string ” error in Oracle database.

 

ORA-02085: database link string connect to string

 

Details of error are as follows.

ORA-02085: database link string connects to string

Cause: a database link connected to a database with a different name. 
The connection is rejected.

Action: create a database link with the same name as the database it connects to, 
or set global_names=false.

 

 

database link string connect to string

This ORA-02085 errors are related with the database link connected to a database with a different name. The connection is rejected.

To solve this error, you should create a database link with the same name as the database it connects to,
or set global_names=false as follows.

You can set it for any session.

alter session set global_names=false;

 

Or you can set this parameter for the instance as follows.

SQL> alter system set global_names=FALSE scope=both;

System altered.

SQL> show parameter global_names

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE

 

If you got the same error again, please drop and create dblink again using the following post.

Database Link ( Dblink ) in Oracle Database

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )