Can we have Jira schema and confluence schema in one oracle database

Kiran Kadali June 24, 2024

Hello, Can we have Jira schema and confluence schema in one oracle database. We have one oracle box, and can we have a service/sid called Atlassian and create two users Jira and confluence. Jira will have its own schema and confluence will have its own schema. Are there any disadvantageous?

Thank you,

2 answers

1 vote
Shawn Doyle - ReleaseTEAM
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 24, 2024

Yes, yes you can. 

You create an Oracle user for each and they will have their own set of tables.

grant connect to <user>;
grant create table to <user>;
grant create sequence to <user>;
grant create trigger to <user>;
Kiran Kadali June 25, 2024

Thank you

0 votes
Kiran Kadali June 25, 2024

@Shawn Doyle - ReleaseTEAM 

I was thinking above risk, when you are upgrading Jira or confluence, we have to do both simultaneously if the database is being shared. Say if current version of Jira and Confluence is running on oracle 19. Next version of Jira requires oracle 21. we cannot just upgrade Jira as there is Confluence dependency. 

Shawn Doyle - ReleaseTEAM
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 25, 2024

That is a concern.  

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events