Lately I had a question in this Blog about an ORA-25408. My first thought was, that TAF and HA events should not be mixed. In order to confirm this, I wrote a small application with 3 connection possibilites 1. Normal connection 2. TAF connection with or without HA events 3. Connection with HA events...

After the successfull RLB tests with RAC FAN events we re-tested the FCF with both Java and ODP.NET Startup As soon as the DBA puts an additional instance into a RAC service the client receives a FAN / FCF event. Both Java and .NET use the additional ...read more

My last RAC tests with runtime load balancing and .NET were not successful. ODP.NET always distributed the workload in a round robin manner. Now I know why: It is a AQ bug. I had more than one IP address defined (my real one and one for my vmWare). Since ...read more

With Oracle 10g R2 FAN and FCF we can load balance connections and requests over a "service". The service is defined to be run on one or more instances on the RAC. Services take a CLB_GOAL LONG or SHORT and are created with DBMS_SERVICE.CREATE_SERVICE ...read more

Lately we have done some tests with Oracle 10g R2 load balancing and connection failover for RAC. Both features are mainly useful for application servers. The bottom line: the JDBC driver from Oracle works, the ODP.NET provider not yet. Load balancing ...read more