Configure Oracle DB Adapter in Oracle RAC configuration

[John Phillips]

Oracle RAC uses Service name rather than SID and Oracle adpater only accepts a URL string in sid format.  How can a connection be defined for a RAC environment?

[Walter Dey]

Have a look at

Deploying Oracle Real Application Clusters on the Cisco Unified Computing System with EMC CLARiiON Storage White Paper

http://www.cisco.com/c/en/us/products/collateral/servers-unified-computing/ucs-b-series-blade-servers/white_paper_c11-562881.html

[John Phillips]

Thank you.  The solution for configuring a Tidal adapter that uses Oracle RAC is to expand the URL connection string where the Service name can be defined.

Standard defined connection string:

jdbc:oracle:thin:@hostname:1521:sid

Connection string for Oracle RAC:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=servicename)))