Page 1 of 1
Oracle client version 0 is NOT supported.
Posted: Mon Jun 29, 2009 8:43 am
by capovilla
Who has seen this error when you try to view data in Oracle Enteprise stage?
>##E IIS-DSEE-TFOP-00020 11:40:22(005) <Oracle_Enterprise_8> Error occurred during initializeFromArgs().
>##E IIS-DSEE-TDOR-00578 11:40:22(006) <Oracle_Enterprise_8> Connect failed: Oracle client version 0 is NOT supported.
Any idea of what I can do to solve the error?
Posted: Mon Jun 29, 2009 8:58 am
by chulett
First thing you always need to mention for something like this is - is this the first time you are attempting to use the OE stage and it just doesn't work or have you used it successfully in the past and this is a new error? For the latter, does it occur in only one job or all jobs that use the stage?
Posted: Mon Jun 29, 2009 11:12 am
by capovilla
It is the first time we tried to use. Actually we are at the stage of the installation environment for Datastage.
We just do things like setar the paths of Oracle and DS_HOME in the datastage configuration files and the profile of the AIX environment.
So when entering the Datastage to test the connection using the OE stage presents this error when we view data.
Posted: Mon Jun 29, 2009 11:41 am
by chulett
OK. So you have an Oracle client installed on the DataStage server and you've made the required changes to the 'dsenv' file, yes? Can you post the changes that you made?
Posted: Mon Jun 29, 2009 2:40 pm
by capovilla
# Oracle
ORACLE_BASE=/usr/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0; export ORACLE_HOME
PATH=$PATH:$APT_ORCHHOME/bin:$ORACLE_HOME/bin; export PATH
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$LIBPATH
export LIBPATH
ulimit -d unlimited
ulimit -m unlimited
# ulimit -s unlimited
ulimit -f unlimited
ulimit -n 1024
Posted: Mon Jun 29, 2009 2:49 pm
by chulett
It may be a 32bit v. 64bit issue, see if you have a $ORACLE_HOME/lib32 directory (instead of just lib) and try that one instead if it exists.
Resolved
Posted: Tue Jun 30, 2009 8:09 am
by capovilla
Good Morning Chulett, could solve the problem. Actually executing a shell was missing from the installation of Oracle lib, which is install.liborchoracle.
(/usr/app/IBM/InformationServer/Server/DSComponents/install/install.liborchoracle)
Thank you for your attention.