How to fix the Oracle error ORA-23397: global name “string” does not match database link name “string”?

In this post, you’ll learn more about the Oracle ErrorORA-23397: global name “string” does not match database link name “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-23397: global name “string” does not match database link name “string”

Reason for the Error ORA-23397: global name “string” does not match database link name “string”

the database link name at the local node does not match the global name of the database that the link accesses.

How to fix the Error ORA-23397: global name “string” does not match database link name “string” ?

You can fix this error in Oracle by following the below steps

Ensure that global names is set to true and the link name matches the global name.