Autoconfig Error : adgentns.pl exiting with status 2

Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh

Below is the error I found in autoconfig logfile

##########################################################################
                   Generate Tns Names
##########################################################################
Logfile:  /u01/oracle/DEVDB1/inst/apps/DEVDB1_oruatap1/admin/log/09260224/NetServiceHandler.log
        Classpath                   : /u01/oracle/DEVDB1/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/oracle/DEVDB1/apps/apps_st/comn/java/classes

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.

.end err out.


   Result             : FAILED
-----------------
 
[CVM Error Report]
The following report lists errors encountered during CVM Phase
       
  /u01/oracle/DEVDB1/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl  2

No of scripts failed in CVM phase: 1


AutoConfig is exiting with status 1

AutoConfig execution completed on Thu Sep 26 02:26:41 2013

Time taken for AutoConfig execution to complete : 2 mins  27 secs

Solution:

1. Clean fnd_concurrent_queues
2. Follow MOS ID 453901.1

Clean fnd_concurrent_queues

SQL> select unique(node_name) from fnd_concurrent_queues;

NODE_NAME
------------------------------
PRODAPP1
PRODAPP2
DEVAPP1

Replace the Source Node Values with Target Values

SQL> update fnd_concurrent_queues set node_name='DEVAPP1' where node_name='PRODAPP1';

1 row updated.

SQL> update fnd_concurrent_queues set node_name='DEVAPP2' where node_name='PRODAPP2';

2 rows updated.

SQL> commit;

Follow MOS ID 453901.1

APPLIES TO:

Oracle Applications Manager - Version 12.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 20-Dec-2012

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

This issue is addressed in the unpublished Bug 5592152 -  "ARE120.13:OAM:APPS LISTENER FAILS TO COME UP AFTER R12 INSTALL".

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

SOLUTION

1. Open a new shell and source the APPS Environment. ($APPL_TOP/APPS_.env)

2. Start "sqlplus" and execute following commands :

$ sqlplus apps/
SQL> exec fnd_conc_clone.setup_clean

3. Open a new terminal or shell and source the DB-Tier Environment. ($ORACLE_HOME/.env)

4. Execute Autoconfig on the DB Tier. ($ORACLE_HOME/appsutil/bin/adconfig.sh)

5. Switch back to the APPS environment or start a new shell and source the APPS environment.

6. Execute Autoconfig at the Apps Tier. ($AD_TOP/bin/adconfig.sh)

7. Check the Autoconfig log for any errors and ensure that the services start correctly.