ORA-08177: Can't Serialize Access For This Transaction After Upgrading To 11.2

(Doc ID 1285464.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
** Checked for relevance on 25-Jul-2012 **
*** Checked for relevance on 12-Apr-2016 ***


Getting the following error using an application after upgrading to 11.2 - application has submitted a serialized transaction.
ORA-08177: can't serialize access for this transaction
Transaction had worked without error on previous version of Oracle.


In Oracle 11.2, the default segment creation is now deferred and not immediate as in previous versions.


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