DBUtil Oracle Option Disabled After Oracle 18c/19c Client Installation

Issue

How can I resolve an issue where the Oracle option is disabled in DBUtil after installing an Oracle 18c or Oracle 19c client?

 

Solution

Follow the solution below to manually register an Oracle 18c or Oracle 19c client to the Windows GAC as they are not automatically registered to the Windows GAC during installation.  Please make sure to use either the Oracle 18c client (32-bit ODAC 18.3) and the Oracle 19c client (32-bit ODAC 19.3) indicated in the note below.

 

To resolve this issue, follow the steps below:

1. Traverse to the C:\Oracle\odp.net\bin\2.x folder in an Elevated Command Prompt.

 

2. Install the ODP.NET to the Windows GAC by running the following command:

OraProvCfg.exe /action:gac /providerpath:"C:\Oracle\odp.net\bin\2.x\Oracle.DataAccess.dll"

 

3. Install the Publisher Policy DLL to the Windows GAC by running the following command:

OraProvCfg.exe /action:gac /providerpath:"C:\Oracle\odp.net\PublisherPolicy\2.x\Policy.2.102.Oracle.DataAccess.dll"

 

The above procedure was tested with both Oracle 18c client (32-bit ODAC 18.3) and the Oracle 19c client (32-bit ODAC 19.3).

 

Level of Complexity 

Moderate

 

Applies to  

Product	Version	Build	Environment	Hardware
Kofax Capture	11.0 11.1

References

Below is the download link where you can download the Oracle 18c client (32-bit ODAC 18.3) and the Oracle 19c client (32-bit ODAC 19.3) under the ODAC XCopy section:

https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html