R12: adgentns.pl fails with AC-50480: Internal error occurred: java.lang.Exception: Error while generating

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

Applies to:

Oracle Applications Manager - Version: 12.0.2
Information in this document applies to any platform.
Checked for relevance on 02-FEB-2010

Symptoms

When attempting to run autoconfig, the following error occurs :
...
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 512
ERRORCODE = 512 ERRORCODE_END
...

Cause

Same issue is addressed in non-public Bug 5592152 -  'ARE120.13:OAM:APPS LISTENER FAILS TO COME UP AFTER R12 INSTALL'.

Issue seems to be occurring due to wrong node_name values in fnd_concurrent_queues table.

Solution

To implement the solution, please execute the following steps :

1. Open a new shell and source the APPS Environment.

2. Start the sqlplus Utility and execute following commands :

sqlplus apps/<Password>
exec fnd_conc_clone.setup_clean

3. Open a new shell and source the DB-Tier Environment.

4. Execute Autoconfig at the DB-Tier.

5. Switch to the Shell with the APPS Enviornment sourced or start a new Shell and source the APPS Environment.

6. Execute Autoconfig at the APPS-Tier.

7. Retest the Services startup.