Problems with ODBC and OCI stages

yaminids · Post by **yaminids** » Wed Nov 28, 2007 2:26 am

Hello friends,

Recently I have built a new Linux with DataStage 7.5 and imported jobs from a different server.

After compiling the jobs and updating all the environment variables, some of the jobs with ODBC and OCI stages are failing with the following error

DSD.BCIConnect connecting to ORDDB, call to SQLConnect failed.
SQLSTATE=08001, DBMS.CODE=12537
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12537: TNS:connection closed

I was able to connect to the db from the server without any problems but I am not sure why DataStage jobs are failing.
After re-compiling the jobs they run the first time but fail if I try to execute them multiple times

Did I miss configuring some important files?

Any help would be highly appreciated
Yamini

WoMaWil · Post by **WoMaWil** » Wed Nov 28, 2007 8:08 am

DataStage is a user on the server as yourself.

You have probably the nessary parameters for connection in your .profile.

DataStage has them in its dsenv-file.

Go and compare an restart DataStage.

For ODBC you have to configure the resp. ini-files.

Look into the manual for details.