My Oracle Support Banner

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 to [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


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


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.