UiPath Oracle DB Connection Error with 19c (ORA-12557: TNS:protocol adapter not loadable)

Help Studio
1

Hello Community,

I am trying to connect UiPath to an Oracle 19c database.
My current setup:

  • Oracle Instant Client 19c installed
  • Connection string:
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.###.##)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)));uid=ermapn;pwd=ermapn;
  • Provider: System.Data.OracleClient (default in Database Connect activity)

But I am getting the following error:

System.Data.OracleClient.OracleException: ORA-12557: TNS:protocol adapter not loadable

I saw that System.Data.OracleClient is deprecated and might not support Oracle 19c.

My questions:

  1. What is the correct provider name to use in UiPath for Oracle 19c?
  2. Should I replace System.Data.OracleClient with Oracle.ManagedDataAccess.Client?
  3. How should I correctly format the connection string for 19c in UiPath?
  4. Do I need to configure anything extra in Windows Credential Manager for UiPath to pick the new Oracle client?
2

Hey @hashan.l,

Use Oracle.ManagedDataAccess.Client as provider instead of deprecated System.Data.OracleClient. Connection string should be Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=servicename)));User Id=userid;Password=password;. No Windows Credential Manager setup is needed if credentials are included in the connection string.

1 Like
3

HI,Mir.Jasimuddin

hashan
hashan1280×514 173 KB

I followed the provided instruction to configure database credentials in UiPath.
Earlier we were on Oracle 10g, and now the DB has been upgraded to Oracle 19c.

I used the same hostname, port, and service name as before.
Connection string used:

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.###.##)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)));uid=ermapn;pwd=ermapn;

But now I am getting the error:

System.Data.OracleClient.OracleException: ORA-12557: TNS:protocol adapter not loadable
4

Hey @hashan.l,

This error usually happens because System.Data.OracleClient is deprecated and not compatible with Oracle 19c. Switch the provider in Database Connect activity to Oracle.ManagedDataAccess.Client and ensure the Oracle Managed Data Access DLL is installed. Update your connection string accordingly and retry the connection.

1 Like
5

hi,Mir.Jasimuddin

ok.I’ll try.
thank you Mir.Jasimuddin.

1 Like
6

Hi @hashan.l , please update the correct environment variable path after switching the Provider.