Code

Changes between Version 4 and Version 5 of OracleBranch


Ignore:
Timestamp:
04/19/07 15:23:53 (7 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 ===