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

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...