Differences between revisions 9 and 27 (spanning 18 versions)

Oracle

URL: http://www.oracle.com/index.html
FAQ: http://www.orafaq.com/
Wiki: http://www.orawiki.com/
Wikipedia: http://en.wikipedia.org/wiki/Oracle_database
license: commercial/proprietary; free for development from [http://www.oracle.com/technology//index.html Oracle Technology Network]; [http://www.oracle.com/technology/software/products/database/xe/index.html Oracle XE] is free for production and development (and an excellent option all-around)
platforms: Unix, Linux, win32, win64

Pros

Reputation for being capable of handling large scale databases
Typically the database system others compare themselves to

Cons

Requires bloated Oracle client installation on any machine that the app will run on
Frequently the subject of migration discussions (to alternatives), usually for reasons of cost

DB API 2.0 Drivers

DCOracle2

URL: http://www.zope.org/Members/matt/dco2
licence: ZPL
platforms: Unix, win32
Python versions

cx_Oracle

URL: http://cx-oracle.sourceforge.net/
licence: [http://www.computronix.com/download/License(cxOracle).txt BSD like]
platforms: Unix, win32
Python versions: 2.2 - 2.5
Oracle versions: 8i - 11g

mxODBC

URL: http://www.egenix.com/products/python/mxODBC/
Licence: eGenix Commercial License
Platforms: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions: 2.1 - 2.5

mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the [http://www.oracle.com/technology/tech/oci/instantclient/index.html Oracle Instance Client].

Supported Python Applications

["Zope"]
an Oracle (DCOracle and DCOracle2) driver exists for ["PyDO"] (Python Data Objects)

Web Links

[http://www.orafaq.com/forum Oracle Forum]

Oracle Wiki's: [http://www.orafaq.com/wiki English] [http://www.oracle-10g.de/oracle-wiki German]

Oracle Documentation: [http://www.oracle-doku.de/oracle_10g_documentation/index.htm 10g] [http://www.oracle-doku.de/oracle_9i_documentation/index.htm 9i] [http://www.oracle-doku.de/oracle_8i_documentation/index.htm 8i] [http://www.oracle-doku.de/oracle_7_documentation/index.htm 7]

-  ⇤ ← Revision 9 as of 2005-01-21 19:33:47 → 
  Size: 2206
  Editor: 12
  Comment:
+   ← Revision 27 as of 2008-08-07 12:22:33 → ⇥
  Size: 2317
  Editor: 202
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 2:
-[[TableOfContents]]
-Line 4:
+Line 3:
-== Masthead ==
+= Oracle =
-Line 6:
+Line 5:
-  URL:: http://www.oracle.com/ip/deploy/database/oracle9i/
+  URL:: http://www.oracle.com/index.html
-Line 8:
+Line 7:
-  licence:: commercial (free development versions available on http://technet.oracle.com/)
  platforms:: Unix, win32
+  Wiki:: http://www.orawiki.com/
  Wikipedia:: http://en.wikipedia.org/wiki/Oracle_database
  license:: commercial/proprietary; free for development from [http://www.oracle.com/technology//index.html Oracle Technology Network]; [http://www.oracle.com/technology/software/products/database/xe/index.html Oracle XE] is free for production and development (and an excellent option all-around)
  platforms:: Unix, Linux, win32, win64

== Pros ==

 * Reputation for being capable of handling large scale databases
 * Typically the database system others compare themselves to

== Cons ==

 * Requires bloated Oracle client installation on any machine that the app will run on
 * Frequently the subject of migration discussions (to alternatives), usually for reasons of cost

----
-Line 20:
+Line 33:
-==== Extensions to DB API ====

==== Comments ====
-Line 26:
+Line 35:
-  URL:: http://www.computronix.com/utilities.shtml
+  URL:: http://cx-oracle.sourceforge.net/
-Line 29:
+Line 38:
-  Python versions:: 2.0 - 2.2
+  Python versions:: 2.2 - 2.5
  Oracle versions:: 8i - 11g
-Line 31:
+Line 41:
-==== Extensions to DB API ====
+=== mxODBC ===
-Line 33:
+Line 43:
-==== Comments ====
+  URL:: http://www.egenix.com/products/python/mxODBC/
  Licence:: eGenix Commercial License
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
  Python versions:: 2.1 - 2.5
-Line 35:
+Line 48:
-While trying to install the cx_Oracle Python utility, I encounter the following error:
+mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the [http://www.oracle.com/technology/tech/oci/instantclient/index.html Oracle Instance Client].
-Line 37:
+Line 50:
-   sh-2.05b# python setup.py build

running build

running build_ext

building 'cx_Oracle' extension

gcc -pthread -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -I/devtools/oracle/product/8.1.5/rdbms/demo -I/devtools/oracle/product/8.1.5/rdbms/public -I/devtools/oracle/product/8.1.5/network/public -I/usr/local/python2.4/include/python2.4 -c cx_Oracle.c -o build/temp.linux-i686-2.4/cx_Oracle.o -DBUILD_TIME="January 21, 2005 11:19:47"

cx_Oracle.c:10: xa.h: No such file or directory

error: command 'gcc' failed with exit status 1

 

Where can I find the xa.h file?  The only package I could find online that provides any such file is a cd i/o library, and that doesn’t seem right.

I am running a 2.4 linux kernel, trying to install cx_Oracle-4.0.1 on top of Python 2.4.

I have tried the beta package which should be more 2.4 compatible, but still no luck.  Any help is appreciated.  Thanks!

== Other Drivers ==

=== driver name ===

  URL:: 
  licence::
  platforms::
  Python versions::

==== Programming Model ====

==== Comments ====
+----
-Line 79:
+Line 57:
-== Pros ==
+== Web Links ==
-Line 81:
+Line 59:
-== Cons ==
 * Requires bloated Oracle client installation on any machine that the app will run on
+[http://www.orafaq.com/forum Oracle Forum]

Oracle Wiki's: [http://www.orafaq.com/wiki English] [http://www.oracle-10g.de/oracle-wiki German]

Oracle Documentation: [http://www.oracle-doku.de/oracle_10g_documentation/index.htm 10g] [http://www.oracle-doku.de/oracle_9i_documentation/index.htm 9i] [http://www.oracle-doku.de/oracle_8i_documentation/index.htm 8i] [http://www.oracle-doku.de/oracle_7_documentation/index.htm 7]

Page

User