SOA 12.1.3: Undo tablespace becomes exhausted during purge operations (Doc ID 2224031.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

While purging the undo tablespace is getting exhausted and returning the following errors:

MDS-00001: exception in Metadata Services layer
MDS-00522: failure to save document xxx to the metadata repository
java.sql.SQLException: ORA-01552: cannot use system rollback segment for non-system tablespace 'EMPDEV3_MDS'
ORA-06512: at "EMPDEV3_MDS.MDS_INTERNAL_COMMON", line 1987
ORA-06512: at line 1


MDS-00001: exception in Metadata Services layer
MDS-00522: failure to save document xxx to the metadata repository
java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
ORA-06512: at "EMPDEV3_MDS.MDS_INTERNAL_COMMON" line 2110
ORA-06512: at "EMPDEV3_MDS.MDS_INTERNAL_COMMON" line 1930
ORA-06512: at line 1

 

Cause

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