ORA-02085: database link String connects to string

Posted by Shaik Ahmed Ali on October 24, 2022 in create database link, ORA-02085 | No comments

 Hi Everyone,

after creating the database link, I was trying to fetch record from the remote database server but receive the following error as below 

ORA-02085: database link String connects to String

Solution:

Description

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.

If the global_names is set to TRUE, then run the below command:

Alter system set global_names=FALSE scope=both;

then recreate the database link.

It worked for me.

Hope the Solution worked for you as well.

Thanks for reading 

Shaik Ahmed Ali