Sunday 3 December 2023

ORA-02085: Database Link LINK_NAME Connects To TARGET_DB


 This issue may come in multitenant database even GLOBAL_NAMES=false in container level.

we can fix this issue by setting the same parameter in PDB level, login to the PDB and set as below.

sqlplus / as sysdba

alter session set container=<pdb name>;

alter system set GLOBAL_NAMES=false;