Unable to connect to DB - ORA-00604 and ORA-20099
Posted: 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.
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.