Resolving ORA-30036 Error: Unable to Extend Segment by X in Undo Tablespace (KBA1834)

KBA

KBA#1834

At a Glance

Description:	This KBA describes how to avoid and resolve ORA-30036: unable to extend segment by [x] in undo tablespace "xyz".
Affects versions:	This issue is a database issue and affects all Masking Versions.
ORA Error:	ORA-30036: unable to extend segment by [x] in undo tablespace "xyz"
Masking step:	This error can happen on both In-Place (IP) and On-The-Fly (OTF) jobs. and in the following two steps: In-Place (IP): DelphixTableUpdate.n On-The-Fly (OTF): DelphixTableInsert.n
Root Cause:	The specified UNDO tablespace has no more space available to perform UPDATE or INSERT.
Solution:	The UNDO tablespace is too small. The action here is to either: Set autoextend on the UNDO tablespace, or Manually create a new bigger UNDO tablespace and use this one. For details, contact your DBA for assistance. For details, please see Oracle Doc ID 460481.1

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
5.2	5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
5.1	5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0
5.0	5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Issue

ORA-30036 error is reported when the current Undo tablespace has no more free space available for the active transactions. This issue has to be resolved in order to proceed.

Error message

Error message in logs

The error message is:

ORA-30036: unable to extend segment by [x] in undo tablespace "xyz"

and the error is in either of these two steps (In-Place or On-The-Fly).

IP:

DelphixTableUpdate.n

OTF:

DelphixTableInsert.n

Full example from job log (and info.log):

[JOB_ID_xx_yy] 0000/00/00 00:00:00 - DelphixTableUpdate.0 - ORA-30036: unable to extend segment by 1234 in undo tablespace "xyz"

Troubleshooting

To troubleshoot this error, use 'sqlplus' on a terminal and:

Check free space in the UNDO tablespace.
Check if the specified UNDO tablespace in autoextensible.
Check unexpired extents.
Check the status of the UNDO extents.

For details on the steps above please see Oracle Doc ID 460481.1.

Solution

The UNDO tablespace is too small. The action here is to either:

Set autoextend on the UNDO tablespace, or
Manually create a new bigger UNDO tablespace and use this one.

For details, contact your DBA for assistance. For details, please see Oracle Doc ID 460481.1

KBA