Oracle Configuration Problem

[praburaj]

Hi
I have installed Datastage successfully . I tried configuring oracle reading the manuals where they have asked me environment variable and do the settings .I created user defined variables and set accordingly but i couldnt able to view the data through oracle enterprise edition stage.
I am getting following error message

##I TOSH 000002 04:05:22(001) <main_program> orchgeneral: loaded
##I TOSH 000002 04:05:22(002) <main_program> orchsort: loaded
##I TOSH 000002 04:05:22(003) <main_program> orchstats: loaded
>##E TOSH 000205 04:05:22(004) <main_program> PATH search failure:
>##E TOSH 000000 04:05:22(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 04:05:22(006) <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 04:05:22(007) <main_program> Creation of step finished with status = FAILED

I have also tried the following
export APT_ORCHHOME=C:\Ascential\DataStage\PXEngine
export PATH=$PATH:$APT_ORCHHOME\bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$APT_ORCHHOME\lib

Any help can be appreciated
Regards,
Praburaj

[ArndW]

Did you put these exports into the dsenv file in your DSHOME directory? If not, then changing the setting in your user's environment doesn't affect the background DS processes. If you look into your director log for the file it will echo the environment settings - are the correct entries shown there?

[lstsaur]

Hi Praburaj,
Are you running 7.5x2 EE on the Windows platform? If it is, then do the following:
1. cd to your C:\Ascential\DataStage\PXEngine\install
2. type sh
3. ORACLE_HOME="C:/Your_Oracle_Client"
4. export ORACLE_HOME
5. APT_ORCHHOME="C:/Ascential/DataStage/PXEngine"
6. export APT_ORCHHOME
7. sh install.liborchoracle
then you will see the message on the screen;
Installing Oracle Drvie
Using C:/Your_Oracle_Client as ORACLE_HOME
Installing drive for Oracle version 9i or 10g
Oracel installation is complete.

Reboot the machine after above is done.
Please let me know the results.

[praburaj]

Hi Istsaur,
Thank you very much for your reply.
Oracle driver installed perperly
but again when i am viewing data from oracle stage
i got follwing error
i am using oracle 8i
Kindly rectify the error


##I TOSH 000002 22:29:21(000) <main_program> orchgeneral: loaded
##I TOSH 000002 22:29:22(000) <main_program> orchsort: loaded
##I TOSH 000002 22:29:22(001) <main_program> orchstats: loaded
>##E TOSH 000205 22:29:23(000) <main_program> PATH search failure:
>##E TOSH 000000 22:29:23(001) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable PATH; path: /C=/Ascential/DataStage/PXEngine/bin:/C=/PROGRA~1/MKSTOO~1/mksnt:/C=/PROGRA~1/MKSTOO~1/bin:/C=/Program Files/Microsoft Visual Studio .NET 2003/Common7/IDE/:/C=/Program Files/Microsoft Visual Studio .NET 2003/VC7/BIN:/C=/Program Files/Microsoft Visual Studio .NET 2003/Common7/Tools:/C=/Program Files/Microsoft Visual Studio .NET 2003/Common7/Tools/bin/prerelease:/C=/Program Files/Microsoft Visual Studio .NET 2003/Common7/Tools/bin:/C=/Program Files/Microsoft Visual Studio .NET 2003/SDK/v1.1//bin:/C=/WINNT/Microsoft.NET/Framework//v1.1.4322:/C=/Ascential/DataStage/Projects/dw90/wrapped:/C=/Ascential/DataStage/Projects/dw90/buildop:/C=/Ascential/DataStage/DSCAPIOp:/C=/Ascential/DataStage/RTIOperators:/C=/Ascential/DataStage/DSParallel:/C=/Ascential/DataStage/PXEngine/user_osh_wrappers:/C=/Ascential/DataStage/PXEngine/osh_wrappers:/C=/Ascential/DataStage/PXEnginein:/D=/Oracle/Ora81/bin:/C=/Program Files/Oracle/jre/1.1.7/bin:/C=/oracle/bin:/C=/oracle/jre/1.4.2/bin/client:/C=/oracle/jre/1.4.2/bin:/C=/PROGRA~1/MKSTOO~1/bin:/C=/PROGRA~1/MKSTOO~1/bin/X11:/C=/PROGRA~1/MKSTOO~1/mksnt:/C=/WINNT/system32:/C=/WINNT:/C=/WINNT/System32/Wbem:/C=/Ascential/ODBCdrivers
>##E TOSH 000000 22:29:23(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 22:29:23(003) <main_program> Creation of step finished with status = FAILED


Regards,
Praburaj

[lstsaur]

Praburaj,
Looking at your PATH environment variable made me wondering how would the system find anything?
According to your note, you are running 7.5x2 EE on the Windows platform, then you should have your PATH environment variable like something below:
PATH=C:\Ascential\DataStage\PXEngine\bin;C:\Ascential\DataStage\PXEngine\osh_wrappers;
C:\Ascential\DataStage\PXEngine\user_osh_wrappers;C:\Ascential\DataStage\PXEngine\user_osh_wrappers;
C:\Ascential\DataStage\DSCAPIOp;C:\Ascential\DataStage\RTIOperators;C:\Ascential\DataStage\DSParallel;
C:\Ascential\DataStage\Projects\Dev4PX\RT_BP1.O;C:\Ascential\DataStage\Engine\bin;C:\Ascential\DataStage\Projects\Dev4PX\buildop;C:\Ascential\DataStage\Projects\Dev4PX\wrapped;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\PROGRA~1\MKSTOO~1\mksnt;C:\PROGRA~1\MID05A~1\Common7\IDE\PRIVAT~1\;D:\MICROS~2\90\Tools\Binn\VSShell\Common7\IDE\;D:\MICROS~2\90\DTS\Binn\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\PROGRA~1\ASCENT~1\METAST~1\PROCES~1;D:\MICROS~2\90\Tools\binn\;C:\oracle\ora10g\bin;C:\oracle\ora10g\jre\14268D~1.2\bin\client;C:\oracle\ora10g\jre\14268D~1.2\bin;C:\ORACLI~1\bin;C:\ORACLI~1\jre\14268D~1.2\bin\client;C:\OraClient10g\jre\1.4.2\bin;C:\OraClient10g\BIN