内容发布更新时间 : 2024/12/22 23:53:31星期一 下面是文章的全部内容请认真阅读。
# 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 \then
DSHOME=`cat /.dshome` export DSHOME fi
if [ -z \then
DSHOME=/app/dsadm/Ascential/DataStage/DSEngine; export DSHOME fi
if [ -z \then
APT_ORCHHOME=/app/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME fi
if [ -z \then
UDTHOME=/app/dsadm/Ascential/DataStage/ud41; export UDTHOME UDTBIN=/app/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN fi
if [ -n \then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI HOME=${HOME:-/}; export HOME
#LANG=\
#LC_ALL=\#LC_CTYPE=\#LC_COLLATE=\#LC_MONETARY=\#LC_NUMERIC=\#LC_TIME=\
#LC_MESSAGES=\
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
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=/app/oracle/product/10.2
export TNS_ADMIN=/app/oracle/product/10.2/network/admin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PATH=$PATH:$ORACLE_HOME/bin export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LIBPATH=$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LIBPATH (2)编辑dsadm用户.bash_profile文件,我的该文件内容: # .bash_profile
# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi
# User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH
export DSHOME=/app/dsadm/Ascential/DataStage/DSEngine
. $DSHOME/dsenv
PATH=$PATH:$DSHOME/bin:$APT_ORCHHOME/bin:$DSHOME/lib:$DSHOME/branded_odcdbc/lib:$ORACLE_HOME/bin export PATH
export NLS_LANG=American_America.ZHS16GBK
alias 'l=ls -l' set -o vi unset USERNAME
这两个文件照着我的配就OK了,当中的相关目录(ds和oracle)得修改为你的安装目录. 执行动态链接库脚本
/app/dsadm/Ascential/DataStage/PXEngine/install/install.liborchoracle 出现Oracle Installation is complete才算安装成功. 在LIBPATH部分增加路径$ORACLE_HOME/lib
配置好后,进入对应目录使这两个文件立即生效 source dsenv source .bash_profile 重启DS uv -admin -stop uv -admin -start
在客户端新建JOB进行测试,下面的是我的测试JOB
oracle和DS是在同一台服务器上,DS使用oracle时候要对以下视图赋权限 DBA_DATA_FILES DBA_TAB_PARTITONS DBA_OBJECTS ALL_PART_INDEXES ALL_PART_TABLES ALL_INDEXES
SYS.GV_$INSTANCE (Only if Oracle Parallel Server is used) datastage自带的联机帮助文档上有说明这一点,
We suggest that you create a role that has the appropriate SELECT privileges, as follows: CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE; GRANT SELECT on sys.dba_data_files to DSXE; GRANT SELECT on sys.dba_tab_partitions to DSXE; GRANT SELECT on sys.dba_objects to DSXE; GRANT SELECT on sys.all_part_indexes to DSXE; GRANT SELECT on sys.all_part_tables to DSXE; GRANT SELECT on sys.all_indexes to DSXE;
Once the role is created, grant it to users who will run DataStage jobs, as follows: GRANT DSXE to
6.
注意事项：
Datastage安装应该确认安装的机器是32位或64位，在安装出错，安装后安装路径下的文件不全，可能是install.sh的错误。安装正确则主目录/home/ap/dsadm/Ascential/DataStage/下存在一下文件目录 Configurations DSCAPIOp DSEngine DSParallel Datasets Datasets_bak Logfiles MsgHandlers PXEngine PXEngine.752.1 PXEngine.752.2 Plugins.ini Projects Scratch Scratch_bak Template Template.ini branded_odbc
Datastage 的服务端安装在安装前应尽可能确认数据库安装正确，且和datastage服务端机器是联通的。
一般datastage 服务端作为单独机器，若连接数据库为oracle，应该在安装前在机器上安装oracle客户端（参见oracle客户端安装文档），oracle 客户端安装应该以管理员模式安装，这样为了确保oracle工具安装全面，特别是sqlload可用。 Datastage工程创建后需要修改相应的参数，特别是要修改下面参数 APT_STRING_PADCHAR 0x20