ora-60 deadlock detected

Last Published: April 25, 2020

Error Message

When creating a geometric network it is possible to encounter the Oracle error:

"ora-60 deadlock detected"

This occurs when using the LOB storage type for the logical network.

Additional information is present in the sde.errlog: S_update_attr_LOBS::OCILobWrite error (-51)

Additional information is also present in the Oracle alert log:
ORA-000060 Deadlock detected. More info in file <path>/<name>.trc


The cause of the problem is Oracle bug '3166756 Self deadlock (ORA-60) possible on LOB index update'.

See Oracle's Metalink for additional information.

The problem is present in releases, and and reported as being fixed in releases and

Solution or Workaround

Select an option below:

  • Upgrade to Oracle release
  • Set the following Oracle event in the init.ora file:

    event='10235 trace name context forever, level 2'

    Once enabled the geometric network builds successfully.

Article ID:000007741

  • ArcMap 9 x
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options