Unable to connect to DB - ORA-00604 and ORA-20099

[l1101100]

We are using dotConnect for Oracle v9.5.429 with .NET Core 2.0 on RHEL 7.4, and we are connecting to Oracle11g server over TNS.

In our test site everything works fine. But when deployed to production which is by the way very secured, we are unable connect to DB.

Unhandled Exception: Devart.Data.Oracle.OracleException: ORA-00604: error occurred at recursive SQL level 1
ORA-20099: [username] can not connect from CROSS OS User CROSS(10.0.0.10) to [dbname].

After deep investigation at both sides we found that the problem is in AUTH_ values (AUTH_TERMINAL, AUTH_PROGRAM_NM, AUTH_MACHINE, AUTH_SID), they are all set to "CROSS" except AUTH_SID which is set to "Cross", but they should be set from environment (host name, user executing the app, etc.) or at least we should be able to set them programmatically.

JDBC reference AUTH variables on github
Oracle Authentication

Because of problem we are unable to continue deployment, so we need a solution ASAP.

Thank you.

[Pinturiccio]

dotConnect for Oracle does not support sending AUTH_TERMINAL, AUTH_PROGRAM_NM, AUTH_MACHINE, and AUTH_SID information in the Direct mode for .NET Core 2.0 applications. We will investigate the possibility to implement such feature and post here about the results.

[l1101100]

Is there any way that you send us a custom build so that we can set AUTH_ parameters from our app ?

[Pinturiccio]

We will create an internal build for you when we implement AUTH_ parameters in the Direct mode for .NET Core 2.0, but we cannot confirm any timeframe when it will be implemented.

[l1101100]

Any update on this issue ?
I really don't understand why would you set hard coded constant values when you can easily get actual values of AUTH_ params by using Environment.UserName and Environment.MachineName .

[Pinturiccio]

We have answered you via e-mail.

[l1101100]

The custom build solves the problem.

Thanks.

[Pinturiccio]

New build of dotConnect for Oracle 9.5.483 is available for download.
It can be downloaded from https://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only). We have also updated our NuGet package: https://www.nuget.org/packages/Devart.Data.Oracle/
For more information, please refer to viewtopic.php?t=36966