Oracle Error ORA-09276: All bequeath database links must be loopback database links

Oracle Error Message

ORA-09276: All bequeath database links must be loopback database links

Reason for the Error

A non-loopback bequeath connect string was supplied for a database link.

Solution

Please use a connect string with a different transport protocol, or specify a loopback connect string (one that points to the instance for the current session) using “(PROGRAM=/bin/oracle)” and, optionally, “(ENVS=”ORACLE_SID=”)”.