i have the following situation:
I have 1 oracle database with 2 separate users and 2 separat schemes. Now I want to create 2 JIRA instances (version 5.0.3) where each of them has one user and one scheme on the oracle db
Can I do it on this way? Or is it really not possible to work with 2 JIRA instances on one oracle DB?
With best regards
Yes. I always get confused by Oracle's use of the word "schema", hence my reversion to emphasising "separate data sets".
That setup you've got there will have NO problems in my experience - it is exactly how I've run Jira with Oracle databases in the past (although I admit I had a real DBA set it up for me and only discovered what she'd done later - I didn't need to know, because it worked fine)
I'm not sure I've understood the question, but I think you can do something like that. The important thing is that Jira-1 is using different data to Jira-2 and the two of them have no knowledge of each other's tables. So you could use two users and one schema, or two schemas with one user. However, I'd recommend 2 your current setup as they're clearly independent data sets that way.
Saying "one user and one scheme" to me implies that you'll have one Jira database though, with two Jira installations pointed at it - that categorically will not work, they must have separate data sets.
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot