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

[Kiran Kadali]

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,

[Shawn Doyle - ReleaseTEAM]

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]

Thank you

[Kiran Kadali]

@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]

That is a concern.