Resolving ORA-30036 Error: Unable to Extend Segment by X in Undo Tablespace (KBA1834)
KBA
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:
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
Related Articles
- KBA: How to Troubleshoot Masking Jobs and Access Masking Logs (KBA7988)
- KBA: Resolving ORA-01555 Error: Snapshot Too Old (KBA1827)
- Oracle Docs: Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace (Doc ID 460481.1) (login required).