datastage配置oracle,配置datastage与oracle 10g连接

配置datastage与oracle 10g连接以及一些问题的解决办法

首先安装这两款软件，我使用的是oracle 10g 与datastage V7.5,安装完成后，编辑$DSHOME 下的dsenv文件。我的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

if [ -z "$DSHOME" ]

then

DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME

fi

if [ -z "$APT_ORCHHOME" ]