Page 1 of 1

connecting DS 7.5 to ORACLE 10G

Posted: Thu Sep 24, 2009 7:49 am
by mohamed3500
I have a problem of receiving error:
main_program: PATH search failure: [sil\step_il.C:1330] and

main_program: Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found. [api\opreg.C:277]
Could not locate operator definition, wrapper, or Unix command for "orawrite"; please check that all needed libraries are preloaded, and check the PATH for the wrappers [sil\step_il.C:587]


I am using ORACLE 10G and DS 7.5 in the same machine (Windows XP SP2)

I made a modification for windows environment variable :PATH and LIB
as following
Path=;D:\Ascential\DataStage\PXEngine\bin;C:\oracle\product\10.2.0\db_1\bin;

and
LIB=;D:\Ascential\DataStage\PXEngine\lib;C:\oracle\product\10.2.0\db_1\LIB

And I added environment parameters inside DS
$ORACLE_HOME=C:\oracle\product\10.2.0\db_1
$ORACLE_SID=ORCL
$APT_ORCHHOME=D:/Ascential/DataStage/PXEngine


SO Please anybody have any idea of this please reply

Posted: Thu Sep 24, 2009 7:56 am
by chulett
Unless this is specifically the 7.5x2 version (note the 'x') you'll never get it running jobs on Windows. Never mind the fact that XP is not a supported O/S.

Posted: Thu Sep 24, 2009 8:07 am
by mohamed3500
chulett wrote:Unless this is specifically the 7.5x2 version (note the 'x') you'll never get it running jobs on Windows. Never mind the fact that XP is not a supported O/S. ...
But I am using DataStage V.7.5x2

You mean that I will not be able to excecute my Stage Job using this version on windows

Posted: Thu Sep 24, 2009 8:10 am
by chulett
No, re-read my message, 7.5x2 is the only version (before 8) that will run PX jobs on Windows. Just wanted to make sure there was a point to all this.