connectivity to oracle

pavan_test · Post by **pavan_test** » Tue Jun 02, 2009 7:49 am

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

ArndW · Post by **ArndW** » Tue Jun 02, 2009 8:22 am

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?

pavan_test · Post by **pavan_test** » Tue Jun 02, 2009 8:54 am

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

I could not read the complete response

Thanks
Mark

ray.wurlod · Post by **ray.wurlod** » Tue Jun 02, 2009 4:16 pm

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.

pjsimon20 · Post by **pjsimon20** » Wed Sep 16, 2009 9:07 pm

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)

ArndW · Post by **ArndW** » Thu Sep 17, 2009 1:57 am

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).

DSXchange