thanks a lot for the prompt answer,
I followed what is written in the BUILD.txt
But as you can see in the step 3) of build i face an error.
Do you have to give me any hint for that?
1) check that the link is there...
%S[%m]%s %~ %# ll /usr/lib/oracle/11.2/client/lib/
-rw-r--r-- 1 root root 342 Aug 14 2009 glogin.sql
lrwxrwxrwx 1 root root 17 Apr 22 17:33 libclntsh.so -> libclntsh.so.11.1
-rw-r--r-- 1 root root 40088477 Aug 14 2009 libclntsh.so.11.1
-rw-r--r-- 1 root root 6986848 Aug 14 2009 libnnz11.so
lrwxrwxrwx 1 root root 15 Apr 22 17:33 libocci.so -> libocci.so.11.1
-rw-r--r-- 1 root root 1879549 Aug 14 2009 libocci.so.11.1
-rw-r--r-- 1 root root 89377610 Aug 14 2009 libociei.so
-rw-r--r-- 1 root root 152304 Aug 14 2009 libocijdbc11.so
-rw-r--r-- 1 root root 1501651 Aug 14 2009 libsqlplusic.so
-rw-r--r-- 1 root root 1218075 Aug 14 2009 libsqlplus.so
-rw-r--r-- 1 root root 1996228 Aug 14 2009 ojdbc5.jar
-rw-r--r-- 1 root root 2111220 Aug 14 2009 ojdbc6.jar
-rw-r--r-- 1 root root 298388 Aug 14 2009 ottclasses.zip
-rw-r--r-- 1 root root 37807 Aug 14 2009 xstreams.jar
2) check the env variables
%S[%m]%s %~ %# echo $ORACLE_HOME
%S[%m]%s %~ %# echo $LD_LIBRARY_PATH
3) > build
%S[%m]%s %~ %# python setup.py build
building 'cx_Oracle' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -g -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fPIC -I/usr/include/oracle/11.2/client -I/usr/include/python2.4 -c cx_Oracle.c -o build/temp.linux-x86_64-2.4-11g/cx_Oracle.o -DBUILD_VERSION=5.0.3
cx_Oracle.c:6:20: error: Python.h: No such file or directory
cx_Oracle.c:7:22: error: datetime.h: No such file or directory
cx_Oracle.c:8:26: error: structmember.h: No such file or directory
In file included from cx_Oracle.c:97:
StringUtils.c:62: error: expected declaration specifiers or ... before PyObject
StringUtils.c: In function StringBuffer_FromUnicode:
StringUtils.c:64: error: obj undeclared (first use in this function)
StringUtils.c:64: error: (Each undeclared identifier is reported only once
StringUtils.c:64: error: for each function it appears in.)
StringUtils.c:76: warning: cast to pointer from integer of different size
StringUtils.c: At top level:
Yes, that's easy. You need the Python development files to successfully compile cx_Oracle (it's asking for Python.h). In Ubuntu its name is python-dev but I don't really know the name for that same package in your distro of choice.
Hope it helps.
I have to agree with cj to start looking on that side first (23 vs 64 bits). I have that kind of problems (missing ld libraries, nothing that a few symlinks couldn't solve) with instant client but with an standard client it has always been straightforward.
As an additional help check out the setup.py file from cx_Oracle. It tells you exactly where it is looking for the oracle home or ld library path (it uses the os.environ but sometimes it appens an extra path).