Skip to Content
author's profile photo Former Member
Former Member

Data base is not coming up

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 06:55 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 06:50 AM

    Hi,

    What is your database release ?

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 07:02 AM

    oracle 10G -10.0.2.0

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 10:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

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

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 11:46 AM

    Hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 12:32 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 12:58 PM

    Hi Mark,

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

    A Bad news again for us..

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on May 11, 2011 at 06:07 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.