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.

Prerequisities

Install Oracle client and set it up as documented in https://docs.djangoproject.com/en/1.4/ref/databases/#oracle-notes Install GeoDjango requirements as documented in https://docs.djangoproject.com/en/1.4/ref/contrib/gis/install/

How to get full Oracle

Easiest way is to use Oracle VirtualBox with prebuilt Oracle installation VM.

1. Download and install Oracle VirtualBox from http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html or use package manager from your system.
2. Download Oracle Developer Day image from http://download.oracle.com/otn/other/virtualbox/dd/Oracle_Developer_Day.ova

NOTE: You may not use Oracle Developer Day VM for any other purposes than testing

Database setup

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

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

   TEST_RUNNER = 'django.contrib.gis.tests.GeoDjangoTestSuiteRunner'
   
   DATABASES = {
       'default' : {
               'ENGINE' : 'django.contrib.gis.db.backends.oracle',
               'PORT' : '1521',
               'HOST' : '192.168.56.101',
               'NAME' : 'orcl',
               'USER' : 'djangotest',
               'PASSWORD' : 'djangotest',
       },
   }
   

2. Run tests:

   django-admin.py test --settings=geodjango_oracle