Oracle setup with CLM. Create separate oracle databases for CLM applications
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
Comments
Norman Dignard
May 15 '19, 7:05 a.m.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.