Could not able to connect datastage with oracle 10g

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
Vennila_sky
Participant
Posts: 1
Joined: Wed Jun 25, 2008 3:34 am

Could not able to connect datastage with oracle 10g

Post by Vennila_sky »

I am not able to connect datastage 7.5X2 with oracle 10G...

It shows the following error:

##I TOSH 000002 17:57:30(001) <main_program> orchgeneral: loaded
##I TOSH 000002 17:57:30(002) <main_program> orchsort: loaded
##I TOSH 000002 17:57:30(003) <main_program> orchstats: loaded
>##E TOSH 000205 17:57:31(000) <main_program> PATH search failure:
>##E TOSH 000000 17:57:31(001) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 17:57:31(002) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 17:57:31(003) <main_program> Creation of step finished with status = FAILED



Please somebody give the solution for this...........
vasa_dxx
Participant
Posts: 39
Joined: Sun Sep 28, 2008 2:59 am
Contact:

Post by vasa_dxx »

Thanks for you posted the Error mesage in the first post !!!!!
Everybody here is to help you.

Are you trying to connect to Datastage from Oracle or while running the job your were thrown this error.
Two wrongs don't make a right. But three lefts do.
vasa_dxx
Participant
Posts: 39
Joined: Sun Sep 28, 2008 2:59 am
Contact:

Post by vasa_dxx »

Did you try searching for the same error messages in the Forum..

Some leads for you:

viewtopic.php?t=118664

viewtopic.php?t=122642
Two wrongs don't make a right. But three lefts do.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What version of Oracle client is installed on your DataStage server machine?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply