Encountering ORA-01555: snapshot too old... When Launching the OpenPages OPBackup Utility

Technote (FAQ)


Question

When an OpenPages administrator is attempting to run an OPBackup, the utility is failing with oracle errors stating: "ORA-01555: snapshot too old: rollback segment number 8 with name '_SYSSMU8$' too small

Cause

The OPBackup utility is failing with errors such as:

     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table     RT__SUBMANDATE_REQUIREMENT
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table            RT__SUBMANDATE_RISK
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table         RT__SUBMANDATE_SIGNOFF
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table      RT__SUBMANDATE_SUBMANDATE
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table         RT__SUBPROCESS_ACCOUNT
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table      RT__SUBPROCESS_ACTIONPLAN
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table RT__SUBPROCESS_CONTROLOBJECTIV
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table            RT__SUBPROCESS_FILE
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table           RT__SUBPROCESS_ISSUE
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table            RT__SUBPROCESS_LINK
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table         RT__SUBPROCESS_MANDATE
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table            RT__SUBPROCESS_RISK
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
     [exec] . . exporting table         RT__SUBPROCESS_SERVICE
     [exec] EXP-00008: ORACLE error 1555 encountered
     [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small

Answer

The Oracle DBA needs to review the database instance to determine why the oracle errors are being generated. Once the DBA has made the appropriate changes, the OpenPages administrator should then try to launch the OPBackup utility again.

Related information

ORA-12518 or TNS-12518 occurs when importing openpages.
OPBackup is Failing with Oracle Error Messages (ORA-316
OPBackup error ORA-00904 - EXP-00056: ORACLE error 904
OPBackup fails in 5.1 environment
OPBackup fails to backup database
OPBACKUP/OPRESTORE not working after performing 5.5.0.2
OPBackup is Failing with an "EXP-00003: no storage defi

Rate this page:

(0 users)Average rating

Document information


More support for:

OpenPages GRC Platform

Software version:

5.5, 5.5.2, 5.5.3, 6.0, 6.0.1, 6.1, 6.2, 6.2.1

Operating system(s):

Platform Independent

Reference #:

1649073

Modified date:

2013-09-05

Translate my page

Machine Translation

Content navigation