乌托邦博客

You see? Even death has a heart

« DataStage 7.5.2 连接Oracle 11gError: cannot mount filesystem: Protocol error [fail] »

DataStage 7.5.2 Cluster Configuration

       折腾了一天一夜才搞定的,其实很简单的一个事情,不过实际动手会有一些意想不到的小问题.

        我的做法如下:

  1. 在VmWare上安装好机器AP01,下面是配置清单:

      OS:Red Hat Enterprise Linux 4.8 64-bit

       Memory:1536MB

       SoftWare:

       Oracle DataBase 11g

       DataStage 7.5.2

       IP:192.168.0.110

       HostName:AP01

      下面是几个重要的配置文件:

  • ods用户的配置文件,会使用该用户作为rsh的登陆用户

      [ods@AP01 ~]$ more .bash_profile
# .bash_profile

. /home/ap/dsadm/Ascential/DataStage/DSEngine/dsenv

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

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

#---------- oracle ----------
export ORACLE_HOME=/home/db/oracle/product/11.1.0
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/home/ap/dsadm/Ascential/DataStage/DSEngine/lib:/home/ap/dsadm/Ascential/DataS
tage/RT_BP1.O:/home/ap/ods/lib:/home/ap/ods/bin:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
#---------- datastage -------------
export DSHOME=/home/ap/dsadm/Ascential/DataStage/DSEngine
export LANG=iso8859
export APT_ORCHHOME=/home/ap/dsadm/Ascential/DataStage/PXEngine
export PATH=$PATH:$HOME/bin:$APT_ORCHHOME/bin:$DSHOME/bin

export PATH
unset USERNAME

  •    .rhost文件用于定义信任主机,权限必须为600

[ods@AP01 ~]$ more .rhosts
AP01        ods
AP02        ods
 

  • dsadm用户的配置文件,该用户用于管理DataStage

[dsadm@AP01 ~]$ more .bash_profile
# .bash_profile

. /home/ap/dsadm/Ascential/DataStage/DSEngine/dsenv

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

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

#---------- oracle ----------
export ORACLE_HOME=/home/db/oracle/product/11.1.0
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/home/ap/dsadm/Ascential/DataStage/DSEngine/lib:/home/ap/dsadm/Ascential/DataS
tage/RT_BP1.O:/home/ap/ods/lib:/home/ap/ods/bin:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
#---------- datastage -------------
export DSHOME=/home/ap/dsadm/Ascential/DataStage/DSEngine
export LANG=iso8859
export APT_ORCHHOME=/home/ap/dsadm/Ascential/DataStage/PXEngine
export PATH=$PATH:$HOME/bin:$APT_ORCHHOME/bin:$DSHOME/bin

export PATH
unset USERNAME
 

  • dsenv

# User specific environment and startup programs
export DSHOME=/home/ap/dsadm/Ascential/DataStage/DSEngine
export LANG=iso8859
export APT_ORCHHOME=/home/ap/dsadm/Ascential/DataStage/PXEngine
PATH=$PATH:$HOME/bin:$APT_ORCHHOME/bin:$DSHOME/bin
export PATH
unset USERNAME

#-----oracle-------
export ORACLE_HOME=/home/db/oracle/product/11.1.0
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:/lib:/usr/lib:/home/ap/dsadm/Ascential/DataStage/DSEngine/lib:/home/ap/ds
adm/Ascential/DataStage/RT_BP1.O:/home/ap/ods/lib:/home/ap/ods/bin:$ORACLE_HOME/lib:$HOME/lib:.
 

  • root用户的配置文件

# User specific environment and startup programs
export DSHOME=/home/ap/dsadm/Ascential/DataStage/DSEngine
export LANG=iso8859
export APT_ORCHHOME=/home/ap/dsadm/Ascential/DataStage/PXEngine
PATH=$PATH:$HOME/bin:$APT_ORCHHOME/bin:$DSHOME/bin
export PATH
unset USERNAME

#-----oracle-------
export ORACLE_HOME=/home/db/oracle/product/11.1.0
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:/lib:/usr/lib:/home/ap/dsadm/Ascential/DataStage/DSEngine/lib:/home/ap/ds
adm/Ascential/DataStage/RT_BP1.O:/home/ap/ods/lib:/home/ap/ods/bin:$ORACLE_HOME/lib:$HOME/lib:.

  • /etc/hosts文件

[root@AP01 ~]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
192.168.0.110   AP01
192.168.0.111   AP02
注意:请严格按此文件检查,因为我就是因为这个文件不对,所以才搞了那么久。就是127的那一行,原本自动生成的是 127.0.0.1      AP01  localhost.localdomain localhost,导致不成功。
 

  • APT_Configurations_File

[root@AP01 Configurations]# more Test.apt
{
node "node01"
{
fastname "AP01"
pools ""
resource disk "/home/ap/dsadm/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/home/ap/dsadm/Ascential/DataStage/Scratch" {pools ""}
}
node "node02"
{
fastname "AP02"
pools ""
resource disk "/home/ap/dsadm/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/home/ap/dsadm/Ascential/DataStage/Scratch" {pools ""}
}
node "node03"
{
fastname "AP02"
pools ""
resource disk "/home/ap/dsadm/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/home/ap/dsadm/Ascential/DataStage/Scratch" {pools ""}
}
}
 

      最后,检查rsh,rlogin,rexec这几个服务是否成功启动。

  1.       安装好AP01以后,直接COPY一份出来,用VmWare打开,更新硬件的时候更改IP为192.18.0.111。

      其实过程,很简单,最重要的就是rsh是否是通的,可以通过rsh hostname uptime来验证。其实AP02不必完全安装DataStage,可以使用copy-dist的方法,不过我没有去试,感兴趣的朋友可以看一下相关的配置文件,做个测试,别忘了把结果告诉我 ^_^

      以上就是配置的过程了,Good Luck!有问题请联系我!QQ:94424751

     补充:为了支持TRF,需要在Adminitrator里面把APT_COPY_TRANSFORM_OPERATOR改为True,默认为False。另一种办法就是用NFS共享ProJect目录。意思就是trf编译后,会生成一些文件,这些文件需要二边都能够读取。

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

日历

最新评论及回复

最近发表

Powered By Z-Blog 1.8 Spirit Build 80710 Code detection by Codefense

Copyright 2005-2007 Bootad.cn. Some Rights Reserved
.粤ICP备07062332号 QQ:94424751