JIRA Upgrade from 3.13.5 to 5.2.10 with Oracle : do we have to manually update database?

Hi,

I am in charge of upgrading a JIRA instance from 3.13.5 to 5.2.10.

I intend to do a manual upgrade with Oracle 11 database.

The target process is to upgrade straight from 3.13.5 to 4.4.5 and finally to 5..2.10.

Do we need to apply some manual Oracle scripts like described here ? :

https://confluence.atlassian.com/display/JIRA/JIRA+4.0+Database+Schema+Changes+for+MySQL+and+Oracle

Or eventually, are these scripts already included in JIRA Upgrade Tasks when the application starts the first time?

Thanks for you help.

Regards

1 answer

1 accepted

2 votes

Depends on how you are doing 3.13 to 4.4.

If you're exporting the XML and then importing it, then no, 4.4 will create the correct database layout and import the data.

If you are pointing the new 4.4 at the existing 3.13 database and expecting it to do all the work, then yes, you need to follow those instructions - shut down 3.13, take a backup of the database, run the scripts and alterations, start Jira 4.4

Two pretty obvious points here, but I've seen people skip them and create nightmares. 1) Test it properly on non-production systems before you start and 2) Backups. Database backups are your friend. Be nice to them...

Ok, I got it. No shortcuts for database upgrade.

Of course everything will be tested until it is safe do final upgrade in production.

Thanks!

Cheers

It is only because there are column format changes between 3.x and 4.x and the code in Jira doesn't cope with those changes. Fortunately they are actually reasonably simple (heck, I can follow the script, and my DBA knowledge is little more than "select from where"). A clean install followed by import of xml bypasses the problem because it creates the columns in the right format, but that's not always the right answer for every situation.

Fortunately, you'll find 4.x to 5.x has nothing anywhere near as scary in it :-)

Thanks Nic for your feedback.

I read JIRA Upgrade Guides from 4.0 to 4.4.5.

It seems that there is only one Oracle script to apply when upgrading from 3.13.5 to 4.0

This not a big deal indeed.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,110 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot