Stack Overflow
Stack Overflow

Questions tagged [ora-08177]

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

Error:: can't serialize access for this transaction

Cause: Encountered data changed by an operation that occurred after the start of this serializable transaction.

Action: In read/write transactions, retry the intended operation or transaction.

5 questions
21
votes
2 answers

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…
Denis K
  • 1,328
  • 1
  • 9
  • 15
18
votes
1 answer

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…
MOZILLA
  • 5,660
  • 13
  • 49
  • 58
2
votes
2 answers

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…
Jason Baker
  • 171,942
  • 122
  • 354
  • 501
0
votes
1 answer

how to create workspace in oracle XE

how to create workspace in oracle XE
Akshay
  • 1
0
votes
0 answers

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

I am facing the following exception intermittently. I am using the oracle database and not setting any isolation level ORA-08177: can't serialize access for this transaction org.springframework.dao.CannotSerializeTransactionException:…
Sammidbest
  • 381
  • 2
  • 9
  • 19