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

12 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