12c PDB or Multitenant Only: ORA-02085: Database Link "LINK_NAME_HERE" Connects To "TARGET_DB" (Doc ID 2344831.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

Symptoms

A database link that is created in a PDB where GLOBAL_NAMES=false can incorrectly throw
this error.  This is true even when a check of GLOBAL_NAMES in the PDB reveals it is set
to false. 

While logged in to the PDB and select across the link yields:

select * from dual@linkname;

ORA-2085: database link %s connects to %s

The error is only thrown when the GLOBAL_NAMES parameter at the origin or source database is set to TRUE
and the following condition is met:

The origin or source database link name does NOT match the target
database DB_NAME.DB_DOMAIN or the value of the GLOBAL_NAME table.

See the following document for an explanation of this error and the relationship between GLOBAL_NAMES and a dblink.

<Note: 210630.1> Database Links: Troubleshooting ORA-2085: database link %s connects to %s

A check of the CDB reveals that GLOBAL_NAMES is set to true.
A check of the PDB reveals that GLOBAL_NAMES is set to false.

Changes

This problem may arise suddenly if the CDB has been restarted.
Again, no apparent changes have occurred and this established dblink has been working
for some time.

This is not an issue that arises during a dblink creation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.