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 · Accepted solution]

Hi,

the ORA-600 [4193] stands for a corruption in PSAPUNDO.

You can try to set undo_management=MANUAL and see

whether your database now opens. If the database opens,

set it back to undo_management=AUTO and restart.

If this did not help, you have to open a support call, they

will be able to help you.

Regards,

Mark

Edited by: Mark Foerster on May 5, 2011 9:07 AM

[Former Member]

Thanks for your support. We have opened a call with SAP .

[Former Member]

Hi Mark,

Still ORA-600 is coming.. I am not able to execute any transaction in SAP.

A Bad news again for us..

[Former Member]

Hello ManMohan,

I understood your message at 2:32 PM so that the problem is fixed.

If you dropped the old PSAPUNDO and created a new PSAPUNDO

and you still get ORA-600 with undo_management=AUTO then I

can only revert to my initial suggestion to open a SAP call.

Regards,

Mark

[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

[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

[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)

[Former Member]

oracle 10G -10.0.2.0

[sivakumar_kilari3]

Hi,

Check this note

Note 33080 - ORA 603 and ORA 376

[https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=33080]

check the space also and check oracle trace files.

Thanks

Siva

[sunny_pahuja2]

Hi,

What is your database release ?

Thanks

Sunny