This is a list of files I use to compile cx_Oracle, php-oci amd perl DB::OCI on Linux. I set ORACLE_HOME to /usr/lib/oracle and symlink the *.so files in /usr/lib so that I don't need to set LD_LIBRARY_PATH. I guess this list can be reduced some more... but I got tired of experimenting
And the instant client 10.0 will work with a 9i database, but will not work with some 8.0 and 8.1 databases. /usr/lib/oracle/lib/classes12.jar /usr/lib/oracle/lib/libclntsh.so.10.1 /usr/lib/oracle/lib/libnnz10.so /usr/lib/oracle/lib/libocci.so.10.1 /usr/lib/oracle/lib/libociei.so /usr/lib/oracle/lib/libocijdbc10.so /usr/lib/oracle/lib/ojdbc14.jar /usr/lib/oracle/lib/libclntsh.so /usr/lib/oracle/lib/libocci.so /usr/lib/oracle/rdbms/ /usr/lib/oracle/rdbms/public/ /usr/lib/oracle/rdbms/public/nzerror.h /usr/lib/oracle/rdbms/public/nzt.h /usr/lib/oracle/rdbms/public/occi.h /usr/lib/oracle/rdbms/public/occiAQ.h /usr/lib/oracle/rdbms/public/occiCommon.h /usr/lib/oracle/rdbms/public/occiControl.h /usr/lib/oracle/rdbms/public/occiData.h /usr/lib/oracle/rdbms/public/occiObjects.h /usr/lib/oracle/rdbms/public/oci.h /usr/lib/oracle/rdbms/public/oci1.h /usr/lib/oracle/rdbms/public/oci8dp.h /usr/lib/oracle/rdbms/public/ociap.h /usr/lib/oracle/rdbms/public/ociapr.h /usr/lib/oracle/rdbms/public/ocidef.h /usr/lib/oracle/rdbms/public/ocidem.h /usr/lib/oracle/rdbms/public/ocidfn.h /usr/lib/oracle/rdbms/public/ociextp.h /usr/lib/oracle/rdbms/public/ocikpr.h /usr/lib/oracle/rdbms/public/ocixmldb.h /usr/lib/oracle/rdbms/public/odci.h /usr/lib/oracle/rdbms/public/oratypes.h /usr/lib/oracle/rdbms/public/ori.h /usr/lib/oracle/rdbms/public/orid.h /usr/lib/oracle/rdbms/public/orl.h /usr/lib/oracle/rdbms/public/oro.h /usr/lib/oracle/rdbms/public/ort.h /usr/lib/oracle/rdbms/public/xa.h /usr/lib/oracle/rdbms/demo/ /usr/lib/oracle/rdbms/demo/cdemo81.c /usr/lib/oracle/rdbms/demo/demo.mk /usr/lib/oracle/rdbms/demo/occidemo.sql /usr/lib/oracle/rdbms/demo/occidemod.sql /usr/lib/oracle/rdbms/demo/occidml.cpp -- http://mail.python.org/mailman/listinfo/python-list