Multiple Content Manager instances and an Oracle RAC setup

If you use Oracle with RAC (Real Application Clusters), you can achieve (application-level) load balancing across your database instances.

To make this possible, run multiple Content Manager instances and connect each of them with its own DTP (Distributed Transaction Processing) service, which must be active on exactly one RAC instance, which acts as its primary node. This results in load balancing, not (directly) on the database level, but on the application level.

This approach ensures that all of the branches of a single global distributed transaction use the same DTP service, while still supporting failover to other instances and application-level load balancing.

Ensure that the singleton service for the database is marked for Distributed Transaction Processing by setting the DTP parameter to TRUE; the default is FALSE.