DataStage not responding to Reading from OCI.....

[soham296]

Hi,

I am able to insert a into a oracle table, using a datastage job. But Job is not working when reading from table to a sequence file or another table. I could see using toad it is retrieving data from oracle but not able to write to the output system.

Thanks in advance
Soham

[phanee_k]

What error are you getting when you try to view the data from OCI stage.

Try connecting from the ETL server to the oracle database from the command line.

Check whether the dsenv file on DataStage server is updated with the Oracle Home and the library files which will be used to access ORA db.

Ensure that the oracle SID is mentioned in tnsnames.ora on DataStage server


Thanks,
Phani