Monday, 29 December 2014

ORA-25153: Temporary Tablespace is Empty

ERROR:

Errors in file /u01/app/oracle/diag/rdbms/mzfcceoy/MZFCCEOY/trace/MZFCCEOY_m000_6385.trc:
ORA-25153: Temporary Tablespace is Empty
Sat Dec 27 07:42:26 2014
Errors in file /u01/app/oracle/diag/rdbms/mzfcceoy/MZFCCEOY/trace/MZFCCEOY_m001_6451.trc:
ORA-25153: Temporary Tablespace is Empty
Sat Dec 27 07:52:26 2014
Errors in file /u01/app/oracle/diag/rdbms/mzfcceoy/MZFCCEOY/trace/MZFCCEOY_m001_6519.trc:
ORA-25153: Temporary Tablespace is Empty
Sat Dec 27 08:02:27 2014
Errors in file /u01/app/oracle/diag/rdbms/mzfcceoy/MZFCCEOY/trace/MZFCCEOY_m002_6620.trc:
ORA-25153: Temporary Tablespace is Empty



Solution:
After cloning we get above error and when we check the dba_temp_Files or v$tempfile we dont have any temp file to DB.
So added the tempfile

alter tablespace temp add tempfile '<Location> size <GB>;

No comments: