Support with Oracle RAC Infrastructure?

Andre Lehmann
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2014

Hi there,

our DBAs want to change the whole ORACLE-Infrastructure in our company and they asked us if Jira and Confluence are able to connect to an Oracle-RAC Infrastructure.

They said: RAC means that the database is active with read/write access on two database-servers.

I tried to find something "official" in the documentation but without success.

So the question @atlassianand @community:-)
Is Oracle-RAC infrastructure supported or even possible?

Kind regards
André

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 19, 2014

Jira and Confluence both require a single database connection. They don't actually care what is on the other end of the connection, so you can run whatever you like. As long as there's a Java driver for the datasource so you can connect to it, and it's a single connection, Jira and Confluence will be happy

But. It doesn't matter if you've got a stack of databases on the server in read/write, you must, under no circumstances, let anything write to them other than the application.

In short, I suspect Oracle RAC is supported because it's Oracle. With the caveat that it's a single connection and nothing else writes to any of the databases.

Andre Lehmann
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2014

Hi Nic,

thanks for your answer. Do you know any "official" documentation for Jira from atlassian?

We found:

https://answers.atlassian.com/questions/39155/how-to-configure-jira-with-oracle-rac-db

https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle

So there is a documentation for Confluence. But not for Jira.
https://confluence.atlassian.com/x/tQESCwdoesn't say a word about RAC.

Kind regards
André


Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 19, 2014

Yes, sort of. It's not documentation, but request logs.

The answer is that "although it's working fine as far as we can tell, it is not officially supported".

See https://jira.atlassian.com/browse/CONF-20277?jql=text%20~%20%22RAC%20Oracle%22 for several hints...

Suggest an answer

Log in or Sign up to answer