Difference between Oracle Client and ODAC

oracle odac
Vince Miccio picture Vince Miccio · Mar 26, 2015 · Viewed 33.7k times · Source

What is the difference between installing the full Oracle Client and an Oracle Odac install? Which will I need to do .NET development on my dev workstation and which will I need on the web application server that will connect with the Oracle database on another server?

Answer

piers7 picture piers7 · Jan 17, 2017

It's pretty confusing, and writing this down again helped me.

My summary:

  • The Oracle Instant Client only exposes direct OCI (Oracle Call Interface) APIs, so only relevant to Oracle-aware applications (see, say, http://www.oracle.com/technetwork/topics/winx64soft-089540.html )
  • ODAC includes the Instant Client, plus also a bunch of Microsoft-facing APIs on top of that (.net providers, ASP.Net membership provider, OLEDB driver, ODBC driver, MTS transaction coordinator) which cover what you'd need in most Windows application scenarios. eg http://www.oracle.com/technetwork/topics/dotnet/downloads/install112021-200037.html. ODAC comes in two flavours: the 'xcopy' version, and the OUI (Oracle Universal Installer) version (and only the OUI version includes SQL*Plus [#1])
  • ODT (Oracle Developer Tools for .Net) provides the Visual Studio integration, and is normally bundled with ODAC (you get a download called ODTwithODACxxxx.zip) eg http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
  • The Oracle.DataAccess nuget package is a version of the ODAC .net driver, so requires an existing Instant Client install (ie uses OCI). Confusingly, at one point this was labeled a managed driver (because it is, just has some significant non-managed local dependencies).
  • The Oracle.ManagedDataAccess nuget package is a fully-managed .net driver that works in 'direct' mode, and needs no local instant client

So for most .net people, 'Oracle Client' means OUI-installed ODAC Instant Client + .Net drivers, possibly also ODT.

For the nugets, it's worth pointing out that even now (Jan 2017) the Oracle.ManagedDataAccess driver still can't do a bunch of stuff[#2], so Oracle.DataAccess + InstantClient is not a totally obsolete option. If you are just reading and writing with SELECT/INSERT, or vanilla ADO.Net you will be fine. I'm told the EF support is much better than it used to be also. DevArt's dotConnect drivers are another (very good) option here.

There's also a nuget package for the Oracle instant client, but I have no idea what that is for. Presumably Win32/.Net native-OCI apps that want a zero-install Instant Client via nuget. Both of them.

[#1] SQL*Plus would presumably be little used at runtime, though there is a separate installer listed on the Instant Client download page if you want to to add it to an existing ODAC install.

[#2] eg: call oracle stored procedures with table-valued UDTs

Related questions

ORA-24338: Statement handle not executed

i'm using Delphi 7, Oracle 10, and ODAC Components. From the LoadTrainResult method I'm calling a storedProc. procedure TfrmTrain.LoadTrainResult; begin StoredProc.StoredProcName := 'PTRAIN.QTRAIN'; StoredProc.Prepare; try StoredProc.ParamByName('P_COURSE').AsString := CurrentSearch.Course; StoredProc.ParamByName('P_TOPIC').AsString := CurrentSearch.Topic; …

Read More
Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and …

Read More
OracleMTSRecoveryService failed to start?

i am getting this error while starting OracleMTSRecoveryService : Could not start the OracleMTSRecoveryService service on Local Computer. Error 1: Incorrect function.* Also during installation of ODAC service start failed. OracleXETNSListener is also not starting. i have reinstalled ODAC but problem remains. …

Read More