Monday, February 10, 2020

ORA-00600, ORA-07445 and ORA-00020 errors and related bugs in 12c (12.2.0.1)


I have come across below error recently in 12c (12.2.0.1). It first started with ORA-00600 followed by ORA-07445 and ORA-00020. The ORA-00600, ORA-07445 looks like real culprit and which lead to ORA-00020 error.

ORA-00600: internal error code, arguments: [17126], [0x0B0D29528], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-01-13T23:20:30.493308-08:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x32000000170] [PC:0x10F9D3FD, kghfnd_in_free_lists()+717] [flags: 0x0, count: 1]
Errors in file /home/oracle/diag/rdbms/ORADB/ORADB/trace/ORADB_ora_62437.trc (incident=41538):
ORA-07445: exception encountered: core dump [kghfnd_in_free_lists()+717] [SIGSEGV] [ADDR:0x32000000170] [PC:0x10F9D3FD] [Address not mapped to object] []
Incident details in: /home/oracle/diag/rdbms/ORADB/ORADB/incident/incdir_41538/ORADB_ora_62437_i41538.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-01-13T23:20:31.182120-08:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-01-13T23:20:31.182223-08:00
opidcl aborting process unknown ospid (48392) as a result of ORA-600
……

2020-01-14T01:29:37.222083-08:00
ORA-00020: maximum number of processes (500) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.

After investigation and troubleshooting I found below bugs

1. There is a unpublished bug related to Unified memory KGH related crashes/errors. After discussing with support come to know that particular fix was found on an internal note to already be included in Oracle 12.2.0.1

Bug 30053838
 - LNX-20-ATP: HIT ORA-7445 [KGHFND_IN_FREE_LISTS] AND ORA-600 [KSM_PGA_UM_EXT_FREE:INVALID_EXT_MAGIC], INST CRASH

2. There is a published bug 24596874 and the fix fix for 24596874 is first included in 20.1.0 . Also in term patches may be available for earlier versions.

For bug 24596874 , users notice Memory corruption when CDB environment is setup with star schema on one PDB. Redaction policies enabled on tables/view of the schema and query workload executed with 50 concurrent sessions. Multiple ORA 600 [kghfrh:ds] were seen in the alert log.

So both of the above bugs are ruled out as unpublished bug already part of 12.2.0.1 and published bug is related to Star schema on PDB.

After further investigation with Oracle support found another unpublished Bug 30448845 : DATABASE HANG WITH SIGNATURE: 'PMON TIMER'<='PRIOR SPAWNER CLEAN UP'<='LATCH FREE'<='RELIABLE MESSAGE'

As per Oracle support, this is fixed in 18.1 but the fix is not easy to backports. Oracle suggest to update parameter _pmon_slaves_arr_size=0 as workaround in Oracle 12.2

Users cannot update internal oracle parameters directly in SPFILE, please follow the steps mentioned in the below blog post
https://www.oracleracexpert.com/2020/01/ora-00800-soft-external-error-arguments.html

Note that every environment, errors, load, use cases are different, I would highly recommend users to open a ticket with Oracle support and get confirmation before making any changes to your databases.
Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com 

27 comments:

  1. Thanks for sharing such a informative blog with us. Keep on sharing
    Azure Training In Hyderabad

    ReplyDelete
  2. Expected to form you an almost no word to thank you once more with respect to the decent recommendations you've contributed here.
    Machine Learning Training In Hyderabad

    ReplyDelete
  3. Really i found this article more informative, thanks for sharing this article! Keep posting..

    Big Data Analytics Training in Hyderabad

    Hadoop Training in Hyderabad

    ReplyDelete
  4. Thanks for the lovely blog. It helped me a lot. I'm glad I found this blog. Thanks for sharing with us, I too am always learning something new from your post.

    360DigiTMG Data Science Courses

    ReplyDelete
  5. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.data science training in Hyderabad

    ReplyDelete
  6. I really appreciate the writer's choice for choosing this excellent article information shared was valuable thanks for sharing.
    Data Science Training in Hyderabad

    ReplyDelete
  7. Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too.

    Web Design Gloucester
    Web Design Cheltenham
    SEO Gloucester

    ReplyDelete
  8. Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one. Keep posting. An obligation of appreciation is all together for sharing.data science training in kolhapur

    ReplyDelete
  9. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.digital marketing course In Hyderabad

    ReplyDelete
  10. Informative and knowledgeable content, big thumbs up for your article. Keep sharing more stuff like this. Thank you.
    Data Science Course Training in Hyderabad
    Data Science Course Training Institute in Hyderabad

    ReplyDelete
  11. Very Awesome!!! When I Seek For This I Found This Website At The Top Of All Blogs In Search Engine. Data Analytics Course In Vadodara

    ReplyDelete
  12. I feel extremely appreciative that I read this. It is extremely useful and exceptionally enlightening and I truly took in a ton from it.
    business analytics course in hyderabad

    ReplyDelete
  13. I See The Greatest Contents On Your Blog And I Extremely Love Reading Them. Data Scientist Course In Dombivli

    ReplyDelete
  14. Thanks for sharing this great article we appreciate it, we provide instagram reels download freely and unlimited.

    ReplyDelete
  15. data science training institute in Chennai
    Good to become visiting your weblog again, it has been months for me. Nicely this article that i've been waited for so long. I will need this post to total my assignment in the college, and it has exact same topic together with your write-up. Thanks, good share. . data science training institute in chennai

    ReplyDelete
  16. Data is generated by you, like the pages you search and the time you spend on particular sites.

    ReplyDelete
  17. UP Intermediate 10+2 Syllabus 2023 will be announced at the UP examination board by its website “upresults.nic.in”. The given website is the direct link for the UP 12th Boar Syllabus 2023 page. The candidates Nagaland 9th Model Paper 2023 who will appear in the UP intermediate exam will be able to fetch their Syllabus 2023 very easily from this page. It is predicted that the UP Intermediate Syllabus 2023 of Uttar Pradesh Intermediate board will announce the UP Intermediate Syllabus 2023 in the month of May, 2023. Last year it was announced in the month of May. This year also it will be announced on time.

    ReplyDelete
  18. Are you looking for a professional and experienced Piano Accompanist in sydney, Australia? We offer high-quality piano accompaniment services for all occasions. Whether you need accompaniment for a recital, audition, or performance, our team of experienced musicians can help.

    ReplyDelete
  19. Asset Plus Buyers Agents are the leading buyers advocate in Brisbane. With years of experience and a proven track record, we are dedicated to getting you the best possible price for your home. Contact us today for a free consultation to see how we can help you. Buyers Advocate Cost in Brisbane, Australia

    ReplyDelete
  20. Looking for a great Hotel in Mathura Near Railway Station? We offer clean, comfortable rooms at great prices. We're just 5 minutes from the Mathura Railway Station, making us the perfect choice for travelers. Book your room today!

    ReplyDelete
  21. Divine Interiors is your go-to destination for the best Outdoor Blinds in Melbourne, Australia. We carry a wide range of blinds to suit any taste and budget, and our team of experts are always on hand to help you find the perfect solution for your home.

    ReplyDelete