Unable to initialize plug-in
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
Unable to initialize plug-in
Hi,
we had done a new installation of datastage Server in a AIX machine, after install we configured the dsenv file, .odbc.ini, uvodbc.config, profile, .....
In the dsenv i had configured the LD_LIBRARY_PATH with the location of the Oracle.
I'm trying to access do Oracle, but i get the error message "Unable to initialize plug-in".
What could be ?
After changed any of the configuration files, we must do the restart of datastage ?
merci
Rai
we had done a new installation of datastage Server in a AIX machine, after install we configured the dsenv file, .odbc.ini, uvodbc.config, profile, .....
In the dsenv i had configured the LD_LIBRARY_PATH with the location of the Oracle.
I'm trying to access do Oracle, but i get the error message "Unable to initialize plug-in".
What could be ?
After changed any of the configuration files, we must do the restart of datastage ?
merci
Rai
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
Hi
Since you are using plug-ins to import your metadata, I suppose you are not using any ODBC stages in your job. You need not configure .odbc.ini or uvodbc.config. But be very sure you update the parameters
ORACLE_HOME
ORAHOME
LD_LIBRARY_PATH / LIBPATH
ORACLE_HOME
ORACLE_SID
ORASID
Which flavour of Unix are you using? You need to set either LD_LIBRARY_PATH or LIBPATH based on that. Finally you need to restart the DS server.
Since you are using plug-ins to import your metadata, I suppose you are not using any ODBC stages in your job. You need not configure .odbc.ini or uvodbc.config. But be very sure you update the parameters
ORACLE_HOME
ORAHOME
LD_LIBRARY_PATH / LIBPATH
ORACLE_HOME
ORACLE_SID
ORASID
Which flavour of Unix are you using? You need to set either LD_LIBRARY_PATH or LIBPATH based on that. Finally you need to restart the DS server.
Arnab
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
The prefix of "." and a space before the "./dsenv" script call is very important, otherwise the script is executed in a different shell and the values set are lost; that seems to be happening in your case.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Unable to initialize plug-in
RAI
you must to check if your datastage user have permissions on the oracle directory
you have to add the oracle group in the ds user, without that permissions you can't access to the oracle libraries.
apply this and tell us the results.
:D
you must to check if your datastage user have permissions on the oracle directory
you have to add the oracle group in the ds user, without that permissions you can't access to the oracle libraries.
apply this and tell us the results.
:D
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Some points... first off this is the 'entire contents of the dsenv file'. Notice the use of the code tags to preserve all that wondrous indenting Ascential spent many man-months perfecting.
Secondly, there's no need to mix groups together or "add the Oracle group in the ds user", you simply need to ensure that the Oracle libraries and binaries have the appropriate permissions to allow access to them (typically 644 in lib and 755 in bin) and they should be that way by default.
Thirdly, "bounce the server" means to stop then restart DataStage, not literally do the same to the box hosting DataStage like it may sound.
Fourthly after you source the dsenv file by typing "dot-space-dot-slash-dsenv" from the command line in the DSEngine directory, how exactly are you trying to "see" the "parameters" of the dsenv file? I copied your file to my system, sourced it and then saw them just fine, so structurally it is ok. Can you post here what is returned after sourcing when you "echo $ORACLE_HOME" or "echo $LIBPATH"?
Fifthly, you never told us what UNIX you are running.
Code: Select all
####################################################################
#
# dsenv - DataStage environment file
#
# Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
# This is unpublished proprietary source code of Ascential Software Corporation
# The copyright notice above does not evidence any actual or
# intended publication of such source code.
#
# This script is sourced by the DataStage dsrpcd daemon to establish
# proper environment settings for DataStage client connections.
#
# This script may also be sourced by bourne shells to establish
# proper environment settings for local DataStage use.
#
####################################################################
# PLATFORM SPECIFIC SECTION
set +u
if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi
if [ -z "$DSHOME" ]
then
DSHOME=/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine; export DSHOME
export DSHOME
fi
if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=; export APT_ORCHHOME
fi
if [ -z "$UDTHOME" ]
then
UDTHOME=/opt/IBM/InfoSphere/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/opt/IBM/InfoSphere/Ascential/DataStage/ud41/bin; export UDTBIN
fi
if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME
export ORACLE_BASE=/opt/oracle/dmannue/10g
export ORACLE_HOME=$ORACLE_BASE/10.2.0
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P05
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
PATH=$PATH:$ORACLE_HOME/bin
export PATH
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH
fi
Thirdly, "bounce the server" means to stop then restart DataStage, not literally do the same to the box hosting DataStage like it may sound.
Fourthly after you source the dsenv file by typing "dot-space-dot-slash-dsenv" from the command line in the DSEngine directory, how exactly are you trying to "see" the "parameters" of the dsenv file? I copied your file to my system, sourced it and then saw them just fine, so structurally it is ok. Can you post here what is returned after sourcing when you "echo $ORACLE_HOME" or "echo $LIBPATH"?
Fifthly, you never told us what UNIX you are running.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact: