This discussion is archived
7 Replies Latest reply: Oct 5, 2012 5:55 AM by Johnsung RSS

Oracle driver binaries

user8960976 Newbie
Currently Being Moderated
Maybe the wrong sub-forum but i couldn't find a better fit.

if I use these technologies

ODP.NET
ODBC
DOA
Java thin client

What should I install in the production environment?

Oracle Database 11g Release 2 Client
or
ODAC 11.2 Release 5

What is the difference?

Thanks
  • 1. Re: Oracle driver binaries
    user8960976 Newbie
    Currently Being Moderated
    I need ODP.NET 11.2.0.3.0
  • 2. Re: Oracle driver binaries
    yoonas Expert
    Currently Being Moderated
    Hi,

    Download fom the below link
    http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html

    Thank you
    Yoonas
  • 3. Re: Oracle driver binaries
    user8960976 Newbie
    Currently Being Moderated
    I know where it is available. :)

    But what are the differences?
    Is ODAC for the production enviromrent?
  • 4. Re: Oracle driver binaries
    Johnsung Pro
    Currently Being Moderated
    What are the differences? Well in general,

    ODAC is a bundle containing the Windows interfaces and the Oracle Instant client.
    It's convenient if your a developer and also has some of the latest features such as VS 2012 support/ ODT for Visual Studio. etc.
    Often the new features will appear in ODAC first .

    The standard Oracle Client has more install options - It has instant client as well as administrator / runtime install options (which are not instant clients).
    Those other install options can install additional components / utilities not featured in ODAC such as OraPKI (for wallets), tnsping, etc.
    If you run the installer you can see exactly what gets installed in a full administrator install - for most deployment purposes you probably won't need
    the majority of the components in the admin install.

    For production I believe either is applicable.

    Hope this helps
    John

    Edited by: Johnsung on Oct 4, 2012 10:51 AM
  • 5. Re: Oracle driver binaries
    user8960976 Newbie
    Currently Being Moderated
    Hi John, thanks alot for your answer!

    Oracle Database 11g Release 2 Client seems to be older.
    Actually I cannot find information such as the relase date and what the version of the odp.net it contains!
    Is this information available?
  • 6. Re: Oracle driver binaries
    Tridus Journeyer
    Currently Being Moderated
    11g Release 2 is older, and doesn't actually contain Entity Framework IIRC. The patched version to bring it up to 11.2.0.3 (which does contain EF) is available through the Oracle support website but not on the main download page for some reason. I have no idea why.

    The ODAC download comes with the Instant Client, which I think will have everything you need. Not 100% sure on that though, I don't do Java these days. :)
  • 7. Re: Oracle driver binaries
    Johnsung Pro
    Currently Being Moderated
    The Oracle Client 11.2.0.1 is an early version and released on September 2009.
    Reference:
    http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf#page=7

    As Tridus says this was before some of the new features you see in the latest ODAC.
    With 11.2.0.1 base you get ODP.net 11.2.0.1.

    If you have a support agreement you can get the 11.2.0.3 Client via My Oracle Support and with a later patch
    provides support for EF.

    John

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points