DSXchange

Hello,

when I try to connect to oracle data base from data stage I am getting this error message.

Error loading "orchoracle": Could not load "orchoracle": Could not load module /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.o.
> Dependent module /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so could not be loaded.
> The module has an invalid magic number.

what is this invalid magic number the error message is refering to.
please advice me.

Thanks
Mark

From UNIX, try the commands What are the results?

what does ldd /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so do?

I could not read the complete response

Thanks
Mark

pavan_test wrote:I could not read the complete response

That part, at least, is easily remedied by your purchasing premium membership.

There are man pages on all UNIX commands including ldd.

ArndW wrote:From UNIX, try the commands

Code: Select all

file /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so

Code: Select all

ldd /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so

Code: Select all

ls -al /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so

What are the results?

I'm having the same issue here. I ran the file and ldd. This is what I get

# file /opt/OracleClient/product/11.1.0/client_1/lib32/libclntsh.so
/opt/OracleClient/product/11.1.0/client_1/lib32/libclntsh.so: executable
(RISC System/6000) or object module not stripped
#
# ldd /opt/OracleClient/product/11.1.0/client_1/lib32/libclntsh.so
/opt/OracleClient/product/11.1.0/client_1/lib32/libclntsh.so needs:
/usr/lib/libpthreads.a(shr_xpg5.o)
/usr/lib/libc.a(shr.o)
/usr/lib/libdl.a(shr.o)
/usr/lib/libperfstat.a(shr.o)
/usr/lib/libodm.a(shr.o)
/usr/lib/libc.a(aio.o)
/usr/lib/libpthreads.a(shr_comm.o)
/unix
/usr/lib/libcrypt.a(shr.o)
/usr/lib/libcfg.a(shr.o)
/usr/lib/libcorcfg.a(shr.o)
/usr/lib/liblvm.a(shr.o)
/usr/lib/libsrc.a(shr.o)

It would seem that the library should work. The "file" command only checks the initial bytes, so it could be corrupted - yet the "ldd" command doesn't show an error. Could it be a 64bit library in the 32bit directory or is the date-time modifed different from the other objects in that directory?
Does "dump -ah -X32 /u01/app/oracle/product/10.2.0/db/lib32/libclntsh.so" give any errors? (it will produce a page or two of cryptic output).