MWNiebuhr

Information on configuring PAM to utilize an ORACLE RAC

Discussion created by MWNiebuhr Employee on Nov 7, 2013
Document ID:    TEC599675
Tech Document
Title:  Information on configuring PAM to utilize an ORACLE RAC

Description:

This document details how to configure PAM to run against an clustered Oracle RAC as the backend database.

The PAM installer will not recognize an Oracle RAC during installation. PAM will have to be installed against a single Oracle then the configuration files modified to point to the RAC.

Solution:

The first step is to complete the Oracle table space creation as outlined by the Installation Guide, then complete the CA Process Automation install pointing directly to one of the Oracle servers in the RAC.

Start PAM up and verify that it is functional.

Once functionality has been verified against an individual Oracle Server, Stop CA Process Automation Service, and modified

Then modify <install_dir>\server\c2o\.config\OasisConfig.properties as follows:

*.connectionurl=jdbc:oracle:thin:@//<oracle-server>:{port}/
*.dbname=<Service Name>
*.dbhostname=<Oracle RAC>

Please note there are similar entries for the runtime, library, and reporting databases that will have to be updated as follows:

For example for the runtime database:

oasis.runtime.database.connectionurl=jdbc:oracle:thin:@//<oracle-server>:1521/
oasis.runtime.database.dbname=<Service Name>
oasis.runtime.database.dbhostname=<Oracle RAC>

Once all 3 Process Automation databases have been updated Save the modified OasisConfig file and Start the Process Automation Orchestrator service.

 

Click here to access the tech doc directly: TEC599675 Information on configuring PAM to utilize an ORACLE RAC

Outcomes