orchoracle error message

pavan_test · Post by **pavan_test** » Wed Jul 02, 2008 8:17 pm

Hi All,

We are using DataStage 8.0.1 and Oracle 10G Data Base. When I try to view the data from oracle enterprise edition stage from a data stage job I am getting following error message;

"main_program: PATH search failure:
main_program: Error loading "orchoracle": Could not load "orchoracle":Could not load module orchoracle.o
System error: No such file or directory
<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
main_program: Creation of step finished with status = FAILED"

Software :
OS: AIX
Data Stage 8.0.1
Oracle 10g

Please advice how to address this problem.

Thanks
Mark

keshav0307 · Post by **keshav0307** » Wed Jul 02, 2008 8:20 pm

ah, the same error i faced.

you need to create another soft link orchoracle for the actual library file which is pointing to the oracle 10g library file

at $DSHOME/../PXEngine/lib

i have not connect now, so unable to give you the exact name.

pavan_test · Post by **pavan_test** » Wed Jul 02, 2008 8:49 pm

[quote="keshav0307"]ah, the same error i faced.

you need to create another soft link orchoracle for the actual library file which is pointing to the oracle 10g library file

at $DSHOME/../PXEngine/lib

i have not connect now, so unable to give you the exact name.[/quote]

I verified the PXEngine/lib directory and i could not orchoracle10g.o file.

can anyone please suggest me.

Thanks
Mark

keshav0307 · Post by **keshav0307** » Wed Jul 02, 2008 9:20 pm

you must be having liborchoracle10gi686.so file then

create a soft link using

ln -s liborchoracle10gi686.so orchoracle.so

pavan_test · Post by **pavan_test** » Thu Jul 03, 2008 8:24 am

[quote="keshav0307"]you must be having liborchoracle10gi686.so file then

create a soft link using

ln -s liborchoracle10gi686.so orchoracle.so[/quote]

Thanks.

Dshome/../PXEngine/lib
ls -ltra *liborchoracle10g*
*liborchoracle10g* not found

I do not have liborchoracle10g in my PXengine/lib directory. how do I create liborchoracle10g in my lib directory.

Thanks
Mark

keshav0307 · Post by **keshav0307** » Thu Jul 03, 2008 8:56 am

what does ls -l *orchoracle* return

pavan_test · Post by **pavan_test** » Thu Jul 03, 2008 8:59 am

[quote="keshav0307"]what does ls -l *orchoracle* return[/quote]

It returned:

*orchoracle* not found

Thanks
Mark

keshav0307 · Post by **keshav0307** » Thu Jul 03, 2008 9:29 am

then get it and register,

seems like something is missing in the installation

pavan_test · Post by **pavan_test** » Mon Jul 07, 2008 1:10 pm

when i try to view the data from Oracle EE stage i get the following mesg;
Could not load module IBM/../../InformationServer/../DSComponents/bin/orchoracle.o

However I have orchoracle.o file in this directory;
IBM /../../InformationServer/../DSComponents/bin/orchoracle10g.o

DS version: 8.0.1
Os: aix

can anyone advice me what am i missing here;

thanks
mark

pavan_test · Post by **pavan_test** » Mon Jul 07, 2008 9:24 pm

Datastage gurus help please

tx
Mark

pavan_test · Post by **pavan_test** » Mon Jul 07, 2008 10:05 pm

I have a dsenv file such as and i added the following for oracle connectivity;

# Environment variables added or modified for Oracle connectivity
#
TNS_ADMIN=/usr/lib/oracle/10.1.0.2/client
export TNS_ADMIN
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.1.0.2/client/lib
export LD_LIBRARY_PATH
ORACLE_HOME=/usr/lib/oracle/10.1.0.2/client/bin
export ORACLE_HOME
###################################################################
# Environment variables added or modified for orchadmin
#
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/Ascential/DataStage/PXEngine/lib
export LD_LIBRARY_PATH

I am still not able to view data from oracle enterprise stage.
I am trying to add $ORACLE_HOME/rdbms/lib32 and $ORACLE_HOME/lib32 in the dsenv file.

can anyone please suggest me where do I add the $ORACLE_HOME/lib32 and $ORACLE_HOME/rdbms/lib32 in the dsenv file.

can anyone please send me the sample dsenv file if you have it handy for oracle connectivity.

Thanks
Mark

add $ORACLE_HOME/lib32 and $ORACLE_HOME/rdbms/lib32 to your dsenv file
2. add datastage admin: dsadm to oracle dba group

ray.wurlod · Post by **ray.wurlod** » Tue Jul 08, 2008 12:22 am

As a general rule anything with "lib" in its name or with a suffix of ".so" needs to have itself (lib) or its parent directory (".so") in the shared library search path (LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH environment variable, depending on your flavour of UNIX). The order of directories in this list can be important. For example, for DataStage, any lib32 for a product must precede the lib for that product.

DSXchange