Defining a Connection Object for Oracle RAC in AE

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

In order to define an Oracle RAC connection in the Automation Engine, according to the online documentation, you must choose ORACLE OCI for the field "Database type".  Following is additional information and screenshots for setting this up on your system.

​

 

 

Environment

Release: AUTWAB99000-10.0-Automic Workload Automation-Base Edition
Component:

Resolution

1. Check the tnsnames.ora file and you will see an entry similar to this:

WO112 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = VWGSUP12.sbb01.spoc.global)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = WO112)
    )
  )
Note: After any modifications to the tnsnames.ora file, you must restart your DB_SERVICE agent for the changes to take effect.

<Please see attached file for image>

2. Define a CONN Object

<Please see attached file for image>

Note:  The field "Server" is not mandatory and can be empty.

For more information on the DB tab refer to the online documentation:
https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/10/All%20Guides//help.htm#ucactb.htm%3FTocPath%3DUser%2520Guide|Objects|Alphabetical%2520Listing|Connection|_____6)

3. Define the Variable-Object with type SQL.

<Please see attached file for image>