Unable to connect to DB - ORA-00604 and ORA-20099
Unable to connect to DB - ORA-00604 and ORA-20099
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Unable to connect to DB - ORA-00604 and ORA-20099
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.
Re: Unable to connect to DB - ORA-00604 and ORA-20099
Is there any way that you send us a custom build so that we can set AUTH_ parameters from our app ?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Unable to connect to DB - ORA-00604 and ORA-20099
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.
Re: Unable to connect to DB - ORA-00604 and ORA-20099
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 .
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 .
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Unable to connect to DB - ORA-00604 and ORA-20099
We have answered you via e-mail.
Re: Unable to connect to DB - ORA-00604 and ORA-20099
The custom build solves the problem.
Thanks.
Thanks.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Unable to connect to DB - ORA-00604 and ORA-20099
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
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