Version 3 (modified by Anssi Kääriäinen, 6 years ago) (diff)


Preparing an Oracle GeoDjango test setup

Since GeoDjango requires full featured Oracle installation instead of XE this document is meant to ease up installation and testing GeoDjango parts.


On host machine:

How to get full Oracle

Easiest way is to use Oracle VirtualBox with prebuilt Oracle installation VM. We will be using the VM as a database server only.

  1. Download and install Oracle VirtualBox from or use package manager from your system.
  2. Download Oracle Developer Day image from
  3. Use VirtualBox to launch the image
NOTE: You may not use Oracle Developer Day VM for any other purposes than testing

Database setup

On virtual machine:

  1. Create a user and give the needed privileges:

    $ sudo su oracle
    $ sqlplus / as sysdba
    SQL> CREATE USER djangotest IDENTIFIED BY djangotest;
    SQL> GRANT DBA TO djangotest;
    SQL> quit
    $ exit

Run tests

On host:

  1. Create settings file (change IP to one that is reported in VM console):

    TEST_RUNNER = 'django.contrib.gis.tests.GeoDjangoTestSuiteRunner'
        'default' : {
                'ENGINE' : '',
                'PORT' : '1521',
                'HOST' : 'VM IP',
                'NAME' : 'orcl',
                'USER' : 'djangotest',
                'PASSWORD' : 'djangotest',
    SECRET_KEY = 'xxxxx'
  2. Run tests: test --settings=geodjango_oracle
Back to Top