Changes between Version 4 and Version 5 of OracleBranch


Ignore:
Timestamp:
04/19/07 17:23:53 (8 years ago)
Author:
anonymous
Comment:

Added info on how to test for Oracle

Legend:

Unmodified
Added
Removed
Modified
  • OracleBranch

    v4 v5  
    1818
    1919== Status ==
     20
     21A patch against the current trunk is ready and attached to this wiki page.  We can always use more help testing.  Here's how:
     22
     23  * 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.
     24  * 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.
     25  * 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.
     26
     27Then set up your Django settings.py file to include something like this:
     28{{{
     29DATABASE_ENGINE = 'oracle'
     30DATABASE_NAME = 'xe'
     31DATABASE_USER = 'a_user'
     32DATABASE_PASSWORD = 'a_password'
     33DATABASE_HOST = ''
     34DATABASE_PORT = ''
     35}}}
     36If 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:
     37{{{
     38DATABASE_ENGINE = 'oracle'
     39DATABASE_NAME = 'xe'
     40DATABASE_USER = 'a_user'
     41DATABASE_PASSWORD = 'a_password'
     42DATABASE_HOST = 'dbprod01ned.mycompany.com'
     43DATABASE_PORT = '1540'
     44}}}
     45You should supply both DATABASE_HOST and DATABASE_PORT, or leave both as empty strings.
    2046
    2147=== Tablespace options ===
Back to Top