Get Oracle support merged into trunk

[Jason Baker]

We need to separate the Oracle backend into a separate branch so that it may be merged into trunk more easily.

[James Henstridge (jamesh)]

When you've got the branch ready for merging, click the "Propose for merging into another branch" button on the branch page and follow the prompts. We'll endeavour to review it then.

[James Henstridge (jamesh)]

I've declined the release series nomination here, since the main bug task can be used to track this bug: we aren't trying to back port this to some other parallel release series.

[Elric Milon (whirm)]

According to the conversation with Therve, I will dump my notes on the work I made trying to test oracle support branch for integration:

I used this one as it has some fixes that the original one still has not merged.

lp:~djfroofy/storm/oracle-support-patches

I followed this tutorial:

http://blogs.oracle.com/toxophily/entry/installing_oracle_11g_db_on

To install oracle in a 32 bit 10.10 Ubuntu

Notes:

You will need almost 3GB of ram available and ~10GB of free space for the installation/startup to succeed.
One package dependence is missing in the tutorial, you need to install libstdc++5
The useradd command is wrong, you need to add the commas in the group list:

   useradd -s /bin/bash -m -g oinstall -G dba,oracle,passwd oracle

After the installation finishes you will need to edit

   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

And replace its content with:

###########

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

#################

With this you should have a working oracle DB.

The connection URI should be something like this:

   oracle://test:test@172.0.0.10:1521/test?dsn=172.0.0.10:1521/orcl

Some other notes about the tests:

You will have to manually drop some tables as the tests are not cleaning them up and they will fail the second time you run them.

Some tests are failing and its database connections won't close, so when the limit is reached (about 114 open conns. in my case) all the remaining tests will fail.