EMCA Fails With Error "ORA-25153: Temporary Tablespace is Empty" Due to Temp Tablespace Limitations (Doc ID 353008.1)

Last updated on SEPTEMBER 05, 2013

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 05-Sep-2013

Symptoms

Using Enterprise Manager Configuration Assistant (EMCA) to create dbconsole fails with the following error:-

EMCA 10.1:

BEGIN dbms_stats.gather_dictionary_stats; END;
*
ERROR at line 1:
ORA-00904: "SYS_DS_ALIAS_13": invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 12440
ORA-06512: at "SYS.DBMS_STATS", line 12734
ORA-06512: at "SYS.DBMS_STATS", line 15030
ORA-06512: at "SYS.DBMS_STATS", line 15072
ORA-06512: at line 1

 EMCA 10.2

BEGIN dbms_registry.loaded('EM'); END;

*
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 13336
ORA-06512: at "SYS.DBMS_STATS", line 13643
ORA-06512: at "SYS.DBMS_STATS", line 15985



It may fail also with the following error:


ORA-00904: "T2"."SYS_DS_ALIAS_22": invalid identifier

Cause

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