Oracle Data Provider for Microsoft .NET

  1. Download and extract the latest Oracle Data Access Components Runtime (ODAC XCopy) containing the Oracle Data Provider for Microsoft .NET (unmanaged) version 12.1.0.X.X from https://www.oracle.com/database/technologies/dotnet-odacdev-downloads.html.
  2. In an elevated command line prompt, enter the following command: install.bat odp.net4 %systemdrive%\oracle odac.
  3. Click Microsoft Windows System, click Advanced System Settings, click Environmental Variables, click Path, and then add the paths c:\oracle and c:\oracle\bin in front of other Oracle paths.
  4. Copy tnsnames.ora and sqlnet.ora from the Oracle client installation to c:\oracle\network\admin.
  5. Restart your system.