Direct Oracle Access 4.0.5 & Oracle 10.0.2.4 (RAC)

[Tony Fountain]

Hello, excuse me for what may seem to be several questions from way left field.

Our developers are using DOA 4.0.5 and have been for 10+ years. First, is there a newer version available? Second, are there any known issues with DOA 4.0.5 on a RAC environment?

We seem to have issues with our Delphi 7 modules generating a high level of concurrency. After looking into this further it appears that no sessions created by any Delphi module are utilizing the server side transparent application failover settings. Yet after reviewing our code, the applications do not appear to be directly setting any properties related to transparent application failover (failover type, failover method).

 

[Marco Kalter]

Our developers are using DOA 4.0.5 and have been for 10+ years. First, is there a newer version available?

There is a 4.0.7 and 4.1.1 version.

Second, are there any known issues with DOA 4.0.5 on a RAC environment?

No.

fter looking into this further it appears that no sessions created by any Delphi module are utilizing the server side transparent application failover settings. Yet after reviewing our code, the applications do not appear to be directly setting any properties related to transparent application failover (failover type, failover method).

Perhaps you need to setup the Oracle Client for the appropriate failover properties?