Oracle client version 0 is NOT supported.

[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?

[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?

[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.

[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?

[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

[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.

[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.