Symptom
After the Oracle database recovery (system refresh), below error is coming out,
ORA-25153: Temporary Tablespace is Empty
Solution
In case you are doing the system refresh activity, you can refer to the control file that you generated. There is command show on how to add the temporary tablespace (PSAPTEMP).
By the way, you can get rid the error by following command,
alter tablespace PSAPTEMP add tempfile 'filename' reuse;
Additionally, please refer to SAP Note 600513
