Question & Answer
Question
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?
Answer
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:
- On the main tab of the SQL Data Source configuration page, select Oracle as the Database Type.
- Select ServiceName as the Oracle Identifier Type. Do not select the default value SID.
- 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.
[{"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateway"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF009","label":"Firmware"}],"Version":"4.0.2;5.0.0;6.0.0;6.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSQ3J2","label":"WebSphere DataPower B2B Appliance XB60"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF009","label":"Firmware"}],"Version":"3.8.2;3.8.1;3.8;3.7.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
08 June 2021
UID
swg21498928