12c After Upgrade: Access Across DBLINK Fails: ORA-02019: Connection Description For Remote Database Not Found
(Doc ID 2371902.1)
Last updated on MARCH 31, 2022
Applies to:Oracle Net Services - Version 126.96.36.199 and later
Oracle Database - Enterprise Edition - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 19]
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!
In this Document