Configuration after installation
(1) edit the dsenv file in the/app/dsadm/Ascential/DataStage/DSEngine/directory. The content of my dsenv file is:
#! /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 =/app/dsadm/Ascential/DataStage/DSEngine; export DSHOME
Fi
If [-z "$ APT_ORCHHOME"]
Then
APT_ORCHHOME =/app/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME
Fi
If [-z "$ UDTHOME"]
Then
UDTHOME =/app/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN =/app/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
LD_LIBRARY_PATH = 'dirname $ dshome'/branded_odbc/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) edit the dsadm user. bash_profile file. The content of this file is as follows:
#. 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_odbc/lib: $ ORACLE_HOME/bin
Export PATH
Export NLS_LANG = American_America.ZHS16GBK
Alias 'l = ls-l'
Set-o vi
Unset USERNAME
The two files are OK according to my configuration. The related directories (ds and oracle) must be modified to your installation directory.
(3) execute the dynamic library connection script
/App/dsadm/Ascential/DataStage/PXEngine/install. liborchoracle
If Oracle Installation is complete is displayed, the Installation is successful.
(4) Add the path $ ORACLE_HOME/lib in the LIBPATH section.