datastage与oracle,datastage 连接oracle时出错

先确定下1, 2, 3都配置好了么？

也有可能是32bit 64bit的问题，不是很确定，楼主先试试看1，2，3

Oracle System Administration (from Installation and Upgrade Guide)

You need to be running Oracle 8 or better, Enterprise Edition in order

to run DataStage jobs using the Oracle Enterprise Stage. Your Oracle

installation should include the Oracle Database Utilities and Oracle

Network software.

You must also do the following:

1 Create the user defined environment variable ORACLE_HOME and

set this to the $ORACLE_HOME path (e.g., /disk3/oracle9i)

2 Create the user defined environment variable ORACLE_SID and

set this to the correct service name (e.g., ODBCSOL).

3 Add ORACLE_HOME/bin to your PATH and ORACLE_HOME/lib to

your LIBPATH, LD_LIBRARY_PATH, or SHLIB_PATH.

4 Have login privileges to Oracle using a valid Oracle user name and

corresponding password. These must be recognized by Oracle

before you attempt to access it.

5 Have SELECT privilege on:

– DBA_EXTENTS

– DBA_DATA_FILES

– DBA_TAB_PARTITONS

– DBA_TAB_SUBPARTITIONS

– DBA_OBJECTS

– ALL_PART_INDEXES

– ALL_PART_TABLES

– ALL_INDEXES

– SYS.GV_$INSTANCE (Only if Oracle Parallel Server is used)

Note APT_ORCHHOME/bin must appear before ORACLE_HOME/

bin in your PATH.

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_tab_subpartitions 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 ;

[本帖最后由 stenny 于 2008-2-26 01:09 编辑]