Autoconfig Fails with:ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated (Doc ID 416182.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Applications 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 at 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

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