Unable to initialize the plug-in for ORAOCI9
Posted: Sat Jul 26, 2003 8:18 am
Dear All,
I am using DataStage 6.0.1 on Sun Solaris UNIX machine. The Oracle 9i database server is also in the same machine as the DataStage server.
I have made the following changes in the dsenv file and when tried to import the table definitions from the Oracle 9i server using the "pluginMetaDataDefinitions->ORAOCI9" option it gave the following error message.
"Unable to initialize the plug-in".
#############################################################################
# PLATFORM SPECIFIC SECTION
#ORACLE_HOME=/soft/app/oracle/product/8.1.7
ORACLE_HOME=/project7/ora920/app/oracle/product/9.2.0
export ORACLE_HOME
#ORAHOME=/soft/app/oracle/product/8.1.7
ORAHOME=/project7/ora920/app/oracle/product/9.2.0
export ORAHOME
ORACLE_SID=targfin1
ORASID=targfin1
export ORACLE_SID ORASID
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
#############################################################################
Note: The oracle 9i client is installed on the DataStage server machine. I have also restarted the server after making these changes.
But, the same is working fine when the corresponding entries in dsenv file are pointing to oracle 8i client.
Could somebody help me on this issue? Also, should the oracle 9i client's version same as that of oracle 9i server? (I mean the server is 9.2.0.2 and the client is 9.2.0.3)
Thanks in advance.
Srinivas.
I am using DataStage 6.0.1 on Sun Solaris UNIX machine. The Oracle 9i database server is also in the same machine as the DataStage server.
I have made the following changes in the dsenv file and when tried to import the table definitions from the Oracle 9i server using the "pluginMetaDataDefinitions->ORAOCI9" option it gave the following error message.
"Unable to initialize the plug-in".
#############################################################################
# PLATFORM SPECIFIC SECTION
#ORACLE_HOME=/soft/app/oracle/product/8.1.7
ORACLE_HOME=/project7/ora920/app/oracle/product/9.2.0
export ORACLE_HOME
#ORAHOME=/soft/app/oracle/product/8.1.7
ORAHOME=/project7/ora920/app/oracle/product/9.2.0
export ORAHOME
ORACLE_SID=targfin1
ORASID=targfin1
export ORACLE_SID ORASID
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
#############################################################################
Note: The oracle 9i client is installed on the DataStage server machine. I have also restarted the server after making these changes.
But, the same is working fine when the corresponding entries in dsenv file are pointing to oracle 8i client.
Could somebody help me on this issue? Also, should the oracle 9i client's version same as that of oracle 9i server? (I mean the server is 9.2.0.2 and the client is 9.2.0.3)
Thanks in advance.
Srinivas.