nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Database configuration for JIRA installation

Deepthi Krishnaprasad

Hi Team,

This is regarding the JIRA tool installation in a physical server, 10 licenses of JIRA was purchased as per SEN-11284492 . We are proceeding with tool installations in a physical server . Have some queries on DB configuration, please help.

1. We are planning to use Oracle 11 as the DB, wanted to know if Oracle can be installed in the same server where JIRA is installed or need to be in a different server ?

2. JIRA 7.8.0 version is being installed, is it compatible with Oracle 11 ?

3. What should be the volume of DB allocated to work with JIRA considering a longer period of usage ?

4. What are the procedures for integrating JIRA with Test Rail tool ?

Request you to help me with the clarifications.

Thanks

Deepthi.

Accepted answers

All comments

Charlie Misonne

Hi Deepthi

First of all: do notice this is the Atlassian Community channel and not the official Atlassian support portal.

You can install your database on the same server where Jira is installed. However make sure you allocate enough resources to it. For security and scalability I would recommend using a seperate server.
As you have a small amount of users you might be good to go with 1 server only. This depends of your future plans with Jira.
Jira 7.8 is not compatible with Oracle 11. See supported platforms
I'm not sure what you mean with this question.
For Testrail integration see this page. From past experience I remember you need to generate a key in Testrail and put it in the Jira testrail add-on. Your users also need to add their Jira user name to their Testrail profile. Everything should be in that documentation link

Deepthi Krishnaprasad

Hi Team,

Thank you for the prompt reply.

For question 3, I was asking about the scalability part. As you answered in point 1, we need to go for a separate Server for longer plans with JIRA.

1. AS Oracle 11 is not compatible with JIRA, please suggest which installation version we need to install that supports Oracle 11 ?

2. The JIRA needs to be installed in a Bank server location in India, Kochi, Kerala(State). Please let me know if you have any physical person that can come and support the installation procedures. If not, is there an on-call support provided that can be contacted and help us with the installation ?

Charlie Misonne

The last Jira version supporting Oracle 11 was Jira 6.4. See this announcement.
I do not recommend installing Jira 6.4. This versions is "end of life" since a long time meaning you will not get any support from Atlassian and you will miss a lot of new features and bug fixes.
Instead consider using Oracle 12 or another database type like Postgres.
You can ask an Atlassian partner to assist you with the installation. India is too far for me!
Look here for partners in India: https://www.atlassian.com/partners/search?page=1&locations=India

Deepthi Krishnaprasad

Hi Charlie,

Thanks for your update, I have couple more questions

1. Is Jira 7.8 compatible with MySQL, if so with which version of MYSQL ?

2. We wanted to open up JIRA to external vendors as they are also involved in defect fixing. So from the current installation on a physical server, what is the procedure for accessing the JIRA url from an external environment ?

3. On a scalability perspective, will there be any issues with MYSQL on using it for a longer term ?