ora-08177

ORA-08177: can't serialize access for this transaction

I have a very simple code using ADO.NET which throws ORA-08177 exception. I am not sure what's wrong with this. I am trying this on a windows vista machine which has oracle 32 bit client installed. My compile option for visual studio is set to x86 platform. Dim connection As OracleConnection = Nothing Dim transaction As OracleTransactio...

Can I get ORA-08177 if there's only one connection to the database?

I've been tasked with running the unit tests on a storm backend for oracle so that we can see if the backend is of sufficient quality to use in production. One problem that I'm running into is that I'm getting ORA-08177 (can't serialize access for this transaction) if I connect in serializable mode. The problem goes away when I use rea...

Randomly getting ORA-08177 with only one active session

I'm running a program that creates a table and then inserts some data. This is the only program that accesses the database. I'm getting ORA-08177 randomly. Actual code is somewhat complex, but I've written a simple program that reproduces this behavior. using System; using System.Data; using Oracle.DataAccess.Client; namespace orabug...