Using DataDirect Connect for .NET with Oracle Real Application Clusters (RAC)

View PDF

Oracle RAC, as implemented in Oracle 9i and Oracle 10g, allows a single physical Oracle database to be accessed by concurrent instances of Oracle running across different CPUs. This material explains how the DataDirect Connect for .NET Oracle data provider can connect to an Oracle RAC system with a connection string as if it was a single instance of an Oracle database. Alternatively, the data provider can retrieve specific connection information from a tnsnames.ora file.

This material also describes the two failover methods that Oracle RAC uses to provide reliable access to data replicated on multiple servers; connection failover and transparent application failover (TAF).

In addition, the material explains how to take advantage of these failover methods when you use the DataDirect Connect for .NET Oracle data provider to connect your data critical applications to data.

Oracle RAC systems provide two types of load balancing for automatic workload management; server load balancing (which distributes processing) and client load balancing (which distributes connection attempts). The DataDirect Connect for .NET Oracle data provider supports both types of load balancing.

Client load balancing can be enabled through a connection string option or in the tnsnames.ora file.

Oracle RAC Topics (Click to view complete topic information.)

• Grid Computing Infrastructure for Distributed Computing (Introduction)
• Connecting to an Oracle Real Application Clusters (RAC) System
• Failover
• Load Balancing
• DataDirect Connect for .NET Oracle Data Providers Offer Flexibility, Scalability and Efficient Data Access

Ready to try DataDirect Connect for ADO.NET?
	|	Learn More