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>;