JIRA 7.x / 8.x - Compatiblity Oracle XE

[Vincent Thoulé _Alkaes_]

Hi All,

I have to upgrade for JIRA 7.13.x or 8.0.x, one of my plugins developed for JIRA 6.2.x.

This plugin uses BLOB with AO and was developed with Oracle 11g XE and tested/used only against Oracle 10g.

Support Platform pages for 7.13.x and 8.0.x are announcing a support only for Oracle 12c.

Oracle XE does not exist in 12c. There was a jump from 11g to 18c.

Does the announcement of Oracle 12c support concern only Performance Issues or also some identified bugs ? Oracle Database XE seems to be limited to 1Gb of memory, and in my undertanding (https://jira.atlassian.com/browse/JRASERVER-65387), it is why it is not announced as supported.

May I have a confirmation which Oracle XE I can use for development : 11g or 18c ?

Thanks

Vincent

[Earl McCutcheon · Accepted solution]

Hi Vincent,

Looking into this a bit I found this post on the Oracle forum with a note from the Oracle XE product Manager:

There is no Oracle 12c Express Edition (and there will be no 12c XE).

And it looks like 12c xe was replaced by 18c per This Blog post

As this pertains to Jira 7.13 & 8.0, Oracle 12c R1 is the only supported DB version, so there is not an XE version that would be recommended.  You could attempt to use 18c and force it to work, and some functionality would more than likely run fine but since the application was not designed to be compatible with this version then there is a high likelihood of hitting a square peg, round hole scenario and failing catastrophically once the misaligned features clash with the DB.

If you want to use Oracle you would want to use the 12c R1 full release and not the XE version, or pick another supported DB version

Regards,
Earl

[Vincent Thoulé _Alkaes_]

Thanks Earl,

The Oracle 12c will be targeted version for my customer, but I will be not able to reproduce a such environment on development side.

After having read the Blog post, I will try to use XE 18c.

Thanks

Vincent