ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.

Meta link id: Error Executng Begin Fnd_gsm_util.Append _ctx_fragment(?,?,?); End; ORA-25153 [ID 370793.1]

Symptoms
======
When attempting to run adcfgclone.pl from a hotbackup ,the following error occurs.

Autoconfig failed on RDBMS ORACLE_HOME after configuring adcfgclone.pl dbTechStack with the below error message
==================================================================

oradev@ctssd $ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/11.2.0/appsutil/log/erpoltp_erpoltp/07132119/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /erpoltp/oracle/11.2.0
Classpath : /u01/oracle/11.2.0/jdk/jre/lib/rt.jar:/u01/oracle/11.2.0/jdk/lib/dt.jar:/u01/oracle/11.2.0/jdk/lib/tools.jar:/u01/oracle/11.2.0/jdbc/lib/ojdbc5.jar:/u01/oracle/11.2.0/appsutil/java/xmlparserv2.zip:/u01/oracle/11.2.0/appsutil/java:/u01/oracle/11.2.0/jlib/netcfg.jar:/u01/oracle/11.2.0/jlib/ldapjclnt11.jar

Using Context file : /u01/oracle/11.2.0/appsutil/erpoltp_erpoltp.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:249)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1663)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709)
FAILED
COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

oradev@ctssd $


Cause

This error is usually a direct results of using adcgfclone.pl from hot back up.
Temporary tablespace is empty.

Solution

To implement the solution, please execute the following steps:
1. Add a tempfile to the TEMP tablespace

2. Run autoconfig