Question Re: Data base is not coming up in Technology Q&A

Data base is not coming up

Former Member — Thu, 05 May 2011 06:47:27 GMT

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-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], [], [], [],

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 06:50:54 GMT

Hi,

What is your database release ?

Thanks

Sunny

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 06:55:11 GMT

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

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 07:02:51 GMT

oracle 10G -10.0.2.0

Re: Data base is not coming up

sivakumar_kilari3 — Thu, 05 May 2011 07:28:12 GMT

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

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 10:31:57 GMT

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

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 11:07:18 GMT

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)

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 11:46:13 GMT

Hi,

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

Re: Data base is not coming up

sivakumar_kilari3 — Thu, 05 May 2011 11:53:19 GMT

Did you check oracle trace files.

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 12:24:16 GMT

Hello ManMohan,

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

Whatever you prefer.

Regards,

Mark

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 12:32:23 GMT

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#"

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 12:44:29 GMT

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

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 12:58:12 GMT

Hi Mark,

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

A Bad news again for us..

Re: Data base is not coming up

Former Member — Thu, 05 May 2011 14:12:01 GMT

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

Re: Data base is not coming up

Former Member — Wed, 11 May 2011 06:07:54 GMT

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