TMS Database Registration Error ORA-02082: A Loopback Database .. ORA-02082 (Doc ID 279598.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Thesaurus Management System - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 16-Feb-2010***

Symptoms

Unable to regsister database. Error message:
BEGIN tms_user_synchronization.RegisterInstance('OCLPRD','OCL'); END;

*
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier
ORA-06512: at "OPA.OPA_DDL", line 37
ORA-06512: at "OPA.OPA_DDL", line 354
ORA-06512: at "TMS.TMS_USER_SYNCHRONIZATION", line 1146
ORA-06512: at "TMS.TMS_USER_SYNCHRONIZATION", line 1134
ORA-01403: no data found
ORA-06512: at line 1

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