Installation of DataStage server 7.5.2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Installation of DataStage server 7.5.2
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
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
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.
If you still have a problem after that, we can start with all of the 'post your dsenv file' shenanigans.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
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
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
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
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
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
![Confused :?](./images/smilies/icon_confused.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
#!/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
####################################################################
#
# 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