ORA-12154 when creating a Public Database Link within a Container Schema (CDB)
(Doc ID 2286792.1)
Last updated on JANUARY 20, 2025
Applies to:
Oracle Net Services - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
As SYS user in a Container, created a public database link.
Referencing is working under SYS user of the container, but failed with TNS-12154 when logged in as regular user.
Changes
New install of 12.x with Multi Tenant use (CDB and PDB).
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 |