Tag Archives: adgentns

AC-50480: Internal error occurred: java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

Posted by on December 9, 2008 No comments

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

TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Posted by on September 22, 2008 No comments

Problem:

When running AutoConfig, it fails at 50% with the following error:

ERROR

ORA-12224: TNS:no listener

Solution:

Run the following, and then restart AutoConfig.

perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem

Reference:

Subject:  TNS Connectivity With Database Breaks After Running Autoconfig

Doc ID:  Note:377764.1

1020  unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

1021  . /u0/oracle/testappl/APPSTEST_ebusinesstest.env

1022  cd /u0/oracle/testora/iAS/appsoui/setup/

1023  perl OUIsetup.pl

1024  perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem

1025  cd /u0/oracle/testcomn/clone/bin/

1026  perl adcfgclone.pl appsTier