Friday, April 4, 2014

ORA-00600: internal error code, arguments: [510], [0xnnnnnnnn], [threshold alerts latch], [], []


We have found below error in alert.log for Oracle Database version 10.2.0.4

ORA-00600: internal error code, arguments: [510], [0x060030070], [threshold alerts latch], [], [], [], [], [] 

We never saw this error before and the only change that we applied on the server is OEM agent installation.

During the troubleshooting I found that these errors might occur after adding alerts for threshold values on tablespaces and faulty threshold/alert causing the MMON process to fail at the moment the thresholds were checked.

Find thresholds defined on the database
SQL>select dbms_server_alert.view_thresholds from dual;

I found many thresholds in the database and I have cleared all unnecessary thresholds. After removing the thresholds I didn’t see the error in the alert.log, it looks like the issue has been fixed.

I found that this is a known bug 5727166 and fixed in 10.2.0.5 and 11.2.0.1 and affected Oracle versions are 10.2.0.2 to 11.2.0.7 and the issue.

Hope this helps.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

20 comments:

  1. Obat Penggugur kandungan,,, Nice bag you can earn money from that
    Thanks for your posting
    Visit me @, Obat Aborsi,,
    Jual Obat Aborsi,,,

    Harga Obat Aborsi,,,

    ReplyDelete
  2. Thank you so much for the interesting article. I hope everyone will be like this. Thanks for share.
    I hope people will be like
    www xiclassadmission gov bd
    xiclassadmission
    HSC Admission Result 2018

    ReplyDelete
  3. I have read your article. it is very informative and helpful for me.I admire the valuable information you offer in your articles. Thanks for posting it, again! windows 7 product key

    ReplyDelete
  4. Calendar 2019 Printable :: Calendar 2019
    January 2019 Calendar :: January 2019 Calendar
    February 2019 Calendar :: February 2019 Calendar
    March Calendar 2019 :: March 2019 Calendar
    Tamil Calendar 2019 : Tamil Calendar 2019

    ReplyDelete
  5. Very good post, thank you. I am surprised to find your website. Because Its my first visit to your blog and i have found it so useful and informative specially this post. I have bookmarked it and I am looking forward to reading new informative post like this. Thanks for this.
    HSC Result 2018
    HSC Result 2018 BD

    ReplyDelete
  6. This is really a informative article and great read for me. It’s my first visit to your website and I have found it so useful and informative specially this article. I have bookmarked it and I am looking forward to reading new articles. Thanks for this article. Keep up the good work!! Also check Bangladesh All Education Board
    PSC Result 2018
    PSC Exam Result 2018

    ReplyDelete
  7. You'll verifiably get the best pick of fashion blogs you should seek after as shared on various online long range interpersonal communication sites. Examine a couple of posts on the blog, take a gander at the photos or plans and see whether you are astonished with all of them. See whether these posts are new or later likewise and how consistently the blogger disseminates new content. latest fashion trends

    ReplyDelete
  8. I have read your excellent post. This is a great job. I have enjoyed reading your post first time. I want to say thanks for this post. Thank you... Breaking News BD

    ReplyDelete
  9. There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job.. Giftly

    ReplyDelete
  10. I am hoping the same best effort from you in the future as well. In fact your creative writing skills has inspired me. All Bangla Newspaper List

    ReplyDelete
  11. CASA98 บริการ แทงบอลออนไลน์ แทงบอลเดี่ยว บอลเต็ง บอลสเต็ป
    casa98
    แทงบอลออนไลน์

    ReplyDelete