OPP.NET and Oracle 9i RAC support — oracle-tech

    Forum Stats

  • 3,715,830 Users
  • 2,242,890 Discussions
  • 7,845,632 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

OPP.NET and Oracle 9i RAC support

298770
298770 Member Posts: 3
Hello,

Is ODP.NET support full functionalities of Real Application Clustering of Oracle 9i ?

Thanks

Herve

Comments

  • 3004
    3004 Member Posts: 204,171
    Herve,

    9i RAC is fully functional when using ODP.NET for your data access. ODP.NET does not impose any limitations in using RAC.
  • 298770
    298770 Member Posts: 3
    Thanks Alexander,

    Do you know if there is the support of TAF too, like it is provided in oracle.jdbc.OracleOCIFailover java class. I haven't seen this function within the documentation of ODP.NET. Is there any way to access OCI API with ODP.NET or do we have to use unmanaged .NET code to call OCI API ?

    Herve.
    Herve,
    9i RAC is fully functional when using ODP.NET for your data access. ODP.NET does not impose any limitations in using RAC.
  • 3004
    3004 Member Posts: 204,171
    TAF is handled transparently. If you want TAF notifications, check out page 4-24 in the documentation. You shouldn't need OCI to use TAF notifications.

    Alex
  • 298770
    298770 Member Posts: 3
    Thank Alex,

    I am really sorry but I didn't find the chapter 4.24 you are talking about. Could you tell me which *.pdf file you are thinking of.

    About my concern about TAF notification, I have seen that sample at http://technet.oracle.com/sample_code/tech/java/sqlj_jdbc/files/9i_jdbc/OCIdriverTAFSample.java.html

    If I understand you well, you mean that we don't have to be notified by the TAF in order to reconnect to the database. This is managed by TAF itself. But we can if we want register to a callback function in order to be notified when a server goes down, but it's not necessary.

    Thank you for you help. By the way are you working for Oracle ?
    TAF is handled transparently. If you want TAF notifications, check out page 4-24 in the documentation. You shouldn't need OCI to use TAF notifications.
    Alex
  • 3004
    3004 Member Posts: 204,171
    Sorry, the documentation I was referring to was the ODP.NET beta doc:

    http://otn.oracle.com/docs/tech/windows/odpnet/odpnetbeta.pdf

    Take a look at page 4-24 where the failover event APIs are discussed. You are correct when you say notifications are not necessary to use TAF. Some ODP.NET applications may want to notify the user a failover is ocurring and to expect a short delay, but using notifications is optional.

    For more on TAF, check out:

    http://otn.oracle.com/deploy/availability/htdocs/taf.html
This discussion has been closed.