Your Doorstep to the Temple of Oracle

Oracle EBS

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

Posted by appsdba11i on October 16, 2011

Hi Folks

Recently we cloned Test from PROD and when we run autoconfig on MT Node We got Below Error

Error Message
—————————————————-
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.
—————————————————-

Cause/Issue Identification

There is no database node declared in the FND_NODES table or fnd_nodes Having some source informaton or Incorrect Values

Resolution
============

1. Take Backup if its Necessary

2. Execute the following query as connecting as apps user

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.

Action Done in MY Case :
—————————–
SQL> select name,user from v$database;

NAME USER
——— ——————————
TESTDB APPS

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;
Commit complete.

Its resolved my issue and Autoconfig went successfully after this action.

Reference/Useful notes:
========================
AC-50480″ Error Generating the “listener.ora” File. [ID 1089036.1]
During Autoconfig “adgentns.pl” fails: “AC-50480: Internal error occurred: java.lang.Exception:
Error while generating listener.ora” [ID 453901.1]

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: