Problem:
When running AutoConfig on database tier, the follow error appears in the log file:
======================================================= [ Config tool : /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl ] Command : /u0/oracle/testdb/9.2.0/Apache/perl/bin/perl -I /u0/oracle/testdb/9.2.0/Apache/perl/lib/5.00503:/u0/oracle/testdb/9.2.0/Apache/perl/lib/site_perl/5.005:/u0/oracle/testdb/9.2.0/appsutil/perl /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl PASSWORD contextfile=/u0/oracle/testdb/9.2.0/appsutil/TEST_ebusinesstest.xml Action : execute SCRIPT RETURNED: ####################################################### Generate Tns Names ####################################################### Using java command: /u0/oracle/testdb/9.2.0/jdk/bin/java JAVA_HOME : Java version : 1.3.1_11 Classpath : /u0/oracle/testdb/9.2.0/jdk/jre/lib/rt.jar:/u0/oracle/testdb/9.2.0/jdk/jre/lib/i18n.jar:/u0/oracle/testdb/9.2.0/jdk/lib/dt.jar:/u0/oracle/testdb/9.2.0/jdk/lib/tools.jar:/u0/oracle/testdb/9.2.0/jdbc/lib/classes12.jar:/u0/oracle/testdb/9.2.0/appsutil/java/xmlparserv2.zip:/u0/oracle/testdb/9.2.0/appsutil/java Loading ORACLE_HOME environment from /u0/oracle/testdb/9.2.0 Logfile: /u0/oracle/testdb/9.2.0/appsutil/log/TEST_ebusinesstest/04061541/NetServiceHandler.log AC-50480: Internal error occurred: 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 1097 ORA-06512: at line 1 Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates Instantiating templates tnsnames.ora instantiated listener.ora instantiated adgentns.pl exiting with status 2 ERRORCODE = 2 ERRORCODE_END
Solution:
To implement the solution, please execute the following steps:
1. Be sure to have a valid backup.
2. Open an environment shell and set the Applications Environment
3. cd $AD_TOP/bin
4. perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem
5. Open a new shell and set the Database Environment
6. Run adconfig at the dbTier
7. Open a new shell and set the Applications Environment and also run autoconfig at the appsTier
Subject: Autoconfig Fails with:ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated
Doc ID: 416182.1
0 Comments.