If your DB13 actions finished with  “ORA-25153: Temporary Tablespace is Empty” error message then you should check your database TEMP tablespace first…

Let’s check an example about the issue ;

DB13 actions finished with error like below

Click one of it to get more info

Check the detail log

ORA-25153: Temporary Tablespace is Empty
ORA-06512: at “SYS.GET_STATS_EXTENSION”, line 12

Go to DB02 and check the TEMP tablespace status (PSAPTEMP)

For our situation it looks like no temp datafile assigned to the system

Add Tempfile or Create new tablespace

Add new Tempfile ;

ALTER TABLESPACE PSAPTEMP
ADD TEMPFILE ‘O:\ORACLE\SID\SAPDATA5\TEMP_1\TEMP.DATA1′ SIZE 2G
 REUSE AUTOEXTEND ON NEXT 100M  MAXSIZE 10G;

Create new Temporary Tablespace ;

CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE
 ‘O:\ORACLE\SID\SAPDATA5\TEMP_1\TEMP.DATA1′ SIZE 3G AUTOEXTEND ON
NEXT 100M MAXSIZE 10G;

Now we can check the DB02 again and we should get a screen like below ;

Now we can try again DB13 actions and i hope also your actions will be completed successfull like below…