Ora-08177: Can't Serialize Access For This Transaction After Upgrading To Database 11.2
Last updated on DECEMBER 08, 2017
Applies to:JDBC - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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:
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 220.127.116.11.0 and 18.104.22.168.0.
The problem does NOT occur with Oracle Database versions 22.214.171.124.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms