How to plan for Bamboo upgrades from a very old version to a newer version when the current DB is not supported on a newer version
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The purpose of this page is to explain the process involved in upgrading from a very old Bamboo version to a recent version where the current DB is not supported on the newer version of Bamboo.
The detailed steps regarding upgrade can be found at Bamboo upgrade guide
Environment
This KB covers the following environment combinations
Current Bamboo version : 6.10.6 , DB : Oracle RC1
Upgrading to : 9.3.1 , DB : Oracle 19C
Solution
As per Bamboo 6.10 supported platforms page we can see that Bamboo 6.10 does not support Oracle 19c, hence we cannot do DB migration on the current version and then upgrade Bamboo to a latest version.
Also as per Bamboo 9.3 supported platforms page we can see that Bamboo 9.3.1 does not support Oracle RC 1, hence we cannot Upgrade Bamboo and then migrate the DB.
The idea here is to move the older Bamboo version to a database which is supported on the newer version as well.
We have to follow the below steps in this scenario ( the steps include setting up a test environment as well for testing purposes )
- Prepare a test Environment which is on Bamboo 6.10.6 and Oracle 12C RC1 ( both the file system and DB should contain the Prod data ), make sure you edit bamboo.cfg.xml file and change the DB configuration details so that it points to test env DB. Refer Cloning a Bamboo instance for more details.
- Once the test Env is up and running with Prod data as per the above step, next step is to create a new Oracle 12C RC2 database which contains Oracle 12 C RC1 data, this should be done by the DBA.
- Once you have the Oracle 12C RC2 DB ready, shutdown Bamboo and edit <bamboo.cfg.xml> file and put the DB related details for Oracle 12C RC2 and start Bamboo. Refer Move data to a different database for more details.
- At this stage you should have Test environment up and running with Bamboo 6.10.6 and Oracle 12C RC2 DB
- Now you'll download Bamboo 9.3.1 and directly upgrade Bamboo with the same DB as Oracle 12C RC2 as per Bamboo upgrade guide
- At this stage you'll have Bamboo 9.3.0 up and running with Oracle 12 RC2.
- Create Oracle 19C DB with the data of Oracle 12C RC2, this should be done by DBA.
- Open bamboo.cfg.xml file on your Bamboo 9.3.0 and change the DB properties to point it to Oracle 19C and Restart Bamboo, you can refer Move data to a different database for more details.
- Post this you'll have Bamboo 9.3.0 running with Oracle 19C DB.