Talend Administration Center (TAC) and setting up the DB to use Oracle Real Application Clusters (RAC)

Talend Version       6.3.1

Summary

Talend Administration Center (TAC) and setting up the DB to use Oracle RAC
Additional Versions Probably applies to 6.4.1 and maybe 6.2.1
Product Talend Administration Center
Component Database
Problem Description Attempting to set up an Oracle RAC database for TAC is not working. TAC doesn't recognize it.
Problem root cause TAC supports setting up Oracle RAC for its database use, but you can't do it during the installation process for Talend. You must first select the H2 database (or anything else) and complete that installation process first. Or you can point it to one of the RAC nodes first.
Solution or Workaround
  1. Complete your standard Talend installation with TAC and then go to the TAC login page and click DB configuration.
  2. Make sure you have the correct JDBC driver for your Oracle RAC installed for TAC/Tomcat (in the /endorsed/ or /lib/ folder).
  3. On the DB config page, select an Oracle Database.
  4. Use one the following connection strings.

    This string should work most of the time:

    jdbc:oracle:thin:@{hostname}:{port}:{service_nice}

    If necessary, use this more complex string:

    jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=NODE1-VIP)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=NODE2-VIP)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MYRAC)))
Version history
Revision #:
6 of 6
Last update:
‎09-29-2018 12:19 AM
Updated by: