Running different products in the same Oracle tablespace ?

Lars von Wedel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 29, 2011

Hello,

is it possible for different products (considering Confluence, JIRA, Greenhopper, Fisheye so far) to share the same Oracle tablespace ?

It would be nice if they could all share the same one (as internal "pricing" in the company is by TS).

Lars

2 answers

2 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 30, 2011

That should work fine as long as you use different schema owned by dedicated users (as long as you have enough space). We have used this in Test, not production!

Ofcourse, you should test it first and verify.

Lars von Wedel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 1, 2011

Okay, thanks for sharing this information. I'll have to think this over as any change on Oracle DBs requires a ticket at corporate and takes three weeks time.

Most likely, I'll go and test with an Oracle XE installation first.

Lars

0 votes
Manse Wolken
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 2, 2011

We have it in production and it works. But our backup is per tablespace. Now imagine, you do a update and something breaks (never happened, but what if?) You have to shut down every service running against that tablespace for every single update!

It works, but we are sepparating the tablespaces per application.

Suggest an answer

Log in or Sign up to answer