java.sql.SQLException while registering Ebiz with SSO

Hi
Recently while trying to integrate an EBiz R12 instance with OID for Single Sign On functionality we hit an while running the following command:
$FND_TOP/bin/txkrun.pl -script=SetSSOReg -registersso=yes -appspass=apps
Fri Jun 11 03:47:39 PDT 2010 =========================================
Fri Jun 11 03:47:39 PDT 2010 OracleAS Single Sign-On Registration Tool
Fri Jun 11 03:47:39 PDT 2010 =========================================
Fri Jun 11 03:47:39 PDT 2010 Parameters passed to SSO registration tool :
param0:-oracle_home_path
param1:/cdv1001/apps/tech_st/10.1.3
param2:-site_name param
3:http://sord142.corp.com:8010
param4:-config_mod_osso param
5:true param6:-logout_url param7:http://sord142.corp.com:8010/OA_HTML/AppsLogoutSSO
param8:-home_url
param9:http://sord142.corp.com:8010
param10:-config_file param11:/cdv1001/inst/apps/cdv_sord142/ora/10.1.3/Apache/Apache/conf/osso/cdv_sord142_osso.conf param12:-update_mode
param13:CREATE
param14:-success_url
param15:http://sord142.corp.com:8010/osso_login_success
param16:-cancel_url
param17:http://sord142.corp.com:8010
Fri Jun 11 03:47:39 PDT 2010 -DinstallType=
Fri Jun 11 03:47:39 PDT 2010 -DoldOracleHome=Fri Jun 11 03:47:39 PDT 2010 -DoldOHSUser=root
Fri Jun 11 03:47:39 PDT 2010 SSO database is jdbc:oracle:thin:@ldap://ldap-imdvrdc.domain.com:3051/idmdvrdc,cn=oraclecontext
Fri Jun 11 03:47:40 PDT 2010 Exception while creating database connection :java.sql.SQLException: Io exception: The Network Adapter could not establish the connectionjava.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:361) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at oracle.security.sso.SSORegistrar.main(SSORegistrar.java:327)Fri Jun 11 03:47:40 PDT 2010 Check if your database is up and running.

Fix:
The database was up and running and there were no issues. However, in this case, the ebiz server was in a different domain than that of our OID environment and we had opened specific ports between the environments to allow access to the OID servers. When we performed telnet test on database listener port, everything was fine. However, when trying to register the error was showing up.

Further investigation revealed that oraclecontext was was pointing to database name instead of databasename.domain.com. In our telnet tests we were using fully qualified hostname to test the access. To over come this issue, we put an entry in /etc/hosts of the web server of ebiz environment as follows:

123.45.67.89 dvdb.domain.com dvdb

In the above entry, first entry is the IP address of the database host of the OID and subsequent entries are the databasehost.domain.com and databasehost values.

This resolved the issue.

- Aravind Kamath Posral