PROBLEM:

Encounter the following error when running autoconfig on the Application  Tier.

ERROR:

Updating s_tnsmode to ‘generateTNS’
UpdateContext exited with status: 0
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
ERRORCODE = 2 ERRORCODE_END
.end std out.

SOLUTION:

There is no information in the table FND_NODES for the database node. Which means that autoconfig has not executed on the Database Tier.
First need to run autoconfig on the database tier to populate the database node values in FND_NODES table then run autoconfig on Application Tier.

please execute the following steps:

1. Loging to as oracle user and perform the below steps
sqlplus apps/$apps
exec fnd_conc_clone.setup_clean

2. Run autoconfig.sh on db node.

3. Run autocnfig.sh on apps node.