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