connect to toracle

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
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

connect to toracle

Post by vasubabu »

Hi,

i am getting the below error when connecting to oracle from datasatge using OCI stage.
Working on windows with parellel edition(DS 8.0).


##I IIS-DSEE-TOSH-00002 10:39:17(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:39:18(000) <main_program> Parameter specified but not used in flow: FilePathName
##W IIS-DSEE-TOSH-00049 10:39:18(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOSH-00205 10:39:18(002) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 10:39:18(003) <main_program> Error loading "liborchoraclent": Could not load "liborchoraclent": %1 is not a valid Win32 application. .
>##E IIS-DSEE-TOSH-00384 10:39:18(004) <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 IIS-DSEE-TCOS-00029 10:39:18(005) <main_program> Creation of a step finished with status = FAILED.
>

Can anybody give the solution to solve this issue.
VASU..
Top
mahadev.v
Participant
Posts: 111
Joined: Tue May 06, 2008 5:29 am
Location: Bangalore

Post by mahadev.v »

Do an exact search on "liborchoraclent". See if one of the posts help. And i dont know if "toracle" is a supported by DataStage :wink:
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Do you actually have an Oracle client installed on your DataStage server? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Post by vasubabu »

chulett wrote:Do you actually have an Oracle client installed on your DataStage server? :? ...

Not instaled the oracle client serperatle.i have installed the oracle 10g server in that machine.So Cilent will also be available.
VASU..
Top
BenoitCayla
Participant
Posts: 15
Joined: Wed May 27, 2009 2:42 am
Location: PARIS

Re: connect to toracle

Post by BenoitCayla »

vasubabu wrote:Hi,

i am getting the below error when connecting to oracle from datasatge using OCI stage.
Working on windows with parellel edition(DS 8.0).


##I IIS-DSEE-TOSH-00002 10:39:17(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:39:18(000) <main_program> Parameter specified but not used in flow: FilePathName
##W IIS-DSEE-TOSH-00049 10:39:18(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOSH-00205 10:39:18(002) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 10:39:18(003) <main_program> Error loading "liborchoraclent": Could not load "liborchoraclent": %1 is not a valid Win32 application. .
>##E IIS-DSEE-TOSH-00384 10:39:18(004) <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 IIS-DSEE-TCOS-00029 10:39:18(005) <main_program> Creation of a step finished with status = FAILED.
>

Can anybody give the solution to solve this issue.
Did you :
1) check the environment variables in you dsenv file :
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/client
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib; export LD_LIBRARY_PATH

2) install the DataStage Oracle plugin (install.liborchoracle) ?
___________________
Benoît CAYLA
benoit.cayla@exl-group.com
my blog (in French) http://www.exl-infosfr.com/
Top
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Re: connect to toracle

Post by vasubabu »

BenoitCayla wrote:
vasubabu wrote:Hi,

i am getting the below error when connecting to oracle from datasatge using OCI stage.
Working on windows with parellel edition(DS 8.0).


##I IIS-DSEE-TOSH-00002 10:39:17(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:39:18(000) <main_program> Parameter specified but not used in flow: FilePathName
##W IIS-DSEE-TOSH-00049 10:39:18(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOSH-00205 10:39:18(002) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 10:39:18(003) <main_program> Error loading "liborchoraclent": Could not load "liborchoraclent": %1 is not a valid Win32 application. .
>##E IIS-DSEE-TOSH-00384 10:39:18(004) <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 IIS-DSEE-TCOS-00029 10:39:18(005) <main_program> Creation of a step finished with status = FAILED.
>

Can anybody give the solution to solve this issue.
Did you :
1) check the environment variables in you dsenv file :
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/client
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib; export LD_LIBRARY_PATH

2) install the DataStage Oracle plugin (install.liborchoracle) ?

I am working on widows so i will not have the dsenv file.
where can i add this variables?
VASU..
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Control Panel > System > Environment

However, DataStage is just another client application as far as Oracle is concerned, so you WILL need Oracle client software installed on the DataStage server.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Post by vasubabu »

ray.wurlod wrote:Control Panel > System > Environment

However, DataStage is just another client application as far as Oracle is concerned, so you WILL need Oracle client software installed on the DataStage se ...
i have not installed the client seperatly.i have installed the oracle 10g server.so we can get both the client and server as well.
am i correct?or do we need to install the client also.
VASU..
Top
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Re: connect to toracle

Post by vasubabu »

BenoitCayla wrote:
vasubabu wrote:Hi,

i am getting the below error when connecting to oracle from datasatge using OCI stage.
Working on windows with parellel edition(DS 8.0).


##I IIS-DSEE-TOSH-00002 10:39:17(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:39:17(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:39:18(000) <main_program> Parameter specified but not used in flow: FilePathName
##W IIS-DSEE-TOSH-00049 10:39:18(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOSH-00205 10:39:18(002) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 10:39:18(003) <main_program> Error loading "liborchoraclent": Could not load "liborchoraclent": %1 is not a valid Win32 application. .
>##E IIS-DSEE-TOSH-00384 10:39:18(004) <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 IIS-DSEE-TCOS-00029 10:39:18(005) <main_program> Creation of a step finished with status = FAILED.
>

Can anybody give the solution to solve this issue.
Did you :
1) check the environment variables in you dsenv file :
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/client
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib; export LD_LIBRARY_PATH

2) install the DataStage Oracle plugin (install.liborchoracle) ?

i am installing the plug in(install.liborchoracle).i am getting the error as don't have write permission exiting. but i am administrator to that mechine.
VASU..
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”