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

How to resolve "System.data.oracleclient requires oracle client software version 8.1.7 or greater" error?

Problem

Users trying to connect or execute any queries on Oracle database server by using UiPath.Database.Activities might encounter the following error : "System.data.oracleclient requires oracle client software version 8.1.7 or greater"

Solution

The issue is caused by the fact that the authenticated user is missing the Oracle Data Access Component needed to run the process.

  1. Check if already have the ODAC installed :

    <ol style="margin: 0px;padding: 0px 0px 0px 40px;list-style-type: lower-alpha;"><li>
    	<p><span style="color: rgb(60, 69, 86);" uipath_custom_id="18">From a Run command run regedit</span></p>
    	</li><li style="margin-top: 4px;">
    	<p><span style="color: rgb(60, 69, 86);" uipath_custom_id="19">Check for the following location in registry (or similar) Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ODP.NET.Managed\4.122.1.0</span><br>		<span style="color: rgb(60, 69, 86);" uipath_custom_id="20">and a key like C:\oracle\product\12.2.0\client_1\network\admin or similar</span></p>
    	</li></ol>
    </li><li style="margin-top: 4px;">
    <p>If there's no Oracle Client installed proceed to download it from Oracle (<a href="https://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html" target="_blank">here</a>)</p>
    </li><li style="margin-top: 4px;">
    <p>Install ODAC by following installation steps provided.</p>
    </li></ol>
    


    This step is independent of the Oracle server used or Oracle client version.
     

    Version

    Up to versions:

    Studio - 2018.4.4

    UiPath.Database.Activities 1.2.6863.32528