(5) After configuration, enter the corresponding directory to make the two files take effect immediately
Source dsenv
Source. bash_profile
(6) Restart DS
Uv-admin-stop
Uv-admin-start
(7) create a JOB on the client to test the JOB. The following is my test JOB.
(8) oracle and DS are on the same server. When using oracle, DS must grant permissions to the following view.
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)
This is described in the online help documentation provided by 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>;
Now, the installation and configuration of oracle and datastage on redhat enterprise linux 3 are complete.
Http://hi.baidu.com/lxw1234/blog/item/332a4027c36d4e06918f9d99.html