AnsweredAssumed Answered

Prepare an Oracle Database Server for CA Process Automation

Question asked by TMACUL Champion on May 29, 2015
Latest reply on May 29, 2015 by TMACUL

Looking for documentation one of these (3) steps say we need create manually "Create the Library, Reporting, and Runtime databases manually.", but how to create?


Where is this script?




Procedure from CA Process Automation Installation Guide Service Pack 04.2.02


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 (see page 92).

■ 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 (see page 87) for more information about space considerations.

Prerequisites to Installing the Domain Orchestrator

92 Installation Guide

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:


Note: Partitioning is not supported.

More information:

Oracle Bug # 9347941 (see page 265)

Change the Database Configuration to Use an Oracle Service Name (see page 148)

This "Procedure from CA Process Automation Installation Guide Service Pack 04.2.02" procedure information was created by Brian Parker | CA Process Automation Cookbook