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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
l1101100
Posts: 4
Joined: Mon 12 Feb 2018 19:24

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

Post by l1101100 » Mon 12 Feb 2018 20:02

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Tue 13 Feb 2018 13:41

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
Posts: 4
Joined: Mon 12 Feb 2018 19:24

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

Post by l1101100 » Tue 13 Feb 2018 14:19

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

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Tue 13 Feb 2018 14:40

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
Posts: 4
Joined: Mon 12 Feb 2018 19:24

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

Post by l1101100 » Thu 08 Mar 2018 18:34

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Thu 15 Mar 2018 14:36

We have answered you via e-mail.

l1101100
Posts: 4
Joined: Mon 12 Feb 2018 19:24

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

Post by l1101100 » Mon 19 Mar 2018 23:46

The custom build solves the problem.

Thanks.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Fri 30 Mar 2018 15:33

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

Post Reply