Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

Configure Oracle DB Adapter in Oracle RAC configuration

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?

 

2 REPLIES

Have a look atDeploying

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

Community Member

Thank you.  The solution for

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)))

 

69
Views
0
Helpful
2
Replies
CreatePlease to create content