Information on configuring PAM to utilize an ORACLE RAC

book

Article ID: 20007

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Process Automation Base

Issue/Introduction

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 filesmodified 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.

Environment

Release: ITPASA99000-4.1-Process Automation-Add On License for-CA Server Automation
Component: