Saturday, August 3, 2013

Autoconfig was failing on with Invalid Host error

Today when I was running Autoconfig on R12.1.1, it was failing with following message,

  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/EBS/inst/apps/EBS_ebs1/admin/install             INSTE8_SETUP       1

AutoConfig is exiting with status 1

After looking in autoconfig log, found below error

Running Setup Process 2 of 7 for AD_TOP
Executing script in InstantiateFile:

script returned:
**************************************************** started at Thu Jan 19 15:05:17 IST 2012

SQL*Plus: Release - Production on Thu Jan 19 15:05:18 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
Application Id : 0
Profile Value  : EBS
Level Name: SITE
INFO           : Updated/created profile option value.

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Unique constraint error (00001) is OK if key already exists
Invalid Host
Invalid Host

ADD call failed with exit code 1

Trying to update information ...

Invalid Host
Invalid Host

UPDATE call failed with exit code 1
Updating parameters:  fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300
Invalid Host
Invalid Host

Updating parameters:  fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false fnd_jdbc_context_check=true
Invalid Host
Invalid Host

Updating parameters:  fnd_jdbc_plsql_reset=false
Invalid Host
Invalid Host

DBC generation failed with exit code 1

Updating Server Security Authentication
Invalid Host
java.sql.SQLException: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1 exiting with status 1
.end std out.

.end err out.

Server name was unresolvable due to which .dbc file wasn't generated under $FND_SECURE. In my case, it was issue with my server name which was unresolvable through DNS.

Check whether server name is resolvable / pingable and listed in either /etc/hosts file or in DNS Server (nslookup)

After correcting belonging entry in DNS, I could able to run autoconfig successfully.

Happy Reading !!!

Thanks, Manish

No comments:

Post a Comment