ImportError: cx_Oracle.so: cannot open shared object file: Permission denied

[Rhuddlan]

Hi,

I am using RedHat EL 4 and I developed an oracle 10g based
application by using cx_Oracle (cx_Oracle-4.3.1-10g-py23-1.i386.rpm) and Python 2.3.4.

Running the application through direct console, when I try to import the cx_Oracle, I get the following error message:

ImportError: /usr/lib/python2.3/site-packages/cx_Oracle.so: cannot open shared object file: No such file or directory

And it seems there is no any shared library lost:

ldd /usr/lib/python2.3/site-packages/cx_Oracle.so
linux-gate.so.1 => (0xffffe000)
libclntsh.so.10 .1 => /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10 .1 (0xf71ca000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7190000)
libc.so.6 => /lib/tls/libc.so.6 (0xf7061000)
libnnz10.so => /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so (0xf6e51000)
libdl.so.2 => /lib/libdl.so.2 (0xf6e4c000)
libm.so.6 => /lib/tls/libm.so.6 (0xf6e29000)
libnsl.so.1 => /lib/libnsl.so.1 (0xf6e12000)
/lib/ld-linux.so.2 (0x56555000)

some possible relevant settings in my profile:
#-------------------------------------------
ORACLE_BASE=/usr/lib/oracle/
ORACLE_HOME=$OR ACLE_BASE/10.2.0.4/client/
ORACLE_LIB=$ORA CLE_HOME/lib/
LD_LIBRARY_PATH =$LD_LIBRARY_PA TH:$ORACLE_LIB
#-------------------------------------------


How can I fix the problem?

Any help would be appreciated,
Rhuddlan

[Rhuddlan]

Found the answer myself: my RedHat EL4 is 64bits so I had to get the cx_Oracle source code and recompile it. Now it works!

[bvdet]

Rhuddlan - Thanks for sharing your solution. :)