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
Unable to initialize plug-in:
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 56
- Joined: Fri Apr 21, 2006 9:53 am
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 56
- Joined: Fri Apr 21, 2006 9:53 am
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
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.
1. Test the environment of the engine by either creating a Batch job to
Code: Select all
CALL DSExecute("UNIX", "env", ScreenOutput, ReturnCode)
CALL DSLogInfo("The environment shows :":ScreenOutput, "Msg")
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
questioN!
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.