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

adchkcfg.sh utility

This script is useful to run the autoconfig in test mode for knowing changes that will effect after next autoconfig run.It generates both html and text reports for viewing the current and changed information once you run this utility. These files are divided into two parts and each one contains the following information.

Cfgcheck report contains,

AutoConfig Context File Changes

• It shows current AutoConfig Context File, the changed AutoConfig Context File, and a difference report

Service Group Status

• it shows Status of the Service Groups and corresponding Services. Eg: Root service, Web Application Services.

Changed Configuration Files

• It shows list of files which will be changed in the next normal AutoConfig execution and the difference report for each file

New Configuration Files

• It shows list of new files which will be created in the next normal AutoConfig execution

 Legend

•  It shows Legend and syntax translations

Run Check Config Utility on the Application Tier:

1> Run adchkcfg.sh

[ebspas@igrexandc002cn05 appl]$ adchkcfg.sh

Enter the full path to the Applications Context file:

/ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/appl/admin/IREBSPAS_ebspasportal1.xml

Enter the APPS password:

The log file for this session is located at: /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/log/04171603/adconfig.log

AutoConfig is running in test mode and building diffs...

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1

        Classpath                   : /ebspas/app/applmgr/IREBSPAS/comn/java/lib/appsborg2.zip:/ebspas/app/applmgr/IREBSPAS/comn/java/classes

        Using Context file          : /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603/IREBSPAS_ebspasportal1.xml

Context Value Management will now update the test Context file

        Updating test Context file...COMPLETED

        [ Test mode ]

        No uploading of Context File and its templates to database.

Testing templates from all of the product tops...

        Testing AD_TOP........COMPLETED

        Testing FND_TOP.......COMPLETED

        Testing ICX_TOP.......COMPLETED

        Testing MSC_TOP.......COMPLETED

        Testing IEO_TOP.......COMPLETED

        Testing BIS_TOP.......COMPLETED

        Testing AMS_TOP.......COMPLETED

        Testing CCT_TOP.......COMPLETED

        Testing WSH_TOP.......COMPLETED

        Testing CLN_TOP.......COMPLETED

        Testing OKE_TOP.......COMPLETED

        Testing OKL_TOP.......COMPLETED

        Testing OKS_TOP.......COMPLETED

        Testing CSF_TOP.......COMPLETED

        Testing IGS_TOP.......COMPLETED

        Testing IBY_TOP.......COMPLETED

        Testing JTF_TOP.......COMPLETED

        Testing MWA_TOP.......COMPLETED

        Testing CN_TOP........COMPLETED

        Testing CSI_TOP.......COMPLETED

        Testing WIP_TOP.......COMPLETED

        Testing CSE_TOP.......COMPLETED

        Testing EAM_TOP.......COMPLETED

        Testing FTE_TOP.......COMPLETED

        Testing ONT_TOP.......COMPLETED

        Testing AR_TOP........COMPLETED

        Testing AHL_TOP.......COMPLETED

        Testing OZF_TOP.......COMPLETED

        Testing IES_TOP.......COMPLETED

        Testing CSD_TOP.......COMPLETED

        Testing IGC_TOP.......COMPLETED

Differences text report is located at: /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603/cfgcheck.txt

        Generating Profile Option differences report...COMPLETED

Differences text report for the Database is located at: /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603/ProfileReport.txt

        Generating File System differences report......COMPLETED

Differences html report is located at: /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603/cfgcheck.html

Differences Zip report is located at: /ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603/ADXcfgcheck.zip

2> Go To Location $INST_TOP/admin/out/<Output Directory for the adchkcfg run>

Example for Above case :/ebspas/app/applmgr/IREBSPAS/inst/apps/IREBSPAS_ebspasportal1/admin/out/04171603

3> Look for Difference files

Differences file gets created with x_* . Example : x_httpd.conf

Difference Files in Internal

=============================

[ebspas@igrexandc002cn05 04171558]$ ls -lrt x_*

-rw-r--r-- 1 ebspas dba  8532 Apr 17 15:59 x_server.xml

-rw-r--r-- 1 ebspas dba 12170 Apr 17 15:59 x_oracle-webservices.xml

[ebspas@igrexandc002cn05 04171558]$

Difference Files in External

============================

[ebspas@igrexandc002cn05 04171603]$ ls -lrt x_*

-rw-r--r-- 1 ebspas dba  2392 Apr 17 16:03 x_adovars.env

-rw-r--r-- 1 ebspas dba   429 Apr 17 16:03 x_adconfig.txt

-rw-r--r-- 1 ebspas dba   836 Apr 17 16:03 x_adalldefaults.txt

-rw-r--r-- 1 ebspas dba  7817 Apr 17 16:03 x_url_fw.conf

-rw-r--r-- 1 ebspas dba  8515 Apr 17 16:03 x_server.xml

-rw-r--r-- 1 ebspas dba 12161 Apr 17 16:03 x_oracle-webservices.xml

-rw-r--r-- 1 ebspas dba  1235 Apr 17 16:03 x_httpd.conf

4> Check the differences in the difference file and resolve it.

Thank you,

Manish