OCI9 fails to Initialize
Posted: Mon Aug 30, 2004 1:02 pm
Hi all,
Even though my dsenv contains all the needed environment variables and I have added the Oracle libs to the LD_LIBRARY_PATH in the Projects
Environment Variables tab and my Oracle client works fine from the command line, the following Odd behavior exists:
When attempting to Import a Plug-In table defination, the 'Unable to Initialize Plug-In' message appears.
Whe running a job that uses the Plug_In, however, the job runs fine!
If I try, in designer, to view the data in the OCI-referenced table, I get the
following:
ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so: cannot open shared object file: No such file or directory
But..if I validate the job, the env variables section says:
Environment variable settings:
DSHOME=/ds/Ascential/DataStage/DSEngine
CONSOLE=/dev/console
TERM=
SHELL=/bin/bash
USER=dsadm
LD_LIBRARY_PATH=/ds/Ascential/DataStage/DSEngine/../branded_odbc/lib:/ds/Ascential/DataStage/DSEngine/lib:/ds/Ascential/DataStage/DSEngine/uvdlls:/ds/Ascential/DataStage/DSEngine/java/jre/lib/i386/client:/ds/Ascential/DataStage/DSEngine/java/jre/lib/i386::/usr/lib:.:/ds/Ascential/DataStage/branded_odbc/lib:/eo/OraHome1/lib
INIT_VERSION=sysvinit-2.85
APT_ORCHHOME=
PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin:/usr/local/bin:.:/eo/OraHome1/bin
runlevel=3
RUNLEVEL=3
PWD=/ds/Ascential/DataStage/DSEngine
LANG=en_US.UTF-8
previous=N
PREVLEVEL=N
SHLVL=4
HOME=/home/dsadm
ODBCINI=/ds/Ascential/DataStage/DSEngine/.odbc.ini
UDTHOME=/ds/Ascential/DataStage/ud41
UDTBIN=/ds/Ascential/DataStage/ud41/bin
LOGNAME=dsadm
DS_USERNO=-5728
WHO=prod75
BELL=^G
FLAVOR=-1
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
TNS_ADMIN=/eo/OraHome1/network/admin
ORACLE_HOME=/eo/OraHome1
And, the Job runs just fine..
It appears that the Director 'knows' about the varibles but somehow Designer does not.
Tech support is working to resolve this, but if any of you have ideas, please post.
Its very confusing..
John G
Even though my dsenv contains all the needed environment variables and I have added the Oracle libs to the LD_LIBRARY_PATH in the Projects
Environment Variables tab and my Oracle client works fine from the command line, the following Odd behavior exists:
When attempting to Import a Plug-In table defination, the 'Unable to Initialize Plug-In' message appears.
Whe running a job that uses the Plug_In, however, the job runs fine!
If I try, in designer, to view the data in the OCI-referenced table, I get the
following:
ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so: cannot open shared object file: No such file or directory
But..if I validate the job, the env variables section says:
Environment variable settings:
DSHOME=/ds/Ascential/DataStage/DSEngine
CONSOLE=/dev/console
TERM=
SHELL=/bin/bash
USER=dsadm
LD_LIBRARY_PATH=/ds/Ascential/DataStage/DSEngine/../branded_odbc/lib:/ds/Ascential/DataStage/DSEngine/lib:/ds/Ascential/DataStage/DSEngine/uvdlls:/ds/Ascential/DataStage/DSEngine/java/jre/lib/i386/client:/ds/Ascential/DataStage/DSEngine/java/jre/lib/i386::/usr/lib:.:/ds/Ascential/DataStage/branded_odbc/lib:/eo/OraHome1/lib
INIT_VERSION=sysvinit-2.85
APT_ORCHHOME=
PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin:/usr/local/bin:.:/eo/OraHome1/bin
runlevel=3
RUNLEVEL=3
PWD=/ds/Ascential/DataStage/DSEngine
LANG=en_US.UTF-8
previous=N
PREVLEVEL=N
SHLVL=4
HOME=/home/dsadm
ODBCINI=/ds/Ascential/DataStage/DSEngine/.odbc.ini
UDTHOME=/ds/Ascential/DataStage/ud41
UDTBIN=/ds/Ascential/DataStage/ud41/bin
LOGNAME=dsadm
DS_USERNO=-5728
WHO=prod75
BELL=^G
FLAVOR=-1
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
TNS_ADMIN=/eo/OraHome1/network/admin
ORACLE_HOME=/eo/OraHome1
And, the Job runs just fine..
It appears that the Director 'knows' about the varibles but somehow Designer does not.
Tech support is working to resolve this, but if any of you have ideas, please post.
Its very confusing..
John G