Siebel IP2017: Upgphys fails with ORA-01652: unable to extend temp segment in tablespace error

(Doc ID 2360099.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Siebel Service Enterprise - Version 17.3 [IP2017] and later
Information in this document applies to any platform.


On : 17.3 [IP2017] version, Upgrade

When attempting to upgrade to IP2017, upgphys fails and the following error occurs.

2018-02-07 13:35:27 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01652: unable to extend temp segment by 16 in tablespace SEA_INDEX
2018-02-07 13:35:27 writeExecDDL error (pOperCallback UTLDbDdlOperIndCreate).
2018-02-07 13:35:27 Error in MainFunction (UTLDbDdlDbMerge).
2018-02-07 13:35:27 Error in Main function...
2018-02-07 13:35:27 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

The issue can be reproduced at will with the following steps:
1. Perform upgrade to IP2017
2. Make sure upgrep/IRM is completed along with FULLPUBLISH
3. Test and see if upgphys is completed.

The issue has the following business impact:
Due to this issue, users cannot complete upgphys and this was causing a setback as errors were encountered.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms