Installing ODP.NET Driver for Content Composer Server and Studio - Installation - Foundation 23.2 - Foundation 23.2 - Ready - Content Composer - external - Content-Composer/Installation/Foundation-23.2/Content-Composer-Installation/Installing-Content-Composer/Oracle-Prerequisites/Installing-ODP.NET-Driver-for-Content-Composer-Server-and-Studio - 2024-03-25

Content Composer Installation
Platform
Content Composer
Product
Installation
Release
Foundation 23.2
License
To install the ODP.NET driver, complete the following steps:
  1. To perform the installation using the XCOPY installer, complete the following substeps:
    1. Go to https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html and locate the ODAC XCopy section.
    2. Download 64-bit ODAC 19.3.
    3. Unzip the downloaded file.
    4. Open a command prompt window as an administrator and navigate to the directory that contains the contents of the 64-bit ODAC 19.3 ZIP file.
    5. Execute the following command.
      install.bat odp.net4 [oracle installation directory][oracle home key] true true

      Example 

      install.bat odp.net4 c:\oracle odac true true
  2. To perform the installation using the Oracle Universal Installer (OUI), complete the following substeps:
    1. Go to https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html and locate the ODAC OUI section.
    2. Download 64-bit ODAC 19.3.1.
    3. Unzip the downloaded file and then run the setup.exe file included in the ZIP file.
    4. On each page, provide the required information and then click Next.
      Note: In the Available Product Components page, select only Oracle Data Provider for .NET. Other components are not required.
    5. Review the summary and then click Install.
  3. Add the ODP.NET installation directory and its bin subdirectory to the Windows environment variable PATH, if not yet present.

    Example

    If C:\Oracle is the installation directory, add C:\Oracle and C:\Oracle\bin.

    Note: Ensure to place the newly added directories before all other Oracle directories.
  4. To register the Oracle.DataAccess.dll in the Global Assembly Cache (GAC), complete the following substeps:
    1. Open a command prompt window as an administrator and navigate to the directory that contains the OraProvCfg.exe file.
      Note: The default directory is [Oracle installation directory]\odp.net\bin\4.
    2. Execute the following command. 
      oraprovcfg /action:gac /providerpath:[full path to Oracle.DataAccess.dll]

      Example 

      oraprovcfg /action:gac /providerpath:C:\oracle\odp.net\bin\4\Oracle.DataAccess.dll