My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2019

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.
<DB_NAME1>.<DOMAIN> : ORA-04052: error occurred when looking up remote object ODS.DS_ATTRSTORE@<DB_NAME1>.<DOMAIN>
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@<DB_NAME1>
sqlplus ods@<DB_NAME1>.<DOMAIN>
sqlplus ods@<DB_NAME2>
sqlplus ods@<DB_NAME2>.<DOMAIN>



Cause

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
Symptoms
Cause
Solution

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