Data base is not coming up

[Former Member]

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,

Is there any standard procedure to drop and create tablespace or we can directly do the same by below SQL query.

[sivakumar_kilari3]

Did you check oracle trace files.

[Former Member]

Hello ManMohan,

you can either drop tablespace PSAPUNDO via sqlplus or use BR*tools for this.

Whatever you prefer.

Regards,

Mark