RA Oracle JDBC Connection Object for RAC
Article ID: 112549
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.
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:
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>)))
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>)))
Feedback
Yes
No
Powered by
