Oracle Connectivity
Posted: Tue Nov 15, 2005 11:42 pm
We recently went thru with an upgrade of Datastage from 7.1r2 to 7.5.1 with any issues. Connectivity to DB2 is seamless.
We now have to connect to Oracle9.2.0.1.0 as well
We have been facing problems with trying to connect to oracle from datastage
We have searched the forum for "like issues" - however have not had much succes with the connectivity
We can however connect to oracle thru the command prompt using the dsadm user
While right clicking on the Table Definition tree -> import Plug In Meta Definitions and then clicking on ORAOCI9 or ORAOCI we get the
"Unable to initialize plug-in:" error
same with actually using a ORACLE ENTERPRISE STAGE in a job
tnsping works fine too
Ours in a 64 bit AIX box with 64 bit Oracle installed
The following include the entries in the dsenv file
ORACLE_HOME=/home/oracle/OraHome1; export ORACLE_HOME
ORAHOME=/home/oracle/OraHome1; export ORAHOME
ORACLE_SID=trdm; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin; export PATH
LIBPATH=$LIBPATH:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib32:$ORACLE_HOME/rdbms/lib;export LIBPATH
and .profile entry for dsadm
.profile
LIBPATH=$LIBPATH:$ORACLE_HOME/lib:/usr/java14/lib:$ORACLE_HOME/lib
export ORACLE_SID=trdm
ORACLE_HOME=/home/oracle/OraHome1; export ORACLE_HOME
PATH=$PATH:/home/oracle/OraHome1/bin
I dont see any issues with the oracle installation - i believe we're going wrong in the dsenv file configs
Any ideas?
Thanks in advance
We now have to connect to Oracle9.2.0.1.0 as well
We have been facing problems with trying to connect to oracle from datastage
We have searched the forum for "like issues" - however have not had much succes with the connectivity
We can however connect to oracle thru the command prompt using the dsadm user
While right clicking on the Table Definition tree -> import Plug In Meta Definitions and then clicking on ORAOCI9 or ORAOCI we get the
"Unable to initialize plug-in:" error
same with actually using a ORACLE ENTERPRISE STAGE in a job
tnsping works fine too
Ours in a 64 bit AIX box with 64 bit Oracle installed
The following include the entries in the dsenv file
ORACLE_HOME=/home/oracle/OraHome1; export ORACLE_HOME
ORAHOME=/home/oracle/OraHome1; export ORAHOME
ORACLE_SID=trdm; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin; export PATH
LIBPATH=$LIBPATH:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib32:$ORACLE_HOME/rdbms/lib;export LIBPATH
and .profile entry for dsadm
.profile
LIBPATH=$LIBPATH:$ORACLE_HOME/lib:/usr/java14/lib:$ORACLE_HOME/lib
export ORACLE_SID=trdm
ORACLE_HOME=/home/oracle/OraHome1; export ORACLE_HOME
PATH=$PATH:/home/oracle/OraHome1/bin
I dont see any issues with the oracle installation - i believe we're going wrong in the dsenv file configs
Any ideas?
Thanks in advance