autoconfig oracle,EBS Autoconfig 报AC-50480: Internal error occurred: java.lang.Exce

今天在EBS 做autoconfig 时报以下错误

CVM Error Report]

The following report lists errors encountered during CVM

Phase

/zlobsdev_data1/appsit2/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 Sun Jul 14 08:32:28 2013

Time taken for AutoConfig execution to complete : 4 mins 17

secs

执行adgentns.pl

bash-3.00$

/zlobsdev_data1/appsit2/apps_st/appl/ad/12.0.0/bin/adgentns.pl

contextfile=/zlobsdev_data1/appsit2/inst/apps/OBSSIT2_zlobssit2/appl/admin/OBSSIT2_zlobssit2.xml

appspass=appdemo

##########################################################################

Generate Tns Names

##########################################################################

Logfile:

/zlobsdev_data1/appsit2/inst/apps/OBSSIT2_zlobssit2/admin/log/07140833/NetServiceHandler.log

Classpath :

/zlobsdev_data1/appsit2/apps_st/comn/java/lib/appsborg2.zip:/zlobsdev_data1/appsit2/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

查metalink

During Autoconfig "adgentns.pl" fails: "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 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.

按照文档的步骤执行

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

在数据库层执行AUTOCONFIG

-bash-3.00$ adconfig.sh

Enter the full path to the Context file:

/zlobsdev_data1/orasit2/oracle/product/1110/appsutil/OBSSIT2_zlobssit2.xml

Enter the APPS user password:

The log file for this session is located at:

/zlobsdev_data1/orasit2/oracle/product/1110/appsutil/log/OBSSIT2_zlobssit2/07140854/adconfig.log

AutoConfig is configuring the Database environment…

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location :

/zlobsdev_data1/orasit2/oracle/product/1110

Classpath :

:/zlobsdev_data1/orasit2/oracle/product/1110/jdbc/lib/ojdbc6.jar:/zlobsdev_data1/orasit2/oracle/product/1110/appsutil/java/xmlparserv2.jar:/zlobsdev_data1/orasit2/oracle/product/1110/appsutil/java:/zlobsdev_data1/orasit2/oracle/product/1110/jlib/netcfg.jar:/zlobsdev_data1/orasit2/oracle/product/1110/jlib/ldapjclnt11.jar

Using Context file :

/zlobsdev_data1/orasit2/oracle/product/1110/appsutil/OBSSIT2_zlobssit2.xml

Context Value Management will now update the Context file

Updating Context file…COMPLETED

Attempting upload of Context file and templates to

database…COMPLETED

Updating rdbms version in Context file to db111

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME …

AutoConfig completed successfully.

在应用层执行AUTOCONFIG成功

bash-3.00$ adautocfg.sh

Enter the APPS user password:

The log file for this session is located at:

/zlobsdev_data1/appsit2/inst/apps/OBSSIT2_zlobssit2/admin/log/07140858/adconfig.log

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location :

/zlobsdev_data1/appsit2/inst/apps/OBSSIT2_zlobssit2

Classpath :

/zlobsdev_data1/appsit2/apps_st/comn/java/lib/appsborg2.zip:/zlobsdev_data1/appsit2/apps_st/comn/java/classes

Using Context file :

/zlobsdev_data1/appsit2/inst/apps/OBSSIT2_zlobssit2/appl/admin/OBSSIT2_zlobssit2.xml

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.