OnDemand User Group

Support Forums => MP Server => Topic started by: jsquizz on February 10, 2021, 10:45:49 AM

Title: Multiple oracle instances configured on the same box
Post by: jsquizz on February 10, 2021, 10:45:49 AM

We'd like to create a POC where we load to an oracle remote server to measure performance.

Wondering if it's possible to point an existing CMOD/oracle system that is working PERFECTLY to this remote instance. Basically, two CMOD instances, one box.

Assuming we'd just have to modify the ars.ini file to point to a seperate set of ars.** files, create the database with arsdb commands, and fire it up?

Title: Re: Multiple oracle instances configured on the same box
Post by: Justin Derrick on February 10, 2021, 11:41:08 AM

I generally don't recommend remote database instances with CMOD, as it adds complexity and latency.  Any network-related glitch can disconnect CMOD from the database, leading to availability issues for end users, and issues recovering transactions (loads, activity logs, etc.)

-JD.