Changes between Version 4 and Version 5 of OracleBranch

Timestamp:

Apr 19, 2007, 5:23:53 PM (19 years ago)

Author:

anonymous

Comment:

Added info on how to test for Oracle

OracleBranch

@@ -18 +18 @@
 
 == Status ==
+
+A patch against the current trunk is ready and attached to this wiki page.  We can always use more help testing.  Here's how:
+
+  * Install an Oracle 9i or 10g database.  The free [http://www.oracle.com/technology/software/products/database/xe/index.html Oracle Express Edition] is a simple .deb or .rpm package install on most Linuxes, or an .exe installer on Windows.
+  * To run "python manage.py syncdb," you'll need to create a user who has CREATE TABLE, CREATE SEQUENCE, and CREATE PROCEDURE privileges.  To run Django's test suite, your user also needs CREATE|DROP DATABASE privileges.
+  * Install the [http://www.python.net/crew/atuining/cx_Oracle/ cx_Oracle] driver so python can talk to your new database.  Version 4.3.1 or later of cx_Oracle is preferred.
+
+Then set up your Django settings.py file to include something like this:
+{{{
+DATABASE_ENGINE = 'oracle'
+DATABASE_NAME = 'xe'
+DATABASE_USER = 'a_user' 
+DATABASE_PASSWORD = 'a_password'
+DATABASE_HOST = ''
+DATABASE_PORT = ''
+}}}
+If you don't have a tnsnames.ora file or a similar Oracle naming method that recognizes the SID ('xe' in this example), then fill in both DATABASE_HOST and DATABASE_PORT like so:
+{{{
+DATABASE_ENGINE = 'oracle'
+DATABASE_NAME = 'xe'
+DATABASE_USER = 'a_user' 
+DATABASE_PASSWORD = 'a_password'
+DATABASE_HOST = 'dbprod01ned.mycompany.com'
+DATABASE_PORT = '1540'
+}}}
+You should supply both DATABASE_HOST and DATABASE_PORT, or leave both as empty strings.
 
 === Tablespace options ===