search cancel

RA Oracle JDBC Connection Object for RAC

book

Article ID: 112549

calendar_today

Updated On:

Products

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.

Environment

Release: AOMVMW99000-4.0-Automic-Operations Manager-VMware vCenter Agent
Component:

Resolution

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>)))