Wednesday, April 24, 2013

Oracle error -1552: ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_TX_DATA' has been detected in FND_GSM_UTIL.upload_context_file.

Problem:
 Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1552: ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_TX_DATA' has been detected in FND_GSM_UTIL.upload_context_file.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1552: ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_TX_DATA' has been detected in FND_GSM_UTIL.upload_context_file.
        at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)
        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:1680)
        at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:755)
FAILED
COMPLETED

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

AutoConfig completed with errors.
[oraprod@bperpdb EBSPROD_bperpdb]$

Solution;
Check Database Initialization Parameters for Oracle E-Business Suite Release 12 [ID 396009.1], as mention note the recommended parater for  undo_management  is AUTO.

No comments:

Post a Comment

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...