This content has been marked as final. Show 7 replies
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
Edited by: Johnsung on Oct 4, 2012 10:51 AM
11g Release 2 is older, and doesn't actually contain Entity Framework IIRC. The patched version to bring it up to 22.214.171.124 (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. :)
The Oracle Client 126.96.36.199 is an early version and released on September 2009.
As Tridus says this was before some of the new features you see in the latest ODAC.
With 188.8.131.52 base you get ODP.net 184.108.40.206.
If you have a support agreement you can get the 220.127.116.11 Client via My Oracle Support and with a later patch
provides support for EF.