Oracle setup with CLM. Create separate oracle databases for CLM applications
vikrant kamble (132●26●96)
| asked Mar 27 '19, 6:18 a.m.
edited Mar 28 '19, 2:11 a.m. by Muralidhar Rajagopal (101●1●4) I am setting up CLM server with Oracle DB. To do so I am following interactive installation guide. In the database section it is mentioned that this example is for single Oracle database and create tablespaces for individual CLM applications. I want to create separate database for individual application, to do so should I create multiple databases and associate a dedicated user with individual database so that while performing JTS setup each application will connect to its database or I will have to create separate database and single tablespace in each respective database so that application will connect to tablespace in their respective database, below scenario explains both cases
Case 1: Dedicated database is created for applications
CLM App Oracle-Database
JTS JTSDB
CCM CCMDB
RM RMDB
QM QMDB
Case 2 : Tablespace is created in each database for applications
CLM App Oracle Tablespace - Oracle DB
JTS JTSTablespace - JTSDB (JTSTablespace created in JTSDB)
CCM CCMTablespace - CCMDB (CCMTablespace created in CCMDB)
RM RMTablespace - RMDB (RMTablespace created in RMDB)
QM QMTablespace - QMDB (QMTablespace created in QMDB)
Please let me know which of the above is correct way setting up clm with oracle db if I want to create dedicated database for CLM applications
|
One answer
Hello
Either way is supported. It all depends on your DBA's preference and how they want it set up.
|
Comments
Don't forget the data warehouse if you plan on setting that up. One thing we noted for the DW even though the db setup is basically the same , when you create it is does not use that tablespace but rather creates 5 other tablespaces that it uses.