how to setup Oracle Enterprise Stage

Aggie99 · Post by **Aggie99** » Thu Jul 30, 2009 6:43 am

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,

ArndW · Post by **ArndW** » Thu Jul 30, 2009 6:50 am

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?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 30, 2009 6:55 am

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.

Aggie99 · Post by **Aggie99** » Thu Jul 30, 2009 7:08 am

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.

ArndW · Post by **ArndW** » Thu Jul 30, 2009 7:12 am

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.

chulett · Post by **chulett** » Thu Jul 30, 2009 7:22 am

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

FYI - unnecessary.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 30, 2009 7:24 am

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.

chulett · Post by **chulett** » Thu Jul 30, 2009 7:30 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 4:25 pm

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).

chulett · Post by **chulett** » Thu Jul 30, 2009 5:28 pm

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.

Aggie99 · Post by **Aggie99** » Fri Aug 07, 2009 12:22 am

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.