oracle 10g

vasubabu · Post by **vasubabu** » Sat Apr 18, 2009 8:39 am

Hi,

i am working with datastage 8.0.1 on windows.database is oracle 10g.
i am using the oracle enterprise stage.
i am not able to connect to database.
can anybody gide me if there is any parameters or environment variables to be set to connect to oracle 10g.

chulett · Post by **chulett** » Sat Apr 18, 2009 11:37 am

It's all in the docs that ship with the product, Installation and Configuration Guide and elsewhere. Not able to connect how? What happens?

vasubabu · Post by **vasubabu** » Sun Apr 19, 2009 1:11 am

chulett wrote:It's all in the docs that ship with the product, Installation and Configuration Guide and elsewhere. Not able to connect how? What happens? ...

when i am trying to view data from oracle enter prise stage getting the error like check the PATH in the environment.
i have read in installation guide it is saying that in dsenv file we need to do some changes.
bt i didnt find the dsenv file in dsengine folder in server.

chulett · Post by **chulett** » Sun Apr 19, 2009 7:16 am

You read the UNIX instructions, you need to find the DOS/Windows instructions as there's no "dsenv" file on a Windows server.

nirdesh2 · Post by **nirdesh2** » Sun Apr 19, 2009 1:39 pm

You have to set Oracle Database path in Environment variable and also have to set ORACLE_SID,LIBPATH and ORACLE_HOME in user defined variable to work with Database on windows. All these information are available in document under Oracle Enterprise Stage.

vasubabu · Post by **vasubabu** » Mon Apr 20, 2009 5:34 am

nirdesh2 wrote:You have to set Oracle Database path in Environment variable and also have to set ORACLE_SID,LIBPATH and ORACLE_HOME in user defined variable to work with Database on windows. All these information are available in document under Oracle Enterprise Stage.

i am getting the error like this when i am trying to view data.
*********************
>##E IIS-DSEE-TOSH-00205 16:59:15(011) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 16:59:15(012) <main_program> Error loading "liborchoraclent": Could not load "liborchoraclent": %1 is not a valid Win32 application. .
>##E IIS-DSEE-TOSH-00384 16:59:15(013) <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 16:59:15(014) <main_program> Creation of a step finished with status = FAILED.
***********************
can you please check this one?

chulett · Post by **chulett** » Mon Apr 20, 2009 7:50 am

Better if you check the documentation noted and ensure your server is setup correctly, environment variable wise. All those messages confirm is that it isn't.

vasubabu · Post by **vasubabu** » Mon Apr 20, 2009 10:48 pm

chulett wrote:Better if you check the documentation noted and ensure your server is setup correctly, environment variable wise. All those messages confirm is that it isn't. ...

can you please tell what are the thins i can check.

chulett · Post by **chulett** » Mon Apr 20, 2009 11:27 pm

Nirdesh has already done that for you.