Database Administration (MOSC)

MOSC Banner

db can not start up , ora -1558 out of transaction ID's in rollback segment %s

edited Jul 5, 2021 2:55AM in Database Administration (MOSC) 6 commentsAnswered

SMON: following errors trapped and ignored:

ORA-01595: error freeing extent (12) of rollback segment (10)

ORA-01558: out of transaction ID's in rollback segment _SYSSMU10_2112763080$

[oracle@oak1 ~]$ oerr ora 1558

01558, 00000, "out of transaction ID's in rollback segment %s"

// *Cause: All the available transaction id's have been used

// *Action: Shutdown the instance and restart using other rollback segment(s),

//     then drop the rollback segment that has no more transaction id's.


how can i start up the instance?

db version 12.2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center