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.
Unable to initialize the plug-in for ORAOCI9
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jul 07, 2003 12:56 am
- Location: India
Hmmmm,
Any answers to that one?
I'm having a similar problem with 7.5.
(Showing yall I search
I'll post a fresh post
Any answers to that one?
I'm having a similar problem with 7.5.
(Showing yall I search
I'll post a fresh post
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 22
- Joined: Thu Jul 29, 2004 8:10 am
Can you try adding $ORACLE_HOME/bin in LD_LIBRARY_PATH
Restart DS after the change is done.
Try your luck. Its working fine with me.
export SHLIB_PATH=/usr/lib:/ascl/dsadm/Ascential/DataStage/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot:
$DSHOME/java/jre/lib/PA_RISC:$APT_ORCHHOME/lib:$APT_ORCHHOME/bin:/appl/ora9i/lib32:/appl/ora9i/bin:/appl/ora9i/lib:/appl/ora9i/rdbms/lib
Regards
Ahmed.
Restart DS after the change is done.
Try your luck. Its working fine with me.
export SHLIB_PATH=/usr/lib:/ascl/dsadm/Ascential/DataStage/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot:
$DSHOME/java/jre/lib/PA_RISC:$APT_ORCHHOME/lib:$APT_ORCHHOME/bin:/appl/ora9i/lib32:/appl/ora9i/bin:/appl/ora9i/lib:/appl/ora9i/rdbms/lib
Regards
Ahmed.