Wednesday 24 January 2018

ORA-00959: tablespace 'TEMP' does not exist has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.

Error:-

While running adcfgclone on appsTier getting below error,
ORA-00959: tablespace 'TEMP' does not exist has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.

Cause:

AutoConfig was not ran after recreating Temp tablespace.

Adpatch log Error:-

Log file located at /app_cmsdev/cmsapp/inst/CMSDEV_cmsdevap/admin/log/ApplyAppsTier_01240743.log
  - 50% completed ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -959: ORA-00959: tablespace 'TEMP' does not exist 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 -959: ORA-00959: tablespace 'TEMP' does not exist 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.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Thread.java:735)
  \ 90% completed


ERROR while running Apply...
Wed Jan 24 07:52:34 2018

 ERROR: Failed to execute /app_cmsdev/cmsapp/apps_st/comn/clone/bin/adclone.pl

-----------------------------------------------------
/app_cmsdev/cmsapp/inst/CMSDEV_cmsdevap/admin/log/ApplyAppsTier_01240743.log

Autoconfig log Error:-

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /app_cmsdev/cmsapp/inst/CMSDEV_cmsdevap/admin/install
      afcpctx.sh              INSTE8_PRF         1


Solution:-

1) Run autoconfig on database tier which links the recent Temp tablespace on the database.

2) Re-run adcfgclone on appsTier.

Hope this helps you !!!  

No comments:

Post a Comment