TriniDBA

Problem: When running AutoConfig on the application tier, AutoConfig completes in error. Checked adconfig.log file:

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2

Solution: Disable IPV6 from Local Area Network connection and retry AutoConfig on apps tier

Other solutions tried:

1. Clean FND_NODES table and rerun AutoConfig.

perl D:\ORACLE\PROD\apps\apps_st\appl\ad\12.0.0\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\inst\apps\PROD_testsrv2\appl\admin\PROD_testsrv2.xml –removeserver
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml -removeserver
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
cd D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\scripts\PROD_testsrv2
adautocfg.cmd
cd D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\scripts
adautocfg.cmd

May need to shutdown database and restart it.

Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315\adconfig.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315/NetServiceHandler.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install\admk80ln.sql