Urgent: ORA-00600: internal error at sql statement
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Urgent: ORA-00600: internal error at sql statement

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Urgent: ORA-00600: internal error at sql statement

    Hi

    I have encountered the following errors a lot of times:

    Fri Apr 16 10:34:09 2004
    Errors in file /oracle/app/oracle/product/8.1.5/admin/ora/udump/ora_28263.trc:
    ORA-00600: internal error code, arguments: [srdmer_1], [3689525268], [2], [], [], [], [], []
    Fri Apr 16 10:34:09 2004
    Errors in file /oracle/app/oracle/product/8.1.5/admin/ora/udump/ora_28255.trc:
    ORA-00600: internal error code, arguments: [srdmer_1], [3696412692], [2], [], [], [], [], []

    I have checked the trace logs and all of them occurred at a particular sql statement. No other error message shown except for a lot of memory log. What could be wrong with it? Will it corrupt my database?

    Please help.. urgent... Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    It's a bug -- see metalink for details
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2000
    Posts
    387
    I have checked metalink, but there is not specific known bug for this? I cant find any relative documents from metalink through a search. Do you know the bug number or any metalink doc please?

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by mooks
    I have checked metalink, but there is not specific known bug for this? I cant find any relative documents from metalink through a search. Do you know the bug number or any metalink doc please?
    how could you not find the bug? I searched on srdmer_1 in metalink and the first hit on the list was your bug
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Jan 2000
    Posts
    387
    I searched using ORA-00600: internal error code, arguments: [srdmer_1]. Anyway I did another search with srdmer_1 and got it, thanks.

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by mooks
    I searched using ORA-00600: internal error code, arguments: [srdmer_1]. Anyway I did another search with srdmer_1 and got it, thanks.
    yeah my bad for being grumpy, when you get an ora-600 search on the first argument in metalink
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Metalink has a special ORA-00600 lookup function
    If you can't find a solution there, you can always log a TAR...

    Good luck!
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    . . . and for the others, if you don't find ORA-01234 (copy & paste from the error message) try ORA-1234

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