ERROR

ORA-01552: cannot use system rollback segment for non-system tablespace 'SDE'

Last Published: April 25, 2020

Error Message

ORA-01552: cannot use system rollback segment for non-system tablespace 'SDE'

Cause

This error can occur while attempting to bring ArcSDE up for the first time after Oracle 8.1.5 has been recently installed. When Oracle 8.1.5 Server was installed, the initialization of the rollback segments in the init.ora file was left commented out after installation.

Solution or Workaround



Shut down the Oracle instance, uncomment the rollback_segments parameter in the Oracle instance's init.ora file and restart the Oracle instance.


Article ID:000002316

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic