Oracle Data Access Components

If you use Oracle RDBMs to host your database, you need to install Oracle Data Access Components (ODAC) version 12.2.0.1.0 32-bit.

About this task

Oracle Data Access Components (ODAC) is a set of tools to access, manipulate and manage database data stored on Oracle RDBMs. If you host your database using Oracle RDBMs, you need to install Oracle Data Access Components (ODAC) 12.2.0.1.0 32-bit. To correctly perform the installation, you need to access the target machine as an administrator. For further information, see the relevant Oracle documentation.

The package includes the following components:
  • Oracle Data Provider for .NET
  • Oracle Provider for OLE DB
  • Oracle Services for Microsoft Transaction Server

Procedure

  1. Go to the Oracle web site, download section, which should be the page where you can download the 32-bit Oracle Data Access Components product.
  2. Download the archive containing the ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.0), named ODTwithODAC122010.zip. Save it locally, and unzip it.
  3. Double click the setup.exe file to launch the Oracle Universal Installer (OUI) which will start the ODAC 12c Release Installer.
  4. In the installer, select the product language (for example English) and click Next
  5. Fill in the appropriate account information that will be used to run the Oracle services and click Next
  6. On the Specify Installation Location dialog window, enter the following details in the corresponding input fields, then click Next:
    • Oracle base: C:\Oracle;
    • Software location: C:\Oracle\product\12.2.0\client_1.
  7. On the Available Products Components dialog window, select the following components, then click Next:
    • Oracle Data Provider for .NET
    • Oracle Provider for OLE DB
    • Oracle Services for Microsoft Transaction Server
  8. On the ODP.NET (Oracle Data Provider for .NET) dialog window, make sure the Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level checkbox is checked, then click Next.
  9. On the Database Connection Configuration dialog window, click Next to confirm the pre-populated, default port number.
    Test your firewall settings to make sure the port is open and data traffic is allowed. The installer will start to do some prerequisite checks.
  10. On the Summary dialog window, review the installation configuration. If necessary, click Back to modify the options; otherwise, click Install to proceed with the installation.

Results

The selected components are installed. At the end of the operation, a confirmation dialog window is displayed to notify that the installation was performed correctly.