OWB 11g Mapping Deployment Fails With ORA-02011: duplicate database link name
(Doc ID 1287313.1)
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 126.96.36.199 and later
Information in this document applies to any platform.
OWB 11g Mapping deployment fails with:
Characteristics of the Mapping
- Source table within the mapping resides in a remote database
- OWB Source Location is registered with SQL*Net.
The location deploys fine (the database link is created in the database), but the Control Center does not register the location as having been deployed. This gives rise to continuous "ORA-02011: duplicate database link name" errors every time a mapping is deployed, since the mapping generation also triggers the re-generation of the database link code – which has already been deployed and therefore fails to create a second time.
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