datastage 7.5.3

krisna · Post by **krisna** » Wed Apr 28, 2010 6:56 am

Hi,

Its a fresh installation, from oracle enterprise when I want to view data, iam getting this error

##I TOSH 000002 18:23:04(001) <main_program> orchgeneral: loaded
##I TOSH 000002 18:23:04(002) <main_program> orchsort: loaded
##I TOSH 000002 18:23:04(003) <main_program> orchstats: loaded
##I TFSC 000001 18:23:05(000) <main_program> APT configuration file: /home/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 18:23:05(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOSH 000205 18:23:05(002) <main_program> PATH search failure:
>##E TOSH 000000 18:23:05(003) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable LD_LIBRARY_PATH; path: /home/dsadm/Ascential/DataStage/Projects/GMEDWPROJ/buildop:/home/dsadm/Ascential/DataStage/DSCAPIOp:/home/dsadm/Ascential/DataStage/RTIOperators:/home/dsadm/Ascential/DataStage/DSParallel:/home/dsadm/Ascential/DataStage/PXEngine/user_lib:/home/dsadm/Ascential/DataStage/PXEngine/lib:/u01/app/oracle/OraDb10g_home1/lib:/u01/app/oracle/OraDb10g_home1/rdbms/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386/client:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386:/home/dsadm/Ascential/DataStage/branded_odbc/lib:/home/dsadm/Ascential/DataStage/DSEngine/lib:/home/dsadm/Ascential/DataStage/DSEngine/uvdlls:/usr/lib:..
>##E TOSH 000000 18:23:05(004) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 18:23:05(005) <main_program> Creation of a step finished with status = FAILED.
Please sort out this error.
In advance Thanks to every one

chulett · Post by **chulett** » Wed Apr 28, 2010 6:59 am

What have you done to configure DataStage for Oracle? I would guess that "fresh" here is a synonym for "nothing".

What you'd need to do is spelled out in the Installation and Upgrade Guide and a couple of other documents, from what I recall.

chulett · Post by **chulett** » Wed Apr 28, 2010 7:39 am

Also meant to ask but forgot - do you have an Oracle client installed on the DataStage server? That's the primary requirement, after that it is all about the configuration.

krisna · Post by **krisna** » Wed Apr 28, 2010 8:09 am

sorry to say 'fresh' its new installation.
sorry to ask a siily question but we have installed the oracle 10g db server and datastage 7.5.3 on the same linux box. even then do we need to put client on the machine.

thanks in advance

krisna · Post by **krisna** » Wed Apr 28, 2010 8:47 am

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

ORACLE_HOME=/u01/app/oracle/OraDb10g_home1
export ORACLE_HOME

ORACLE_SID=DSREPO
export ORACLE_SID

LD_LIBRARY_PATH=/home/dsadm/Ascential/DataStage/PXEngine/lib:/u01/app/oracle/OraDb10g_home1/lib:/u01/app/oracle/OraDb10g_home1/rdbms/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386/client:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386:/home/dsadm/Ascential/DataStage/branded_odbc/lib:/home/dsadm/Ascential/DataStage/DSEngine/lib:/home/dsadm/Ascential/DataStage/DSEngine/uvdlls:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

PATH=$PATH:$HOME/bin:/usr/bin:/home/dsadm/Ascential/DataStage/PXEngine.753.1/bin:/home/dsadm/Ascential/DataStage/PXEngine/bin:/home/dsadm/Ascential/DataStage/DSEngine/bin:/u01/app/oracle/OraDb10g_home1:/u01/app/oracle/OraDb10g_home1/bin
export PATH

DSHOME=`cat /.dshome`
. $DSHOME/dsenv

APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine:$APT_ORCHHOME

export APT_ORCHHOME
-------------------------------

#!/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=/home/dsadm/Ascential/DataStage/PXEngine; 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

TNS_ADMIN=/u01/app/oracle/OraDb10g_home1/network/admin
export TNS_ADMIN

ORACLE_HOME=/u01/app/oracle/OraDb10g_home1
export ORACLE_HOME

LD_LIBRARY_PATH=/home/dsadm/Ascential/DataStage/PXEngine/lib:/home/dsadm/Ascential/DataStage/branded_odbc/lib:/home/dsadm/Ascential/DataStage/DSEngine/lib:/u01/app/oracle/OraDb10g_home1/lib:/u01/app/oracle/OraDb10g_home1/rdbms/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386/client:/home/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/i386:/home/dsadm/Ascential/DataStage/DSEngine/uvdlls:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

# 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

#PATH=/home/dsadm/Ascential/DataStage/PXEngine.753.1/bin:/home/dsadm/Ascential/DataStage/DSEngine/bin::/home/dsadm/Ascential/DataStage/PXEngine/bin:/u01/app/oracle/OraDb10g_home1:/u01/app/oracle/OraDb10g_home1/bin
#export PATH
---------

Iam using the above configs for .bash_profile and dsenv.

Thanks in advance