12c After Upgrade: Access Across DBLINK Fails: ORA-02019: Connection Description For Remote Database Not Found
(Doc ID 2371902.1)
Last updated on SEPTEMBER 08, 2023
Applies to:
Oracle Net Services - Version 12.1.0.2 and laterOracle Database - Enterprise Edition - Version 19.11.0.0.0 to 19.11.0.0.0 [Release 19]
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |