Defining a Connection Object for Oracle RAC in AE
Document ID :
Last Modified Date :
Show Technical Document Details
CA Automic Workload Automation
CA Automic Workload Automation:Release:10.0
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.
Check the tnsnames.ora file and you will see an entry similar to this:
(ADDRESS = (PROTOCOL = TCP)(HOST = VWGSUP12.sbb01.spoc.global)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = WO112)
After any modifications to the tnsnames.ora file, you must restart your DB_SERVICE agent for the changes to take effect.
Define a CONN Object
The field "Server" is not mandatory and can be empty.
For more information on the DB tab refer to the online documentation:
Define the Variable-Object with type SQL.
Was this information helpful?