connecting DS 7.5 to ORACLE 10G
Posted: Thu Sep 24, 2009 7:49 am
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
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