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.
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
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.