ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Defining a Connection Object for Oracle RAC in AE

book

Article ID: 88362

calendar_today

Updated On:

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>

0EMb0000001QQIJ.png
  1. Define a CONN Object

<Please see attached file for image>

0EMb0000001QQIO.png
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)
  1. Define the Variable-Object with type SQL.

<Please see attached file for image>

0EMb0000001QQIY.png

Attachments

1558692868394000088362_sktwi1f5rjvs16lv0.png get_app
1558692866590000088362_sktwi1f5rjvs16luz.png get_app
1558692864615000088362_sktwi1f5rjvs16luy.png get_app