(5)配置好后,进入对应目录使这两个文件立即生效
source dsenv
source .bash_profile
(6)重启DS
uv -admin -stop
uv -admin -start
(7)在客户端新建JOB进行测试,下面的是我的测试JOB
(8)oracle和DS是在同一台服务器上,DS使用oracle时候要对以下视图赋权限
DBA_EXTENTS
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 <oracle userid>;
好了,到此oracle和datastage在redhat enterprise linux 3上的安装和配置全部完成了.
http://hi.baidu.com/lxw1234/blog/item/332a4027c36d4e06918f9d99.html