OWB 11g Mapping Deployment Fails With ORA-02011: duplicate database link name
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms