Autoconfig was failing on adgendbc.sh with Invalid Host error

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

  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/EBS/inst/apps/EBS_ebs1/admin/install
      adgendbc.sh             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:
/u01/app/oracle/EBS/inst/apps/EBS_ebs1/admin/install/adgendbc.sh

script returned:
****************************************************

adgendbc.sh started at Thu Jan 19 15:05:17 IST 2012


SQL*Plus: Release 10.1.0.5.0 - 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.
[ APPS_DATABASE_ID ]
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 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Params=fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false


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
adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

Cause:
-------
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.

Solution:
-----------
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