DSXchange

Hi,
I tried to use the search in the forum but could not find a resolution.

When trying to import meta data using plugins for Oracle 9I we are getting the following error.

Unable to initialize plug-in:

Can I get some help on re-installing the Plugins?

The same path worked before I applied ODBC drivers 5.1 and re-started the server.

DSENV:
DS_NO_PROCESS_METADATA=1; export DS_NO_PROCESS_METADATA
DB2DIR=/usr/opt/db2_08_01;export DB2DIR
DB2INSTANCE=db2; export DBINSTANCE
INSTHOME=db2; export INSTHOME
PATH=$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc:$PATH expor
t PATH
LIBPATH=$DB2DIR/lib:$INSTHOME/sqllib/lib:$LIBPATH; export LIBPATH
LDR_CNTRL=MAXDATA=0x30000000;export LDR_CNTRL
ORACLE_HOME=/oracle_client/product/v92; export ORACLE_HOME
ORAHOME=/oracle_client/product/v92
LIBPATH=$LIBPATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32; export LIBPATH
ORACLE_SID=Z1PK
ORASID=Z1PK
export ORAHOME ORACLE_SID ORASID
PATH=$PATH:/home/oracle/OraHome1/bin export PATH




Thanks in advance for your help.

Krishna

What do you mean by 'the same path' that worked before you installed ODBC drivers? Are you saying that you could import plug-in metadata via the OCI stages before but can't now? Or never could?

I don't see anything wrong with your dsenv off the bat, are you sure your ORACLE_HOME is being set correctly? What operating system, by the way?

Krishna,
Just looking at your dsenv file, the PATH to your Oracle's bin directory and the lib directory is totally different. No wonder DataStage could not initialize the plug-in.

As far as I know, it doesn't even use the PATH variable for things like that. As a matter of fact, I've got nothing in the way of Oracle in my PATH statement and it works just fine. It's all about the Shared Library...

Hi All,
The server is installed on a Unix AIX machine version 5.1.
Database I am trying to connect via DataStage Manager/Import/Table Definition/Plug-in Metadata Def. And When I choose ORAOCI9.

I am getting this error.
Unable to initialize plug-in:

I re-installed just the oci9 drivers from the CD and bouced the server. But I am getting the same error.

Please let me know if I am missing any steps.

Krishna

Two things:

1. Test the environment of the engine by either creating a Batch job to or whip up a Sequence w/Command stage to run env. Make sure the environment shows what you need for Oracle to work.

2. The Oracle bin is required if you need to run sqlplus, sqlldr, or any other tools as part of your ETL jobs without fully qualifying to the bin every time.

first of all, are you running 64 bit applications? or a 64 bit os, w/e

if you are not running a 64 bit kinda of app, i would recommend to use just 'lib' not 'lib32'

for example
my oracle config looks like this

ORACLE_HOME="/local/oracle/product/10.2.0"
export ORACLE_HOME
ORAHOME="/local/oracle/product/10.2.0"
export ORAHOME
PATH="$ORACLE_HOME/bin:$PATH"
export PATH
LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib"
export LD_LIBRARY_PATH

and it works just great!

take those lines and change the directories.

i hope i could help!

you could also read this post
viewtopic.php?t=102133&postdays=0&posto ... c&start=15
because i used to have the problem, check that post

regards-.


diego

DataStage is a 32-bit application (Oracle client) on most platforms. Therefore, for DataStage processes, lib32 must precede lib in the shared library search path.