IT Process Automation

 View Only

Information on configuring PAM to utilize an ORACLE RAC

  • 1.  Information on configuring PAM to utilize an ORACLE RAC

    Broadcom Employee
    Posted Nov 07, 2013 10:43 AM
    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