DB Upgrade Throws ORA-25153: “Temporary Tablespace Is Empty”

(Doc ID 843899.1)

Last updated on MAY 09, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


After applying the patchset software on top of a ORACLE_HOME, the Post Installation section of the patchset README file is used to upgrade database objects from to When using the DataBase Upgrade Assistant (DBUA) to go from to, you may encounter ORA-25153 and ORA-06512 errors similar to the following when you select the database to upgrade:


ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at line 2969

Trying to manually upgrade with the catupgrd.sql script also gives the same ORA-25153 and ORA-06512 errors at line 2969 when the "utlu102i.sql" script is run in the preliminary steps.


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