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
datastage 7.5.3
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
# .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
# 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