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 18.104.22.168 and later
Information in this document applies to any platform.
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!