c# - Attempted to read or write protected memory in Oracle 11g with ODP.NET -


i developing application supposed run long periods , make extensive usage of oracle (11g) database via odp.net.

it happens, though, once in while (every 2 or 3 days) system.accessviolationexception thrown odp.net , application needs restarted. here stack trace:

unhandled exception: system.reflection.targetinvocationexception: exception has been thrown target of invocation.  ---> system.accessviolationexception: attempted read or write protected memory. indication other memory corrupt. @ oracle.dataaccess.client.opssql.prepare2(intptr opsconctx, intptr& opserrctx, intptr& opssqlctx, intptr& opsdacctx, oposqlvalctx*& poposqlvalctx, string pcommandtext, intptr& putf8commandtext, opometvalctx*& popometvalctx, int32 prmcnt) @ oracle.dataaccess.client.oraclecommand.executenonquery() 

the rest of stack trace different time time , refers internal calls application.

now, i've made fair amount of research before asking here, have found nothing conclusive. number of other people apparently experiencing same problem, although root causes seem vary lot. hope has solution 1 :-)

on unrelated note, appears exception capable of ignoring catch {} blocks , result in application crash every time occurs. because related memory corruption issues?

regards, andrea

edit: further investigation led me believe worth starting "distributed transactions coordinator" service , see if exception stops being thrown. think?

this bug. 11.1 , 11.2 providers had issue. way around install 11.2.0.2 client , apply patch 6.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -