UiPath - Connect to Oracle database

This error generally occurs if you are using the 64 bit Oracle client. As UiPath is a 32 bit application, this issue is occurring. Please make sure that you have 32 bit oracle client installed. Please visit the below links for more insights-

Download 32bit client for ODBC here:

https://www.oracle.com/in/database/technologies/instant-client/microsoft-windows-32-downloads.html

Follow below link to setup the instant client:

https://www.youtube.com/watch?v=yFO-3dCegJA

Go to C:\Windows\SysWOW64\odbcad32 Application and add  ODBC connection.


https://stackoverflow.com/questions/9002560/oracle-client-and-networking-components-were-not-found
https://superuser.com/questions/939752/microsoft-odbc-driver-cant-find-oracle-instant-client





https://forum.uipath.com/t/how-to-connect-to-oracle-database/2925/3

https://youtu.be/cZDDI9HFBIU


Make sure you have  tnsnames.ora & sqlnet.ora in C:\oracle_odbc

Add TNS_ADMIN - system_path
Add Path - C:\oracle_odbc to existing Path

Use -  TOAD to generate sqlnet.ora file  ->


###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
#$Header: NetServiceHandler.java 120.19.12010000.6 2010/03/09 08:11:36 jmajumde ship $
#
###############################################################

SQLNET.INBOUND_CONNECT_TIMEOUT =60
DIAG_ADR_ENABLED=ON



IFILE=/u01/app/oracle/product/11.2.0.4/network/admin/sqlnet_ifile.ora
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME=10
TRACE_FILELEN_CLIENT=100
TRACE_FILENO_CLIENT=3
TRACE_LEVEL_CLIENT=OFF
TRACE_TIMESTAMP_CLIENT=ON
TRACE_UNIQUE_CLIENT=ON
USE_DEDICATED_SERVER=OFF





Download 32 bit driver here:
https://www.oracle.com/database/technologies/112010-win32soft.html