Oracle DB release

We are going to make the production installation for Jira Software and we have a question about the supported platforms: Can we use Oracle Database 12c Release 2?

1 answer

0 vote
Daniel Eads Community Champion Aug 06, 2017

Hi Anna,

For a full list of what's supported in which version of JIRA, check out this list here. There's a similar list for Confluence.

Specifically about Oracle 12c release 2, yes you can use that release of Oracle with the latest JIRA and Confluence versions. I would strongly recommend using the release 2 driver for JIRA and Confluence (12.2.0.1) which you can obtain here from Oracle. The ojdbc8.jar file needs to go into the lib folder in your application install directory, and any older ojdbc8.jar/ojdbc7.jar files should be removed from that directory. The release 1 drivers had bugs that affected JIRA.

Thank you Daniel,

Also can you suggest memory and disk space that we have to assign for this first production server for the database server? We are going to implement o Service Desk for the IT of a telecommunication company (about 2000 employees).

Hi Anna,

You'll want to take a look at the JIRA Sizing Guide.  2000 active users would constitute an Enterprise scale instance.

This should be a top of the line server with enterprise grade processing power (e.g. 6 quad cores or more) and the highest possible I/O performance (e.g. Raid 10, Solid State Disks).

This assumes would require the following:

  • >128GB System Memory
  • A heap size that would be need to be determined by one of our experts
  • > 500 GB Total disk space

The heap size of the prior level of 600 active users is > 4GB for the heap so I would start with 8GB as a  max and 4GB as a minimum and go up from there if you see outofmemory errors in the logs or start to notice slow performance. 

Cheers,

Branden

Daniel Eads Community Champion Aug 09, 2017

Note that the info Branden provided is specifically for the application server - although following his advice to contact an expert might help you with the sizing information for the database server. In general, if you have a DBA on staff I would try to lean on them for help in determining Oracle requirements.

In our organization with 400 users, here are the specs for our Oracle server (which hosts our production JIRA and Confluence):

Dell R710
CentOS 7.1
32GB RAM
1TB SAN attached storage (note that our databases are not nearly that large)

I'm also looking for this information. This is our first installation of Jira. We will be using an Oracle 12c Database. There should be some guidelines on the database storage requirements similar to what is provided for the application server requirements. Thx

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

536 views 6 11
Read article

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