"System.data.oracleclient requires oracle client software version 8.1.7 or greater" Error in UiPath.Database.Activities

News Knowledge Base
1

How to solve "System.data.oracleclient requires oracle client software version 8.1.7 or greater" error in UiPath.Database.Activities

Issue Description

When using UiPath.Database.Activities for connection or execution of any queries on the Oracle database server, an error message may appear: "System.data.oracleclient requires oracle client software version 8.1.7 or greater".

Resolution

This issue can arise due to the absence of Oracle Data Access Component (ODAC), which is vital for the process execution.

To remedy this problem, follow these steps:

  1. Verification of ODAC installation:
    • Run the 'regedit' command from the Run dialogue box.
    • Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ODP.NET.Managed\4.122.1.0 in the registry.
    • Search for a key similar to C:\oracle\product\12.2.0\client_1\network\admin.
  2. In absence of Oracle Client, download from Oracle Data Access Components.
  3. Install ODAC using the installation steps provided.

Note: This solution applies regardless of the specific Oracle server in use or the version of Oracle client.

1 Like
2

Thanks for Posting its Working…