Data base is not coming up

[#1]

Hi,

1. SAP is on windows server 2003

2. Databse is Oracle

3. System crashed and we have do the complete recover.

4. Recovery is successfully completed but data base is not opening

Alert file logs

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [4193], [6003], [6028], [], [], [], [], []

ORA-00600: internal error code, arguments: [4193], [6003], [6028], [], [], [], [], []

ORA-00607: Internal error occurred while making a change to a data block

SQL> startup

ORACLE instance started.

Total System Global Area 1476395008 bytes

Fixed Size 2064248 bytes

Variable Size 640417928 bytes

Database Buffers 819200000 bytes

Redo Buffers 14712832 bytes

Database mounted.

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [7269], [3890], [], [], [],

[Former Member]

I have tried to change the UNDO_MANAGEMENT to MANUAL and databse and SAP application is up

But after changing back to AUTO- Database is again down

[Former Member]

Hello ManMohan,

it is a good sign if the database opens with undo_management=manual without problems.

In manual undo mode you can drop PSAPUNDO, this will eliminate its corrupt block.

Recreate it and startup again with undo_management=auto. Then there should be

no more startup problems.

Regards,

Mark

drop tablespace psapundo;
create undo tablespace psapundo datafile '....';

(or use br*tools for this)