Design Manager / RTC 4.0.1 deployment - same servers?
Hey all,
I've got a question regarding the deployment of Design Manager with our CLM 4.0.1 installation.
I'd prefer not to set up an additional server to host DM.
I understand that DM can share a JTS server with CLM. Can I also share the same Oracle instance? The rqts for DM state that ojdbc5.jar is required, but the CLM apps require ojdbc6.jar.
Is there any performance hit that would occur with this option, if I could use the same db?
Thanks a million,
Chris
Accepted answer
As you might know that odbc5.jar and odbc6.jar are both driver files which the application server uses to connect to the databases. As far as I know odbc5.jar is for JRE 1.5 and odbc6 is for JRE 1.6. Since you are using CLM 4.0.1, conceptually you should only need odbc6.jar for both DM and other apps like JTS/RTC.
Also, you should be able to see the JRE version used by the application from the <application>/admin > Status Summary page.
The performance question cannot be answered so easily. It all depends on your infrastructure and usage.
Comments
That's indeed true about the ojdbc drivers. Thanks much.
Regarding though the sharing of a database, is it supported? I don't see in the CLM install docs, or the DM install docs any specific details when sharing an oracle DB. Sharing tablespaces, users, etc...?
In an oracle instance, for each application you should create separate databases and for each database one or more tablespaces. See Setting up an Oracle database for more details. The link also guides you about the necessary user creations as well. If the answer is satisfactory, please accept the answer so the knowledge can be used by others.
What about the data warehouse? CLM already has a data warehouse tablespace. Do I have to create another one? If I can reuse, is there instruction on how to do this?
Thx,
Chris
I'll gladly mark this response as accepted, if I can get some clarification on the data warehouse question above.
Thx,
Chris