access violation in oracle.exe

access violation in oracle.exe

Postby MartinE » Mon 07 Oct 2013 14:00

Hello,

We use dotconnect for oracle to access an oracle database from a c# application. Now we observe the problem that from time to time oracle.exe is termiated due to an access violation. The database server runs without problems till the application with devart connector is started. Then it takes from seconds to hours till the access violation occur and the OS terminates oracle.exe When the error occur an core_orc1_pid_xxx file is written to the oracle-home database folder. Content of the file is:

An Unhandled Exception Occurred,
Exception Number : 0xc0000005
Exception Address : 0x7c93bdc6

Our environment:
- windows xp sp3 german 32bit
- oracle 11.2.0.1 and also 11.2.0.3
- .Net 3.5
- connect-mode: direct
- combination Devart.Data.dll 5.0.105.0 and Devart.Data.Oracle.dll 5.70.152.0 --> error comes more often then with
- combination Devart.Data.dll 5.0.781.0 and Devart.Data.Oracle.dll 7.9.322.0 --> error occur more rare but occur also

Following the connecting procedure of a test application to reproduce the problem (execute a connect to a locked user e.g. every second):

public static IDbConnection CreateConnection(string host, string sid, int port, string username, string password, int loginTimeout, int poolSize)
{
OracleConnectionStringBuilder oraCSB = new OracleConnectionStringBuilder();
oraCSB.Direct = true;
oraCSB.Server = host;
oraCSB.Port = port;
oraCSB.Sid = sid;
oraCSB.UserId = username;
oraCSB.Password = password;
oraCSB.ConnectionTimeout = loginTimeout; // e.g. 5000 ms
oraCSB.MaxPoolSize = poolSize; // e.g. 150

OracleConnection newCon = new OracleConnection(oraCSB.ConnectionString);
newCon.Direct = true;
newCon.AutoCommit = true;
newCon.Open();
return newCon;
}

Any ideas why this happen?

Regards,
Martin E.
MartinE
 
Posts: 1
Joined: Mon 07 Oct 2013 13:52

Re: access violation in oracle.exe

Postby Pinturiccio » Wed 09 Oct 2013 14:24

We could not reproduce the issue with provided code. In our environment your code works stable even with dotConnect for Oracle 5.70.152.0.

Could you please provide the following for reproducing the issue:
1. the kind of network you are working with: Wi-Fi, Internet or LAN;
2. How much memory and free disk space does the server have?
3. Send us a small test project that reproduces the issue.
Pinturiccio
Devart Team
 
Posts: 1954
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle