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

Issue:

Got the below error while running autoconfig on dbTier.

 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:220)
        at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:721)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:226)
        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1690)
        at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
FAILED


Solution:

The error itself tells us issue with TEMP tablespace, so just checked files or present or not, found no files.  Added a temp file and re-run the autoconfig on dbTier. 

SQL> select * from v$tempfile;

no rows selected


SQL> alter tablespace TEMP add tempfile '/data/ORCL/tem01.dbf' size 5000m;

Tablespace altered.

SQL> 

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Issue:

Got the below error while running autoconfig on AppTier.

Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END


Background of Environment:

This is a cloned environment from production.

Solution:

All entries in the FND_NODES tables belongs to prod instance, no entry for current non-prod environment. Which means clone steps did not perform completely.  Follow below steps to fix the above issue.

1) Connect to database using apps and do fnd_nodes clean up.
  
  sqlplus apps/<apps_password>
  SQL> exec fnd_conc_clone.setup_clean;

2) Run autoconfig on dbTier
3) Run autoconfig on appsTier