My Oracle Support Banner

Ora-08177: Can't Serialize Access For This Transaction After Upgrading To Database 11.2 (Doc ID 1291983.1)

Last updated on MARCH 14, 2023

Applies to:

JDBC - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Application using Oracle JDBC driver gives error ORA-08177: can't serialize access for this transaction 
when working against an Oracle 11.2 database.

Application does the following:

conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
Create Table
Create Index
Select * from Table
insert into tbl values (23)


The error occurs with Oracle JDBC driver. It is  also seen with DataDirect JDBC and ODBC Wire Protocol drivers.
The problem occurs with Oracle Database versions 11.2.0.1.0 and 11.2.0.2.0.
The problem does NOT occur with Oracle Database versions 11.1.0.6.0 or 10.2.0.5.0.


While testing with TRANSACTION_READ_COMMITTED no issues are observed, however while using TRANSACTION_NONE,
TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ , TRANSACTION_SERIALIZABLE, the error occurs.

Example:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.