My Oracle Support Banner

E-Business Suite Applications Technology Stack Autoconfig Script Adgentns.pl Fails On The Database Node With Error 'ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated' (Doc ID 416182.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

When attempting to run autoconfig on the Database Environment the following error occur while running $RDBMS_HOME/appsutil/bin/adgentns.pl:

Loading ORACLE_HOME environment from $RDBMS_HOME
Logfile: $RDBMS_HOME/appsutil/log/<CONTEXT_NAME>/../NetServiceHandler.log
java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated java.sql.SQLException: ORA-00001:
unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

ORA-06512: at "APPS.FND_APP_SYSTEM", line 931
ORA-06512: at "APPS.FND_NET_SERVICES", line 399
ORA-06512: at "APPS.FND_NET_SERVICES", line 675
ORA-06512: at "APPS.FND_NET_SERVICES", line 1099ORA-06512: at line 1


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!


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