RA Oracle JDBC Connection Object for RAC

Document ID : KB000112549
Last Modified Date : 30/08/2018
Show Technical Document Details
Introduction:
The documentation does not specify the format of the JDBC connection string.
Question:
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.
Answer:
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>)))