10-15-2014 12:00 PM - edited 03-01-2019 11:52 AM
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?
10-16-2014 01:32 AM
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
10-16-2014 09:02 AM
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)))
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide