[sakai-production] Sakai 2.9.2 + Oracle 12c

classic Classic list List threaded Threaded
3 messages Options
Zhen Qian Zhen Qian
Reply | Threaded
Open this post in threaded view
|

[sakai-production] Sakai 2.9.2 + Oracle 12c

Hi, all:

The Sakai instance running in University of Michigan is still based on Sakai 2.9.2 and Kernel 1.3.2, with Oracle 11g database.  Since the extended support fee for Oracle 11g is waived until May 31, 2017, we are now investigating the possibility of using Oracle 12c database.

Does anyone have experience of running Sakai 2.9.2 with Oracle 12c? Are there any known issues? Any patch needed?

Thanks in advance. 

- Zhen

---------------------------------------------------------
Zhen Qian
Interim Application Development Manager
Teaching and Learning
ITS, University of Michigan
734-239-5118
zqian at umich.edu
----------------------------------------
----------------- 

--
You received this message because you are subscribed to the Google Groups "Sakai Production" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-production/.
Leonardo Canessa Leonardo Canessa
Reply | Threaded
Open this post in threaded view
|

Re: [sakai-production] Sakai 2.9.2 + Oracle 12c

The only issue I know with Oracle 12c is related to an optimizer setting, see this post for more information. I am not a DBA, but I thought I heard that the bug had been fixed in later versions of 12c.

I highly recommend upgrading to a more recent version of Sakai, as 2.9.x is no longer supported.

Leonardo Canessa
Web Developer - E-Learning
<a href="tel:(937)%20229-2085" value="+19372292085" target="_blank">937-229-2085

On Fri, Jan 6, 2017 at 3:44 PM, zqian <[hidden email]> wrote:
Hi, all:

The Sakai instance running in University of Michigan is still based on Sakai 2.9.2 and Kernel 1.3.2, with Oracle 11g database.  Since the extended support fee for Oracle 11g is waived until May 31, 2017, we are now investigating the possibility of using Oracle 12c database.

Does anyone have experience of running Sakai 2.9.2 with Oracle 12c? Are there any known issues? Any patch needed?

Thanks in advance. 

- Zhen

---------------------------------------------------------
Zhen Qian
Interim Application Development Manager
Teaching and Learning
ITS, University of Michigan
<a href="tel:(734)%20239-5118" value="+17342395118" target="_blank">734-239-5118
zqian at umich.edu
----------------------------------------
----------------- 

--
You received this message because you are subscribed to the Google Groups "Sakai Production" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-production/.

--
You received this message because you are subscribed to the Google Groups "Sakai Production" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-production/.
Zhen Qian Zhen Qian
Reply | Threaded
Open this post in threaded view
|

Re: [sakai-production] Sakai 2.9.2 + Oracle 12c

Thanks, Leonardo. I will check with our DBAs about the optimizer settings.

We do not have plan to upgrade Sakai code base to later versions, since the application is in the retirement phase. 

Thanks,

- Zhen

On Fri, Jan 6, 2017 at 3:55 PM, Leonardo Canessa <[hidden email]> wrote:
The only issue I know with Oracle 12c is related to an optimizer setting, see this post for more information. I am not a DBA, but I thought I heard that the bug had been fixed in later versions of 12c.

I highly recommend upgrading to a more recent version of Sakai, as 2.9.x is no longer supported.

Leonardo Canessa
Web Developer - E-Learning
<a href="tel:(937)%20229-2085" value="+19372292085" target="_blank">937-229-2085

On Fri, Jan 6, 2017 at 3:44 PM, zqian <[hidden email]> wrote:
Hi, all:

The Sakai instance running in University of Michigan is still based on Sakai 2.9.2 and Kernel 1.3.2, with Oracle 11g database.  Since the extended support fee for Oracle 11g is waived until May 31, 2017, we are now investigating the possibility of using Oracle 12c database.

Does anyone have experience of running Sakai 2.9.2 with Oracle 12c? Are there any known issues? Any patch needed?

Thanks in advance. 

- Zhen

---------------------------------------------------------
Zhen Qian
Interim Application Development Manager
Teaching and Learning
ITS, University of Michigan
<a href="tel:(734)%20239-5118" value="+17342395118" target="_blank">734-239-5118
zqian at umich.edu
----------------------------------------
----------------- 

--
You received this message because you are subscribed to the Google Groups "Sakai Production" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-production/.




--
---------------------------------------------------------
Zhen Qian
Interim Application Development Manager
Teaching and Learning
ITS, University of Michigan
<a href="tel:(734)%20239-5118" value="+17342395118" target="_blank" style="color:rgb(17,85,204)">734-239-5118
zqian at umich.edu
----------------------------------------
-----------------

--
You received this message because you are subscribed to the Google Groups "Sakai Production" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-production/.