12c PDB or Multitenant Only: ORA-02085: Database Link "LINK_NAME_HERE" Connects To "TARGET_DB"

(Doc ID 2344831.1)

Last updated on JANUARY 03, 2018

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Information in this document applies to any platform.
This problem is limited in scope to the use of a DBLINK in a PDB or multitenant database in version 12.1.0.x.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms