ORA-01092: ORACLE instance terminated. Disconnection forced

[Former Member]

Hello,

I am trying to upgrade from SAP 4.7/ Oracle 9 to ECC 6.0/Oracle 10g so

in the process of PRE ORACLE UPGARDE CHECK ... i got error that

Multiple Rollback Segments exist so i followed the steps of note 600141

and after that I tried to make PSAPROLL tablespace Datafile offline

using command-

SQL> alter database datafile '/oracle/DEV/sapdata2/roll_1/roll.data1'

OFFLINE;

This gave Oracle fatal error and after that there was abnormal shutdown

of Oracle. Now Oracle is not starting up and user trace is howing

msg "ORA-01545: rollback segment 'PRS_0' specified not available"

While Oracle start i get below cmd:

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 6381083200 bytes

Fixed Size 735808 bytes

Variable Size 3288334336 bytes

Database Buffers 3090677760 bytes

Redo Buffers 1335296 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

*****************************

Please HELP ME I am stuck up with upgrdataion process now how shd i

proceed.

How can i make this roll back file Online now??

Regards & Thanks,

Ankita

[Former Member · Accepted solution]

hi,

This is happening as U have put PSAPROLL Tablespace in OFFLINE Status without Activating AUM.

I think u have Not done the steps of creating UNDO Tablespace and activating AUM.

Now 1st bring all the PSAPROLL Data files online and let Oracle start, then go through the Note 600141 step-by-step.

With regards,

Samarpan

[Former Member]

Hi,

Search for entry with the string "PRS_0" and You will see some entries like the following in your init.ora file. Please uncomment like below and try restarting the database.

#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

Thanks

Nehruji