DataStage在RedHat Linux Enterprise 3上安裝詳細步驟（八)

(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