[OT] Oracle 9i client for Linux

[Andy Leszczynski]

Where can I find such? I can download from Oracle whole thing but no the
client itself.

Any insight?

Thanks, A.

 

[Andy Leszczynski]

Look into the Oracle Instant Client:
<http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html>
(might require a -free- OTN registration)

It is version 10, would it be compatible with 9i servers?

Be sure to download the smallish "sdk" if you want to compile client code
(e.g. cx_oracle - highly recommended

Indeed I use cx_oracle but on M$ yet. Want to move to Linux.

A.

 

[=?ISO-8859-1?Q?Bernard_Delm=E9e?=]

Where can I find such? I can download from Oracle whole thing but no the
client itself.

Look into the Oracle Instant Client:
<http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html>
(might require a -free- OTN registration)
Be sure to download the smallish "sdk" if you want to compile client code
(e.g. cx_oracle - highly recommended!)

Hope this helps,

Bernard.

 

[=?ISO-8859-1?Q?Bernard_Delm=E9e?=]

It is version 10, would it be compatible with 9i servers?

Yes.

Indeed I use cx_oracle but on M$ yet. Want to move to Linux.

If you need to compile yourself, the instant client
headers don't live where a full-blown Oracle install
would put them and you may need to slightly alter
setup.py. cx_oracle has a support list, see
http://sourceforge.net/projects/cx-oracle/

Cheers,

Bernard.

 

[Damjan]

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