Problems with ODBC and OCI stages
Posted: 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
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