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 to [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 05-Sep-2013


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


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