Error loading "orchoracle": Could not load...

[senga]

Hi,

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

I must say I compare the server I'm working on with it's production version (which is working of course). PATH and SHLIB_PATH are the same (well, almost, but the differences has nothing to do with Oracle or DataStage).

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

And SHLIB_PATH is:

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

I already tried to reinstall oracle drivers:

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.

Any idea?

[senga]

Alright, I think I solved this one.

Apparently, a patch have been applied on the server which was not working (patch 633561 for information).
Unfortunately for me, it was not present into neither /product/datastage/Ascential/patches nor /product/datastage/patches, so I missed it...

Actually, I found a thread on IBM's forum where someone was talking about something about a library (liborchcommondbhpux.sl I think). I compared version from both server and saw they were different. After a few more research, I finally found the patch somewhere on the server, get the 4 files that were in the root folder from my production server, copied them into the other server, and restarted everything.

And now, it seems to be ok

Thanks.