How to configure DSN for Oracle In unix (Server)

[ray.wurlod]

Isn't 39202 indicative that the server licence has expired?

[chulett]

Not sure. One example here seemed to indicate that or that they got it after the license had expired. Others had 'library path' or permission changes that corrected it.

[georgesebastian]

We have registered a case with IBM,
These are the steps that we did,
thanks for all ur help
i will up date u all..

These are the commands that we tried on our dev server

# cd /opt/products/Ascential/DataStage/DSEngine

# netstat -a |grep dsrpc

tcp 0 0 *.dsrpc *.* LISTEN


# ps -ef|grep phantom

root 23389 23366 1 03:05:29 pts/1 0:00 grep phantom

# ps -ef|grep dsapi

root 23393 23366 1 03:06:17 pts/1 0:00 grep dsapi

# ps -ef|grep dscs

root 23395 23366 1 03:06:59 pts/1 0:00 grep dscs

# ipcs -mop|grep ade

m 33798 0xadec7512 --rw-rw-rw- root dwcap 0 14411 23275

# ipcrm -m 33798

# netstat -a|grep dsrpc

tcp 0 0 *.dsrpc *.* LISTEN

# . ./dsenv

sh: OME/java/jre/lib/PA_RISC2.0/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:/opt/cobol/lib:/usr/dmexpress/lib: not found.

# ./bin/uvsh

/usr/lib/dld.sl: Can't find path for shared library: libgciudt6.sl

/usr/lib/dld.sl: No such file or directory

Abort(coredump)

# cd bin

# pwd

/opt/products/Ascential/DataStage/DSEngine/bin

# uv -admin -start

sh: uv: not found.

# ls -al uv

-rwxrwxrwx 1 dsadm dwcap 65536 Apr 13 2005 uv


Thanks & Regards

George .S.Thazhath

[ray.wurlod]

You don't seem to undertand how the command search path works. You must provide the pathname of the executable even if you are in its parent directory unless that parent directory is in your command search path (the PATH environment variable).

Thus, if you are in /opt/product/Ascential/DataStage/DSEngine, the command must be bin/uv or ./bin/uv while if you are in that bin directory the command must be ./uv (not just uv)

The uv command may not work for entering the DataStage environment because shared libraries can not be found. Its -admin options should still be OK, however. If this is the case, try the dssh command for entering the DataStage environment.

All that said, dsenv is a text file in the DSEngine directory, so I'm unclear as to why you're trying to use the uv command (apart from the one to start DataStage).

Finally, it appears (from "sh: OME/java/jre/lib/PA_RISC2.0/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:/opt/cobol/lib:/usr/dmexpress/lib: not found. ") that there is a problem with at least one of the commands setting LD_LIBRARY_PATH in your dsenv script. An inadvertent newline, perhaps?

[ray.wurlod]

The line beginning "OME" suggests to me that there's an unwanted line terminator in the line in dsenv that is setting LD_LIBRARY_PATH.

The script is attempting to recognize OME as the first subdirectlry in the relative pathname of a command; hence the "command not found" message.

[ray.wurlod]

How about we stop maintaining two effectively identical threads on this one?

What you've typed in above is manifestly incomplete; you can't get a status of "Running" from uv -admin -info immediately after shutting DataStage down with uv -admin -stop command.

In any case, it's now obvious that the first of your two problems, the inability to start DataStage successfully, is now solved.

We can address your connectivity to Oracle.

Do you want to connect via ODBC or via the Oracle OCI client interface? In either case you need the Oracle client software installed on the DataStage server machine. Please verify that this is the case.

[georgesebastian]

Finally The plugin is resolved,

It was the problem with dsenv file format,
there was some unnessasary if else loop,the SHLIB_PATH was not defined
in a single line
Took off the unnessasary if else loop,
made the SHLIB_PATH in a single line ,it worked

this is how our new dsenv file looks like
$ more dsenv
#!/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
#added oracle env here.
ORACLE_HOME=/opt/oracle_9.2.0; export ORACLE_HOME

if [ -z "$DSHOME" ]
then
DSHOME=/opt/products/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/opt/products/Ascential/DataStage/PXEngine; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/opt/products/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/opt/products/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_PRELOAD must be unset on HP-UX 11.00
SHLIB_PATH=$SHLIB_PATH:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0:`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdll
s:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot
export SHLIB_PATH

fi

SHLIB_PATH=$SHLIB_PATH:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0:`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdll
s:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot
export SHLIB_PATH
$

Thanks for all your help

George sebastain

[kumar_s]

Hi George,
Thanks for sharing the solution. Would you mind marking the topic as resolved so that it can be useful for the further searchers.