Oracle Server - Enterprise Edition - Version: 9.2.0.3
This problem can occur on any platform.
Errors
ORA 1092 Oracle instance terminated.
Symptoms
ORA-01092: ORACLE INSTANCE TERMINATED. DISCONNECTION FORCED
ORA-1534 shown in trace file- Rollback Segment RBS01 cannot be found
Cause
In database creation script, "rbs01" was used to create RS,so it creates RS as rbs01(case sensitive)
In init.ora,rollback_segments=(rbs01,......) was used.By default the database takes it as RBS01(in caps).
So,while opening the database RBS01 cannot be found,because it was created as rbs01.
Fix
1.Open the DB by commenting the rollback_segments parameter in init.ora
2.Re-create all the RS ,brought them online.(Taking care the " " are not used).
3.Shutdown the DB,removed the comment in init.ora
4.Start the DB with all the Rollback Segments Online.
Partager