My Oracle Support Banner

DB Upgrade Throws ORA-25153: “Temporary Tablespace Is Empty” (Doc ID 843899.1)

Last updated on DECEMBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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:


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.