remtool -asrsetup fails with ORA-04052: error occurred when looking up remote object (Doc ID 864964.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Internet Directory - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 10-Apr-2013***

Symptoms

Running remtool -asrsetup, it fails with:

------------------------------------------------------------------------------
ASR setup has failed.
DBREP1.WORLD : ORA-04052: error occurred when looking up remote object ODS.DS_A
TTRSTORE@DBREP2.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-12154: TNS:could not resolve the connect identifier specified


Connect to DB using sqlplus is successful

sqlplus ods@dbrep1
sqlplus ods@dbrep1.world
sqlplus ods@dbrep2
sqlplus ods@dbrep2.world



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