Page 1 of 1

Eror While running job using oracle enterprise stage

Posted: Thu Dec 07, 2006 7:23 am
by syam
Hi All

I am getting following error while running the oracle enterprise stage.

##E TOSH 000205 18:54:43(000) <main_program> PATH search failure:
##E TOSH 000000 18:54:43(001) <main_program> Error loading "orchoracle": Could not load "orchoracle": ld.so.1: /export/home/dsadm/Ascential/DataStage/PXEngine.752.1/bin/osh: fatal: libclntsh.so: open failed: No such file or directory.
##E TOSH 000000 18:54:43(002) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 18:54:43(003) <main_program> Creation of a step finished with status = FAILED.

Thanks for your help in advance

Posted: Thu Dec 07, 2006 7:47 am
by ray.wurlod
Search the forum to see whether anyone has had this problem in the past and whether there's a solution offered.

Check your PATH and LD_LIBRARY_PATH environment variables to make sure that the DataStage and Oracle libraries are findable.