7 Replies Latest reply: Oct 5, 2012 7:55 AM by Johnsung-Oracle RSS

    Oracle driver binaries

    user8960976
      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
          I need ODP.NET 11.2.0.3.0
          • 2. Re: Oracle driver binaries
            yoonas
            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
              I know where it is available. :)

              But what are the differences?
              Is ODAC for the production enviromrent?
              • 4. Re: Oracle driver binaries
                Johnsung-Oracle
                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
                  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
                    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-Oracle
                      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