IBM Support What's New?

How can I configure my DataPower SQL Data Source to work with Oracle Real Application Clusters (RACs)?

Technote (FAQ)


I have a DataPower box with the ODBC license feature. I would like to be able to communicate with my Oracle RAC using DataPower's SQL Data Source object. How do I configure this?


RAC uses clustered nodes with shared storage. While a normal DataPower - Oracle database connection links to an Oracle SID (a database instance name), a RAC connection links to a ServiceName (an alias for one or more database instances). The ServiceName represents a cluster of database instances.

In the DataPower WebGUI:

  1. On the main tab of the SQL Data Source configuration page, select Oracle as the Database Type.
  2. Select ServiceName as the Oracle Identifier Type. Do not select the default value SID.
  3. Depending on the RAC configuration, DataPower may need the extra information of a list of alternate servers. In that case, move to the Data Source Configuration Parameters tab and enter the following Name / Value pair:
    • Name = AlternateServers
    • Value = (Hostname=RAC_Node1:PortNumber=<port>:SID=<RAC_Node1_SID>,Hostname=RAC_Node2:PortNumber=<port>:SID=<RAC_Node2_SID>)
    You would supply your Hostname, PortNumber and SID for each node.

Cross reference information
Segment Product Component Platform Version Edition
Business Integration WebSphere DataPower B2B Appliance XB60 Firmware 3.8.2, 3.8.1, 3.8, 3.7.3

Document information

More support for: IBM DataPower Gateways

Software version: 4.0.2, 5.0.0, 6.0.0, 6.0.1

Operating system(s): Firmware

Reference #: 1498928

Modified date: 2011-05-11