'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 |
|---|
