SQL data source for an Oracle RAC

For high availability, the SQL data source can be configured with an Oracle RAC (Real Application Clusters) as the data source.

Instead of establishing a direct connection to a database instance with the Oracle system identifier (SID), connect to the RAC with the ServiceName that represents the cluster of database instances.

Define the SQL data source to define the base configuration. Ensure that you define the following configuration.
  • Select Oracle as the database type.
  • Select ServiceName as the Oracle identifier type.
  • Specify the ServiceName for the data source ID.
Then, depending on the RAC configuration, you might need to define the other nodes in the RAC. To define a node in RAC, define a name-value pair as a configuration parameter. For the name, specify AlternateServers. For the value, supply a comma-delimited list of hosts where each host is a colon-delimited list of the following fields.
  • HostName
  • PortNumber
  • SID or ServiceName, which does not require the Enable object support - Oracle property to be selected
For example, define the hostname, port number, and SID for each node in the RAC with the following syntax.
With the SQL ODBC feature
Hostname=RAC_Node1:PortNumber=port:SID=RAC_Node1_SID,
Hostname=RAC_Node2:PortNumber=port:SID=RAC_Node2_SID
With the Database Connectivity feature, which does not require the SID
RAC_Node1:port1,
RAC_Node2:port2