DataDeploy failure

Rajesh

Hello techies,

 

I am facing problem with data deploy. My connection to databaseis refused with database.

 

Win 2008 R2

TS - 7.4.1

OD - 7.4.1

Database: Oracle 11g

 

Here is the error I am seeing in the logs.

 

DBD: Connecting to the database...
DBD: Try connecting using jdbcracle:thin:@//hostname.com:1521/service_name...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbcracle:thin:@//hostname.com:1521/service_name]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=0)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=IP of DB server)(PORT=1521))'))(ERROR=(CODE=305)(EMFI=1))))
DBD: Vendor Error Code: 17002
DBD: SQL state: null
DBD: *******************************************************

 

Here are the options I have tried so far:

1) Tested connectivity from TeamSite/OD server to database on the connection port.

2) Created a test java class on TeamSite server to check if I get a connection object. I could connect to the database using ojdbc6.jar. However, connection fails if I use ojdbc14.jar

3) I stopped OD and removed ojdbc14.jar and placed ojdbc6.jar, started OD but the DD deployments are still failing.

4) However, same works fine on 7.2.1 environment.

 

Any suggestion will be appreciated.

 

Thanks

Rajesh

Rajesh

Finally,I figured it out. I didn't remove the ojdbc14.jar from ODHOME/userlib. Not sure if it was copied by someone or shipped OOTB with OD.

 

Not sure why OD contains incopatible jars with the jre version it ships with. Anyways, I removed the ojdbc14.jar from ODHOME/drivers and ODHOME/userlib . Restarted OD and now it's able to connect to database.

 

--Rajesh