DSXchange

I followed the configuration guide to setup Oracle Enterprise Stage, but it is not working.

I did the followings, basically whatever listed on the IBM Installation and Configuration PDF that come with the installation.
1) add ORACLE_HOME to environment
2) add ORACLE_HOME/bin to PATH to environment
3) add ORACLE_HOME/lib to LD_LIBRARY_PATH to environment
4) check tsnames.ora
5) get Oracle user id/pwd with proper privilage

my test was:
I used Oracle client to logon to a database to make sure the id/pwd worked.
THen, I created a parrallel job, using Oracle Enterpriese Stage. I put in remote server, ID, PWD, and a simple select statement.

But the job failed. Saying login invalid. I retype many times and sure the ID/PWD are correct. But don't know why I keep getting the error msg.

Can someone tell me what else are missing? I am a bit running out of idea on where to look?

thanks guy,

Could you post the complete and unedited error message? Did you login to Oracle from "sqlplus" on the UNIX client? Did you add the ORACLE_ environment variables to the dsenv file?

ArndW has already pointed in the right direction.

Also did you bounce your datastage instance after changes to dsenv ?

PS : I am assuming that you are running in Solaris box.

yes, I added ORACLE_HOME to dsenv, and then stopped and started the engine.

yes, i used sqlplus on Solaris to connect to oracle db and it worked fine.

by now your Oracle user is probably locked out and needs to be reset by the DBA. But please post the complete error message in any case.

Sainath.Srinivasan wrote:Also did you bounce your datastage instance after changes to dsenv ?

FYI - unnecessary.

chulett wrote:

Sainath.Srinivasan wrote:Also did you bounce your datastage instance after changes to dsenv ?

FYI - unnecessary.

I have found this necessary to load dsenv parameters part of datastage environment.

Some instances are when you hit library problems.

It's sourced whenever a job starts, so I've found it unncessary for 99% of the changes that I've ever had to make. For whatever that is worth.

It's useful to restart DataStage after dsenv changes so the dsrpcd picks up the changes (and therefore dsapi_server and dsapi_slave processes become aware of them).

I'm unsure exactly what kind of changes those processes would need to be aware of, and things have (seemingly) been fine without a 'bounce' but point taken.

Apparently the Oracle Enterprise Stage uses sqlldr client.

Once we reinstalled the Oracle Client with all its utility and software. And retried running Oracle Enterprise Stage job. The issue was resolved.