It's all about the answers!

Ask a question

Multiple CLM instances sharing a single Oracle DB with DW configured?

Roger Boester (656) | asked Jan 30 '14, 5:27 p.m.
Can a single Oracle DB be used for multiple CLM instances (RTC & RQM & JTS)?  They are each using unique connection user names like JTS1 and JTS2 - same for the other apps and the DW users.  We are setting up multiple 4.0.5 test instances and need to minimize DB creations and share as much as possible.  Each app is on it's own VM server and that works OK, but when trying to setup the DWs we run into what I suspect are contention issues for the same resources in the DB.

2 answers

permanent link
Michael Afshar (7014) | answered Jan 30 '14, 5:57 p.m.
 Hi Roger,

Yes, you can have one database and multiple tablespaces and users. Here is the setting up Oracle topic in the IC.



permanent link
Adam Wereszczynski (92811932) | answered Jan 31 '14, 2:07 a.m.
edited Jan 31 '14, 3:03 a.m.
Hi Roger,

Like Michael said, you can have multiple CLM servers using one Oracle DB, but if you want to have more than one Data Warehouse you must use CLM 4.0 or above. You have to specify a different "Schema prefix" for each DW.

For more details, please read:
About one Oracle database instance hosting multiple Data Warehouse databases in Jazz

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.