[Deploying Sakai] Oracle question from DBA

[Dario P]

1) We have been working with Oracle 11g r2, since aug/2011, no problems
at all so far.

2) Blobs are stored in long type columns in Oracle. That won't make your
dba happy precisely... Long columns are deprecated in Oracle since ages.
Use file system approach.

You could use the posix file system that Oracle 11g r2 has
( http://www.oracle-base.com/articles/11g/DBFS_11gR2.php )  in order to
simplify your backups , but I did not test it myself, and do not know
anything performance, stability and compatibility.

Greetings

(sorry for my english)



-----Mensaje original-----
De: Colin Tatham <colin.tatham at unimelb.edu.au>
Para: production <production at collab.sakaiproject.org>
Asunto: [Deploying Sakai] Oracle question from DBA
Fecha: Thu, 8 Sep 2011 00:49:37 +0000

Hi

I've been asked a couple of questions regarding our future move from
commercial hosting to in-house, if anyone has any views please?

* Confirm application support for Oracle 11g R2
I see quite a few 11g deployments in the Jira deployment details, but the
database support page in Confluence implies that it's not supported?


* Any stored code, stored procedures, triggers?

Also, if we went with an Oracle DB, we'd be migrating from the current MySQL
DB to Oracle. The current configuration is to store blobs in the DB instead
of the file system, and we'd probably have to continue doing that to avoid
complication :-(

Thanks

Colin