Installation of DataStage server 7.5.2

[saikrishna]

Hi


I have installed DataStage server 7.5.2 on Linux box.
While installing I have selected Oracle OCI stage plugin.
After installation, I have added env variables for OracleHome, etc in dsenv file.
Then i stopped the server and started back the server after some time...

But, I am not able to import metadata from plugin OracleOCI ...
It is saying that plugin is not initialized.

Can you please tell me what could be the problem of not working Oracle plugin stage in the installed DS.

Thanks
Sai

[chulett]

Read the plug-in Installation and Configuration guide. Then make sure you have added all of the appropriate values to the dsenv file and that all are correct.

If you still have a problem after that, we can start with all of the 'post your dsenv file' shenanigans.

[saikrishna]

Hi Chullet

Can you please look at dsenv file and findout anything is missing?

#!/bin/sh
####################################################################
#
# 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=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#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

LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/jre/lib/i386:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
fi
ORACLE_HOME=/home/oracle/ora9204; export ORACLE_HOME
ORAHOME=/home/oracle/ora9204; export ORAHOME
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
export ORACLE_SID=cmmstg
export ORASID=cmmstg
TNS_ADMIN=/home/dsadm/TNS; export TNS_ADMIN
PATH=$ORACLE_HOME/bin:$PATH:/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X/bin; export PATH


Thanks
Sai

[chulett]

Seems... fine... although your Oracle changes are not where they would typicall go and you have 'extra stuff' in your second LD_LIBRARY_PATH setting. Change $ORACLE_HOME/lib to $ORACLE_HOME/lib32 if that exists on your server. And you need to verify your ORACLE_HOME and TNS_ADMIN settings. Is the latter really needed?

[saikrishna]

Hi

I feel "unable to initialize plugin" error is relates to the installation of plugin rather than connecting to any db.

By changing as u said will probably point to correct Oracle directory.

But this error relates to the installation of plugin inside DataStage server.

I tried uninstalling and installing several times and also with a different binary also. But could not solve this problem.

Can you please help me here.

Thanks
Sai

[chulett]

So... did you or did you not try what I suggested? Of course the error relates to the installation of the plugin, as noted part of that 'installation' is properly configuring the environment to support it. Un/reinstalling won't change anything and I have no idea what trying 'a different binary' means.

Did you validate your $ORACLE_HOME value? Did you check to see if there was a lib32 directory in your ORACLE_HOME? All you have to do to get past this 'initialization' error is get the values in your dsenv file correct. Why don't you answer these two questions and post what your dsenv file looks like right now, unless you haven't changed it.

[saikrishna]

I uninstalled DS now..and no time for me to install it again today.
I will answer ur questions by tomorrow..


Thanks for your anticipation
Sai

[saikrishna]

Hi chullet

I validated $ORACLE_HOME value..it is right.
lib32 directory is present in ORACLE_HOME.
I have tried the dsenv file with the following changes ....
changing $ORACLE_HOME/lib to $ORACLE_HOME/lib32 in LD_LIBRARY_PATH .
But no result...


#!/bin/sh
####################################################################
#
# 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=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#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

LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/jre/lib/i386:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
fi
RACLE_HOME=/home/oracle/ora9204; export ORACLE_HOME
ORAHOME=/home/oracle/ora9204; export ORAHOME
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
export ORACLE_SID=cmmstg
export ORASID=cmmstg
PATH=$ORACLE_HOME/bin:$PATH:/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X/bin; export PATH

[chulett]

Is this actually what's in your dsenv file?

RACLE_HOME=/home/oracle/ora9204; export ORACLE_HOME

ORACLE without the 'O'?

[ray.wurlod]

lib32 does not belong in ORACLE_HOME environment variable; it belongs in LD_LIBRARY_PATH (or SHLIB_PATH or LIBPATH).

[saikrishna]

Hi Chullet


You are right.. It was a mistake. Now I corrected and restarted the server.

It is working now with the following dsenv file.

Thanks
Sai

[saikrishna]

#!/bin/sh
####################################################################
#
# 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=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#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

LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/jre/lib/i386:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
fi
ORACLE_HOME=/home/oracle/ora9204; export ORACLE_HOME
ORAHOME=/home/oracle/ora9204; export ORAHOME
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
export ORACLE_SID=cmmstg
export ORASID=cmmstg
PATH=$ORACLE_HOME/bin:$PATH:/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X/bin; export PATH


Thanks a lot
Sai

[chulett]

Good.

ps. There's no need to set either ORACLE_SID or ORASID in the dsenv file. Doesn't hurt but they aren't needed.