Avoiding an Oracle Error When Upgrading the ETM® Database

Article #INS686

In certain ETM Database configurations, a database upgrade may fail with an Oracle
error stating that Oracle is not able to allocate additional segments to the UNDO
tablespace, such as the following error:

ORA-30036: Unable to extend segment by 4 in undo tablespace ‘UNDOTBS1’

This error may occur when the structure of the call-related tables has been altered
in the new software version if the existing call related tables contain a large
number of rows and AUTOEXTEND is disabled on the UNDO tablespace.

When this error occurs, the upgrade will be incomplete, without the call records
being reimported, requiring manual intervention to complete the upgrade.

To avoid this error, use the procedures in the attached document before beginning the
upgrade to determine whether AUTOEXTEND is enabled and if not and it cannot be, to
prepare the database for successful upgrade.

Click Download for more Details:

Published on November 13, 2012  |  Updated on August 24, 2021

Article Attachments

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!