ORA-600
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-600

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    OS = > SOLARIS
    DB = > 815

    SQL> ALTER TABLE trans_due
    2 ADD( tel_sec CHAR(1),
    3 avail_dt DATE DEFAULT TRUNC(SYSDATE) CONSTRAINT nnavl NOT NULL,
    4 rev_dt DATE DEFAULT TRUNC(SYSDATE) + 1 CONSTRAINT nnrev NOT NULL,
    5 last_dt DATE DEFAULT TRUNC(SYSDATE) + 2 CONSTRAINT NNlast NOT NULL);
    ALTER TABLE *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [17058], [2199000856], [], [], [], []
    , [], []

    can anyone tell me y. in my alert log it says that it encountered a deadlock....


  2. #2
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    Hi,

    ORA-600 error messages normally asks u to getin touch with the Oracle Technical Support team....Unknown Errors...!!!

    Simple way to override this would b to shutdowm abort and restart the DB...!!!

    Still working out another worth and possible solution for it....

    Just a thought...

    Kevin

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    ORA-600 error messages should not be taken lightly...

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you might be facing bug 996607 ... if you have a trigger on this table, try to drop it and test again (don't forget to be sure you can recreate the trigger after).

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    Hi, 27th sep 2001 16:57 hrs Mumbai

    The ORA-600 is an Oracle internal error and could not be pin pointed to a particular problem since there are
    many possibilities for it to occur.

    First look at the trace directories and the alert log files.

    You will find many error files along with error no ORA-600

    First try to restart the DB after a clean shutdown of the DB and restart the server itself if possible.

    If still this doesnt work out call oracle support

    They can tell which executable and line caused the crash based on your input of the error messages.

    How to locate and send the Error Mesage to Oracle......
    ----------------------------------------------------------------

    Look in to oracles bdump, udump and cdump directories.

    Look for trace files that occurred at the time of your ORA-600 error. These files can tell you more specifics of what happened so that you can send these files to Oracle Support.

    Also Look in to your alert_.ora file. There will be messages about the ORA-600 error.

    There will also be associated numbers in brackets that will tell Oracle Support what system executable has caused this
    Problem

    Normally the Errors looks likes this ORA-600 [1236] [89999] [7] [6] [] [] etc.........

    ORA-600 is nothing but error or bug which could be said as that could not be classified as another error within oracle.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pipo
    you might be facing bug 996607
    Might be, might be not :-)


  7. #7
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    yes, but it costs nothing to check if there is a trigger, to drop it and to try again ... ORA-00600 means that the error is not handled, but it can perfectly be a bug, and to be honest, I've always found solutions to ORA-00600 on metalink ...

  8. #8
    Join Date
    Feb 2001
    Posts
    82
    I had traced the error, you're right pipo it's the trigger that caused this error. when I issue the alter table and add a column with a default value oracle first add's the column and updates the existing records with the default values. my trigger fires when an update and delete occurs on that table. the triggers updates another table but unfortunately i truncate the table that the trigger updates.

    i disabled the trigger and issued the alter table command and it works.

    could that be an oracle bug?

  9. #9
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    well, you meet all requirements for bug 996607, so I think this is it, but I don't know how to be sure that this IS this bug ... well anyway, the essential is that it works

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width