Unable to Connect to Oracle Database Using 'Connect to Database' Activity – ORA-28040 Error

Help Activities
, ,
1

Hello,

I am encountering an issue when attempting to connect to an Oracle database using the ‘Connect to Database’ activity in UiPath.

“ORA-28040: The database does not accept your client’s authentication protocol; login denied”
Details:

  • The issue occurs when using Database.Activities version 1.9.0 or 1.10.
  • I am able to successfully fetch data when using Database.Activities version 1.7.1, which suggests the problem may be related to changes in the authentication protocol or client libraries in newer versions.

Provider name: Oracle.ManagedDataAccess.Client
Oracle version: ORA11g(32bit)

Could you please help me understand how to resolve this issue with the newer versions of the Database.Activities package? Any guidance on compatibility or client configuration changes required would be appreciated.

Thank you in advance.
Muthukumar R

2

@muthukumar.rajendran

different oracle clients and server version cause this error

may be an old protocol is being used and the protocol used in latest version is not being supported

try to allow on oracle server side

The image contains a text excerpt about Oracle database authentication, highlighting the parameter and recommending a value of 10, with specific phrases and numbers highlighted in yellow. (Captioned by AI)
The image contains a text excerpt about Oracle database authentication, highlighting the parameter and recommending a value of 10, with specific phrases and numbers highlighted in yellow. (Captioned by AI)1902×262 53.4 KB

4 Au thentication Methods.

also on UiPath this is one of the requirements

A note informs users that Windows projects require a 64-bit driver installed on the machine to establish a database connection. (Captioned by AI)
A note informs users that Windows projects require a 64-bit driver installed on the machine to establish a database connection. (Captioned by AI)1116×132 7.5 KB

cheers

4

@Anil_G Thank you very much for your suggestion. let me try and revert back on this.

1 Like
5

@Anil_G We have installed the 64-bit Oracle client, but we are still encountering the same error when trying to connect to the Oracle database.

We would like to share an observation: the connection works successfully when using the UiPath.Database.Activities package version 1.7.1, but the issue arises when we use versions 1.9.0 and 1.10.0.

We would appreciate your support in understanding and resolving this issue. Specifically, we would like to know the following:

  1. What changes were introduced in versions 1.9.0 and 1.10.0 that could be affecting the Oracle DB connection?
  2. Is it possible for the UiPath team to modify the latest versions to behave similarly to version 1.7.1 in terms of Oracle DB connectivity?
  3. Are there any alternative solutions or workarounds that can be applied to resolve this issue while using the latest versions?

Please advise.
Thank you for your assistance in advance.

1 Like
6

@muthukumar.rajendran

All the latest activities use .net 6 or 8 unlike the old activities..that might be the difference. If you need complete deletes I would suggest either the code is exposed in github the link is here Github repositories can check that else if enterprise customer raise a support ticket

Referring to github code would help

if the ask is about backward compatibiltiy if those versions support is present for oracle then they might consider but its not like it would be done immediately ..that depends on the impact of the issue if it is because older version of oracle server in your system then it might not be supported..

a work around for that is to set the values in oracle server which I mentioned above..setting allowedlogonversion

cheers