Upgrade fails due to issues while extending the TEMP tablespace
Issue
Upgrade of a TrueSight Network Automation application server using Oracle databases fails with the following exception in the installation log file (bcan_install_log.txt):
com.bmc.bcan.engine.database.persistence.DBTools updateBcanVersionInDb
java.lang.reflect.InvocationTargetException
...
Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
...
Caused by: Error : 1652, Position : 0, Sql = analyze table BCAN.EVENT compute statistics, OriginalSql = analyze table BCAN.EVENT compute statistics, Error Msg = ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
...
Failure with exit code 1
The system cannot find the path specified. ]]}
java.lang.reflect.InvocationTargetException
...
Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
...
Caused by: Error : 1652, Position : 0, Sql = analyze table BCAN.EVENT compute statistics, OriginalSql = analyze table BCAN.EVENT compute statistics, Error Msg = ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
...
Failure with exit code 1
The system cannot find the path specified. ]]}
Fix
Alter the TEMP tablespace to set the AUTOEXTEND option to ON, and run the upgrade process again.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*