CA Automic Workload Automation - Automation Engine
Issue/Introduction
The documentation does not specify the format of the JDBC connection string.
How to set the connection string for an Oracle Retail DB or Oracle EBS with RAC configuration. This concerns the target DB of the RA Agent, so not the AE DB.
In the JDBC connection object set the following settings:
Database type=Oracle RAC Database Driver Class Name=oracle.jdbc.driver.OracleDriver Userid=<login> Password=<password>
Oracle RAC Connection String: <copy the content of your tnsnames.ora of the Oracle RAC instance>
This means that you should use the following format, without the prefix jdbc:oracle:thin: (DESCRIPTION=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=<Oracle RAC hostname>)(PORT=<DB Port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<RAC service name>)))