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

Metalink id:

During Autoconfig "adgentns.pl" fails: "AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora" [ID 453901.1]

Symptoms*:=

When attempting to run autoconfig, the following error occurs in apps tier:

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.


[CVM Error Report]
The following report lists errors encountered during CVM Phase

/u01/erpapp/appl/ad/12.0.0/bin/adgentns.pl 2
No of scripts failed in CVM phase: 1

Cause:

The issue can occur if the wrong "NODE_NAME"  value exists in the "FND_NODES" table.

Solution:

fnd_nodes contains production entries,connect to database as apps schema and run below which will clear
fnd_nodes entries and run autoconfig db tier and then apps tier.

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

SQL> select node_name from fnd_nodes;

no rows selected

SQL>

Running autoconfig on dbtier
=========================
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Running autoconfig on apps tier
==========================

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

SQL> select node_name from fnd_nodes;

           ebsdev

          appdev