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

24 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. 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
  10. The article shares very meaningful information, at least for me. Thanks for sharing, my friend! Please visit my website hope you enjoy it. check ssc result 2020 bd marksheet

    ReplyDelete
  11. Hearing Rehab Center consists of a dedicated team of hearing rehabilitation professionals who have been engaged in providing cent percent of solutions to the masses of Pakistan for the last couple of decades.
    hearing aid Pakistan
    hearing aids in lahore
    hearing clinic in lahore
    Termite Treatment in lahore

    ReplyDelete
  12. Very good article! Your post is really helpful for me thanks for wonderful post.I am very happy to read your post..
    1. logo template website
    2. Theme Fusion
    3. logo Template

    ReplyDelete
  13. Nice blog and absolutely outstanding. You can do something much better but I still say this perfect. Keep trying for the best.
    Ordinit

    ReplyDelete
  14. At this moment I am going to do my breakfast, 스포츠토토티비 once having my breakfast coming again to read further news.

    ReplyDelete
  15. Loved this blog. Such blogs should be made more often. Huge kudos to u 스포츠토토

    ReplyDelete
  16. I would like to say “thank you” for your commitment of time and effort. You have made such a valuable impact in every aspect of our web presence 카지노사이트

    ReplyDelete
  17. loved this blog andabsolutely outstanding

    ReplyDelete
  18. Thank you so much for giving pieces of information. BD Govt Job Circular 2024

    ReplyDelete