It seems a recurrent problem according to the vast amount of threads dealing with the subject, unfortunately, none of them gave me the solution
I'm using a DataStage server 7.5.1.1 on HP-UX 11.11.
I'm having an error when trying to read data from Oracle (9.2.0.6). The Oracle server is on another machine, however, it was previously on the same server, and, Oracle is still installed.
For information, I'm able to connect using sqlplus for example.
Here is an extract from the log I get:
Code: Select all
9 INFO 2009-09-03 10:34:09 main_program: orchgeneral: loaded
- orchsort: loaded
- orchstats: loaded
10 INFO 2009-09-03 10:34:10 main_program: APT configuration file:
[...]
11 FATAL 2009-09-03 10:34:10 main_program: PATH search failure:
12 FATAL 2009-09-03 10:34:10 main_program: Error loading "orchoracle": Could not load
- "orchoracle": Unresolved external
- 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
The PATH I can see into the job's log is set as following:
Code: Select all
/product/datastage/Ascential/DataStage/Projects/TRAP/wrapped
/product/datastage/Ascential/DataStage/Projects/TRAP/buildop
/product/datastage/Ascential/DataStage/Projects/TRAP/RT_BP368.O
/product/datastage/Ascential/DataStage/DSCAPIOp
/product/datastage/Ascential/DataStage/RTIOperators
/product/datastage/Ascential/DataStage/DSParallel
/product/datastage/Ascential/DataStage/PXEngine/user_osh_wrappers
/product/datastage/Ascential/DataStage/PXEngine/osh_wrappers
/usr/bin
/usr/ccs/bin
/usr/contrib/bin
/opt/hparray/bin
/opt/nettladm/bin
/opt/upgrade/bin
/opt/fcms/bin
/opt/pd/bin
/opt/resmon/bin
/opt/perf/bin
/opt/ignite/bin
/usr/contrib/bin/X11
/usr/bin/X11
/usr/sbin/diag/contrib
/opt/perl/bin
/opt/prm/bin
/opt/mx/bin
/opt/wbem/bin
/opt/wbem/sbin
/opt/graphics/common/bin
/opt/networker/bin
/opt/aCC/bin
/opt/langtools/bin
.
/product/datastage/Ascential/DataStage/DSEngine/bin
/product/datastage/Ascential/DataStage/PXEngine/bin
/product/oracle/moteur/9.2.0-64b/bin
/usr/bin
/product/datastage/Ascential/DataStage/DSEngine/bin
/product/datastage/Ascential/DataStage/PXEngine/bin
/product/oracle/moteur/9.2.0-64b/bin
/usr/local/bin
Code: Select all
/product/datastage/Ascential/DataStage/Projects/TRAP/RT_BP368.O
/product/datastage/Ascential/DataStage/DSCAPIOp
/product/datastage/Ascential/DataStage/RTIOperators
/product/datastage/Ascential/DataStage/DSParallel
/product/datastage/Ascential/DataStage/PXEngine/user_lib
/product/datastage/Ascential/DataStage/Projects/TRAP/buildop
/product/datastage/Ascential/DataStage/branded_odbc/lib
/product/datastage/Ascential/DataStage/DSEngine/lib
/product/datastage/Ascential/DataStage/DSEngine/uvdlls
/product/datastage/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC2.0
/product/datastage/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC2.0/hotspot
/product/datastage/Ascential/DataStage/PXEngine/lib
/product/datastage/Ascential/DataStage/PXEngine/lib
/product/oracle/moteur/9.2.0-64b/lib32
/usr/lib
/lib
Code: Select all
/product/datastage/Ascential/DataStage/PXEngine.7501.1/install # echo $APT_ORCHHOME
APT_ORCHHOME=/product/datastage/Ascential/DataStage/PXEngine
/product/datastage/Ascential/DataStage/PXEngine.7501.1/install # echo $ORACLE_HOME
ORACLE_HOME=/product/oracle/moteur/9.2.0-64b
/product/datastage/Ascential/DataStage/PXEngine.7501.1/install # install.liborchoracle
Installing Oracle driver
Using /product/oracle/moteur/9.2.0-64b as ORACLE_HOME
Installing driver for Oracle Version 9i
Oracle installation is complete.