'ORA-01017 .NET Oracle.ManagedDataAccess using proxy user authentication

This issue is regarding .NET Oracle.ManagedDataAccess with Oracle 19c proxy user authentication, similar as this question.

Using Toad or SQL Developer, the connection works fine using the proxy syntax as username proxy[schema], so this doesn't seem to be a password problem. Even so, through the .NET application i get the error:

ORA-01017: invalid username/password; login denied

See below a simple code that reproduces the problem, trying to open the database connection:

static void Main(string[] args)
{
    using (var conn = new OracleConnection("USER ID=my-schema;DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=my-host-name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=my-service-name)));PROXY PASSWORD=********;PERSIST SECURITY INFO=True;PROXY USER ID=my-proxy-user;"))
    {
        conn.Open();
    }
}

The connection string was built based on this documentation.

Attempts:

  • I get the same error ORA-01017 when trying to use the standard connection string parameters (without specific proxy ones) with proxy[schema] sintax.

  • The connection opens with success when using ODP.NET (not Oracle.ManagedDataAccess) plus proxy[schema] sintax, without specific proxy parameters.

  • Tested on another Oracle 19c Database server, the provided source code that reproduces the issue worked with success.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source