ORA-30036: Unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Josh

User avatar
Posts: 12
Joined: Thu Feb 16, 2017 11:20 am

Post by Support_Josh » Wed Aug 23, 2017 4:04 pm
Question:
When the automatic purging of our Oracle database occurs, the purge fails with the following error:
ERROR An error occurred while purging the audit logs for service 'FTP'
com.linoma.dpa.dao.DAOException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
at com.linoma.dpa.dao.rdbms.GFTPAuditLogDAOImpl.purge(Unknown Source)
at com.linoma.dpa.scheduler.AuditLogMonitor.purgeGFTPLog(Unknown Source)
at com.linoma.dpa.scheduler.AuditLogMonitor.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Answer:
Oracle databases contain an UNDO tablespace, which contains necessary information to rollback changes to the database. Detailed information about the UNDO tablespace can be found here: https://docs.oracle.com/cd/B19306_01/se ... 1/undo.htm
Purging of the GoAnywhere database usually occurs in smaller increments over a larger period of time. However, if the purge is large enough, the UNDO tablespace will run out of room thus throwing the above error. You will need to allocate additional resources to the UNDO tablespace in order to accommodate the size of the purge.
Database Explanation:
https://stackoverflow.com/questions/432 ... tablespace
Auto extend the UNDO tablespace:
http://www.dba-oracle.com/t_undo_tables ... extend.htm
Joshua Przybysz
Senior Support Analyst
e. goanywhere.support@helpsystems.com
p. 1.800.949.4696
w. HelpSystems.com
1 post Page 1 of 1