connect to toracle
Moderators: chulett, rschirm, roy
connect to toracle
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.
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..
-
- Participant
- Posts: 15
- Joined: Wed May 27, 2009 2:42 am
- Location: PARIS
Re: connect to toracle
Did you :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.
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/
Benoît CAYLA
benoit.cayla@exl-group.com
my blog (in French) http://www.exl-infosfr.com/
Re: connect to toracle
BenoitCayla wrote:Did you :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.
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..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.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 ...
am i correct?or do we need to install the client also.
VASU..
Re: connect to toracle
BenoitCayla wrote:Did you :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.
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..