how to setup Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
how to setup Oracle Enterprise Stage
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,
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.