Procedure to configure CA Workload Automation DE R11.3 server with Oracle RAC

Document ID : KB000010172
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:
Procedure to configure CA Workload Automation DE R11.3 server with Oracle RAC
Instructions:

Follow the instructions below:
 Procedure to configure CA Workload Automation DE R11.3
 server with Oracle RAC:
 
 Standalone server
 ==================
 
 1. Setup Oracle RAC.
 
    Assumptions:
 
    a) Machine 1:
 
       Hostname: IP1
       SID: RAC1
 
    b) Machine 2:
 
       Hostname: IP2
       SID: RAC2
 
    c) Service name: RAC.WORLD
 
 2. Install CA Workload Automation server with any of the
    RAC instance sid's. i.e. RAC1 / RAC2.
 
 3. Stop CA Workload Automation server.
 
 4. Open the following file located in server installation:
 
    <WorkloadAutomation-Install>/conf/db.properties
 
 5. Comment the jdbc.URL line by appending # before the line
    and add the following in single line.
 
    jdbc.URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
 
 (ADDRESS=(PROTOCOL=TCP)(HOST=IP1)(PORT=P1))(ADDRESS=(PROTOCO
 
 L=TCP)(HOST=IP2)(PORT=P2))(CONNECT_DATA=(SERVICE_NAME=RAC.WO
 RLD)))
 
    where IP1 and IP2 are the hostnames of Oracle instances.
    P1 and P2 are the ports where the Oracle instances are
    listening.RAC.WORLD is the common service name for the
    oracle RAC setup.
 
 6. From <WorkloadAutomation-install>/bin directory run the
    utility 'validatedbconnection' script to check the
    Database connections.
 
    Database connections should be successful.
 
 7. Start the CA Workload Automation server.
 
 High Availability configuration
 ===================================
 
 1. Setup Oracle RAC.
 
    Assumptions:
 
    a) Machine 1:
 
       Hostname: IP1
       SID: RAC1
 
    b) Machine 2:
 
       Hostname: IP2
       SID: RAC2
 
    c) Service name: RAC.WORLD
 
 2. Install CA Workload Automation primary and standby
    servers with any of the RAC instance sid's. i.e. RAC1 /
    RAC2.
 
 3. Stop CA Workload Automation primary and standby server.
 
 4. Open the following file located in both primary and
    standby server installations:
 
    <WorkloadAutomation-Install>/conf/db.properties
 
 5. Comment the jdbc.URL line by appending # before the line
    and add the following in single line.
 
    jdbc.URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
 
 (ADDRESS=(PROTOCOL=TCP)(HOST=IP1)(PORT=P1))(ADDRESS=(PROTOCO
 
 L=TCP)(HOST=IP2)(PORT=P2))(CONNECT_DATA=(SERVICE_NAME=RAC.WO
 RLD)))
 
    where IP1 and IP2 are the hostnames of Oracle instances.
    P1 and P2 are the ports where the Oracle instances are
    listening.RAC.WORLD is the common service name for the
    oracle RAC setup.
 
 6. From <WorkloadAutomation-install>/bin directory run the
    utility 'validatedbconnection' script to check the
    Database connections.
 
    Database connections should be successful.
 
 7. Start the CA Workload Automation primary and standby
    server.
 
 Notes:
 
 1. Seamless processing during a RAC failover,which Oracle
    terms Transparent Application Failover (TAF) is
    not supported.
 
 2. There might be slight slowdown in workload processing
    during RAC failover due to primary server shutdown , when
    retries are over and change roles to peer server. User
    are expected to warm start the primary,in case they
    see any shutdowns during these times.