Documentation Center

Oracle Data Access Components

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

Before you begin

Install Oracle Data Access Components (ODAC) version 12.1.0.1.2 32-bit if the following conditions apply to your scenario:
  • You host your database on Oracle RDBMs;
  • You can access the target machine for the installation with administrator user rights.

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.1.0.1.2 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.

If you wish to retrieve the version tested with this Content Manager release, contact SDL to request it. The necessary files are part of the Oracle Database 12c Release 2 Client (12.1.0.1.2) for Microsoft Windows (32-bit).

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

Procedure

  1. Go to the On the Oracle web site, download section, and browse for the Oracle Data Access Components product.
  2. Download the appropriate archive, save it locally, and unzip it.
  3. Double click the setup.exe file to launch the Oracle Universal Installer (OUI) that will guide you through the install procedure, then click Next.
  4. On the product selection dialog window, select Oracle data Access Conponents for Oracle Client 12.1.0.1.2, then click Next.
  5. On the install location dialog window, enter the following details in the corresponding input fields, then click Next:
    • Oracle Base: C:\Oracle;
    • Path: C:\Oracle\product\12.1.0\client_1.
  6. On the Available Products Components dialog window, select the following components, then click Next:
    • Oracle Data Provider for .NET. 12.1.0.1.0
    • Oracle Provider for OLE DB 12.1.0.1.0
    • Oracle Services for Microsoft Transaction Server 12.1.0.1.0
    • Oracle Instant Client 12.1.0.1.0.
  7. 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.
  8. 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.