My Oracle Support Banner

12c After Upgrade: Access Across DBLINK Fails: ORA-02019: Connection Description For Remote Database Not Found (Doc ID 2371902.1)

Last updated on MARCH 20, 2018

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Following an upgrade a database link or DBLINK stops working.

The following error is thrown:

ORA-2019:  Connection description for remote database not found

If the dblink is dropped and recreated, it starts working.

Changes

This is a problem that would arise after an upgrade from one version of database to another OR the introduction of a PDB in 12c Multitenant.
At some point since the creation of the database link, the DB_DOMAIN was changed from one value (or possibly null) to a different value.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.