[sakai2-tcc] Oracle Database Support

[Matthew Jones]

In addition, it also looks like the extended support has ended for Oracle
9i. Oracle 10 is supported on an extended basis through 2013, but it seems
like most would probably be looking to upgrade to 11. I think this is a good
question to ask. This became an issue lately with conversion scripts, as
most of them were written (on the oracle side) for 10g specific functions,
and it really made writing them quite a bit easier. We also could
potentially take advantage of feature of newer database if we weren't
supporting older versions.

This discussion should probably also include mysql but I don't know enough
about that platform, as we aren't actively running it.

http://www.orafaq.com/wiki/Oracle_9i

Oracle 9i Release 2 (9.2.0)

Status: Desupported, however, Oracle has waived their usual fees for
extended support until July 2008 </wiki/2008>. For more info, see
http://www.oracle.com/features/hp/database-9i-support.html
Last patch-set: 9.2.0.8

Premier Support Ends: 31-Jul-2007 </wiki/2007>
Extended Support Ends: 30-Jul-2010 </wiki/2010>

Oracle 10g Release 2 (10.2.0)

In July 2005 </wiki/2005>, Oracle Database 10.2.0.1 - also known as Oracle
Database 10g Release 2 (10gR2) - was released.

Status: Supported
Latest patch-set: 10.2.0.5 (the terminal patch set for this release)

Premier Support Ends: 31-Jul-2010 </wiki/2010> (First Year Extended Support
fees waived, so it will be fully supported until 31-Jul-2011 </wiki/2011>)
Extended Support Ends: 31-Jul-2013 </wiki/2013>

On Wed, Aug 18, 2010 at 4:57 PM, Beth Kirschner <bkirschn at umich.edu> wrote:

> Hi all,
>
> Michigan is looking into upgrading its Oracle database to Oracle 11g,
> and I wonder if it's time for Sakai to revisit the supported database/
> Oracle versions. According to our release page (
> http://source.sakaiproject.org/release/2.7.0/
> ), we support Oracle 9i and 10g. According to wikipedia (the only
> place I could find an easy timeline of oracle releases), Oracle
> released its database versions as follows:
>
> • 2001: Oracle9i went into release
> • 2003: Oracle Corporation released Oracle Database 10g
> • 2007: Oracle Corporation released Oracle Database 11g
>
> So this means we're supporting Oracle 9i (9 years old), and not
> supporting the latest Oracle 11g release (3 years old). I suppose that
> as long as we're running QA servers on the various Oracle versions, we
> can count that as "supported", but perhaps there are other criteria
> for "supported"? Michigan can probably offer a QA server running
> against Oracle 11g, perhaps next year (2011), but the larger question
> of what versions do we officially "support" needs to be decided by
> some group...
>
> Thoughts?
>
> - Beth
>
> _______________________________________________
> sakai2-tcc mailing list
> sakai2-tcc at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai2-tcc
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20100818/04acb9f4/attachment.html