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]

Hi,

I have dropped PSAPUNDO and created PSAPUNDO2

Database is up and system also

But on application I am getting error

ORA-25153: Temporary Tablespace is Empty#"

[Former Member]

Hello ManMohan,

congratulations, the database works again!

That other is just a simple problem, PSAPTEMP

has lost its tempfile. You can reregister it via:

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'C:\ORACLE\whateverpathname' REUSE SIZE x MB;

Or have a look at SAP note 600513 for more details.

Regards,

Mark