We have just installed Ds v8 on a Itanium HP-UX machine, and everything works ok but oracle connectivity. This is the error we are being returned:
Code: Select all
##I IIS-DSEE-TFCN-00001 14:18:54(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4706
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 14:18:54(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 14:18:54(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 14:18:55(000) <main_program> Parameter specified but not used in flow: _APT_ORCHHOME
##W IIS-DSEE-TOSH-00049 14:18:55(001) <main_program> Parameter specified but not used in flow: _PATH
##W IIS-DSEE-TOSH-00049 14:18:55(002) <main_program> Parameter specified but not used in flow: _LD_LIBRARY_PATH
##W IIS-DSEE-TOSH-00049 14:18:55(003) <main_program> Parameter specified but not used in flow: _ORACLE_SID
##W IIS-DSEE-TOSH-00049 14:18:55(004) <main_program> Parameter specified but not used in flow: _ORACLE_HOME
>##E IIS-DSEE-TOSH-00205 14:18:55(005) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 14:18:55(006) <main_program> Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'..
>##E IIS-DSEE-TOSH-00384 14:18:55(007) <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 IIS-DSEE-TCOS-00029 14:18:55(008) <main_program> Creation of a step finished with status = FAILED.
We tried this that we found it on a post
After following the suggestions provided in this post, I created a new link to the existing libclntsh.so.10.1 library, named libclntsh.so.9.0.
Code:
$ pwd
/oracle/v1020/lib
$ ln -s libclntsh.so.10.1 libclntsh.so.9.0
$ ls -l libclntsh.so*
lrwxrwxrwx 1 oracle dba 17 Feb 4 14:14 libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle dba 18762364 Feb 4 14:14 libclntsh.so.10.1
lrwxrwxrwx 1 oracle dba 17 Apr 25 13:30 libclntsh.so.9.0 -> libclntsh.so.10.1
I can also confirm that creating this link under $DSHOME/lib (versus $ORACLE_HOME/lib) also resolved my issue.
for example:
Code:
$ pwd
/vend/IBM/InformationServer/Server/DSEngine/lib
$ ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so.9.0
But it did not help neither
I added to my job these variables:
Code: Select all
APT_ORCHOME:/oradata/OWBDIB/is/Server/PXEngine
PATH: /oradata/OWBDIB/is/Server/PXEngine/bin:/app/oracle/product/10.2.0/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/aCC/bin:.
LD_LIBRARY_PATH: /app/oracle/product/10.2.0/lib:/usr/lib
ORACLE_SID: OWBBD
ORACLE_HOME: /app/oracle/product/10.2.0
Any help will be so much appreciated.....