Creation of a Loopback DBLINK Yields the Error: ORA-2082 (Doc ID 1381497.1)

Last updated on AUGUST 06, 2014

Applies to:

Oracle Net Services - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 7-aug-2014***
this note does not seem to apply for 12c

Symptoms

During the creation of a loopback database link the following error is thrown and the link is not created:


ORA-2082: a loop-back database link must have a connection qualifier
Cause: An attempt was made to create a database link with the same name as
the current database.



In some newer releases of Oracle, the following error may be thrown in addition to the ORA-2082:


ORA-39083: Object type DB_LINK failed to create with error

Changes

This is a new attempt to create a database link that loops back to itself.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms