Install the Domain Orchestrator › Prerequisites to Installing the Domain Orchestrator › Database Prerequisites › Prepare an Oracle Database for CA Process Automation

Prepare an Oracle Database for CA Process Automation

Before you install the Domain Orchestrator or an additional Orchestrator, which uses one or more Oracle databases to host its data stores, preparation is required.

Follow these steps:

1. Open an Oracle database management application and log into the target Oracle database instance.
2. Create a schema for each of the following data stores, where each schema has the permissions listed in Database Owner Privileges.
   • Library data store
   • Runtime data store
   • Reporting data store
3. Verify that Oracle has sufficient tablespace to host the data stores.

   Note: See About CA Process Automation Data Stores for more information about space considerations.

4. Set maximum connections to 100 (or at least 150 for clustered).

   All connections are made through Orchestrators, but a few pooled connections are required for optimal behavior.

5. Follow Online Transaction Processing (OLTP) best practices to facilitate CA Process Automation transactions.
6. Understand how the Oracle JDBC driver is referenced.

   During installation of the Orchestrator, the installer requires the Oracle JDBC driver for Oracle, which is included in DVD1. The path is:

   .../DVD1/drivers/ojdbc14.jar
   

Note: Partitioning is not supported.

More information:

Oracle Bug # 9347941

Change the Database Configuration to Use an Oracle Service Name