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,
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>;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is a concern.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.