Skip to main content
Kofax

KSMS - Oracle driver installation

Article # 3039888 - Page views: 60

Issue

How to install the Oracle client driver for KSMS?

Oracle database driver does not get initialized.

Error message: Could not load file or assembly Oracle.ManagedDataAccess

Solution for 6.9

The KSMS installation guide explains on how to install the Oracle driver.

https://docshield.kofax.com/Portal/P...tsx4p/KSMS.htm 

Here are the details:

If you are using an Oracle database, it is necessary to install the Oracle driver. You can install the driver by following these steps:

  1. Navigate to the Oracle driver website at https://www.oracle.com/database/technologies/dotnetodacdeploy-downloads.html.
  2. Under to ODAC XCopy section, download the " ODAC XCopy 64-bit ODAC 19.3" driver zip file. If you do not have an Oracle download account then you can create a account.
  3. Unzip the Oracle driver zip file.
  4. From the extracted files, copy <extractedfiles>\odp.net4\odp.net\managed\common\Oracle.ManagedDataAccess.dll and copy it to the following locations on the server where Kofax Search and Matching Server is installed.
    • C:\Program Files\Kofax\SearchMatchingServer  -  Important If the installation path has been configured to use a different location than the default path, then please adjust accordingly.
  5. Restart the Kofax Search and Matching Server service. The service restarts and it is now possible to configure an oracle database connection.

 

If you still face the error then uninstall any previous installed Oracle driver (e.g. 12.2) as these are not required anymore for KTM 6.4 or KSMS 6.9.

Solution for 6.8

Steps as listed in the KSMS installation guide:

If you are using an Oracle database, it is necessary to install the Oracle driver. You can install the driver by following these steps:

  1. Navigate to the Oracle driver website at https://www.oracle.com/technetwork/topics/dotnet/downloads/odacdeploy-4242173.html.
  2. From the ODAC XCopy category, download the Managed ODP.NET 12.2.0.1.0 Oracle driver. (Filename: ODP.NET_Managed_ODAC122cR1.zip)
    The ODO.NET 12.2.0.1.0 driver is compatible with the following Oracle database versions: 11g, 12c, as well as 18c.
  3. Copy your downloaded file to where Kofax Search and Matching Server is installed.
  4. Unzip the driver and then run the following command:
    install_odpm.bat [oracle_home_path] [platform] true

    For example, install_odpm.bat C:\oracle x64 true.
    Oracle.ManagedDataAccess.dll is installed into the GAC so that it is available to Kofax Search and Matching Server. There is no need to restart your server.
  5. Optionally, uninstall the driver using the following command:

    uninstall_odpm.bat [oracle_home_path] [platform] true.

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
Kofax Search and Matching Server 6.8, 6.9      

References

Add any references to other internal or external articles

 

Article # 3039888