AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [ID 1324667.1]
		Modified 26-MAY-2011     Type PROBLEM     Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution

---

Applies to:

Oracle Application Install - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

When running autoconfig on the application Tier,
the following error occurs.

Error
##########################################################################
Generate Tns Names
##########################################################################

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.

Cause

There is no information in the table FND_NODES for the database node.
This means that autoconfig has not been executed in the database tier or there was a problem
when it was executed in the database tier
.
So you need to run autoconfig on the database tier to gather the information.


There is no database node declared in the FND_NODES table

Solution

To implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Clean the Data Topology Model
Sqlplus apps/...
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;

3. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers, to repopulate the required system tables