Oracle Stage configuration

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bp_dsx
Participant
Posts: 4
Joined: Tue Apr 22, 2008 8:32 am
Location: Mumbai

Oracle Stage configuration

Post by bp_dsx »

Hi
I am Balaram Prajapati, I need some help.
I have installed Data Stage PX on my LOcal Machine.
It is working fine, But When ever I am reading from Oracle Database table, I am getting some internal errors.
I think I have to set Oracle Path to some where.
Please lete me know the settings for that.
My Basic requirement is to Read from EMP table and Update into EMP table.
Please help me regarding this.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There are environment variables that need to be set for Oracle, including ORACLE_HOME. Consult your Oracle documentation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

Can you please post the error!
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

You can also refer to the DS Installation Guide.
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

Yes as far as Oracle Path is concerned you have to at Unix level.
bp_dsx
Participant
Posts: 4
Joined: Tue Apr 22, 2008 8:32 am
Location: Mumbai

Post by bp_dsx »

Nagaraj wrote:Yes as far as Oracle Path is concerned you have to at Unix level.
please let me the steps
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

bp_dsx wrote:please let me the steps
If you are having a problem, please start your own post and let us know the details of your issue. This rather than jump on the end of someone else's three year old post.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply