Wednesday, February 27, 2013

Java SQL Exception “No more data to read from socket” in Oracle

Application using JDBC 10.1.0.5 fails with below error after upgrading your database from Oracle 9i to 10g.

JDBC Version 10.1.0.5 to 11.1.0.7 are affected with this issue.

java.sql.SQLException: OALL8 is in an inconsistent state.
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.T4C8Oall.init(T4C8Oall.java:325)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:170)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
Caused by: java.sql.SQLException: No more data to read from socket at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:994)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:951)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:100)
at oracle.jdbc.driver.T4CConnection.do_rollback(T4CConnection.java:478)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1263)


Cause:- The error is due to the published Bug 5851267.

This issue is caused by constraints used by the optimizer getting attempted to be used at run time when they should not. This issue is documented in Note:463899.1

You should see the following error in the trace file during the execution of the transaction

ORA-07445: Exception aufgetreten: CORE Dump [delrefi()+34] [SIGSEGV] [Address not mapped to object] [0x8] [] []

Solution: This issue has been fixed in 11.1.0.7.

If you are running in 10g then you can apply the patch for Bug:5851267
Or

you can use the following workaround to resolve the issue.

Set database parameter "_optimizer_join_elimination_enabled" to false. By doing this you can disable the elimination transformation.

SQL> alter session set “_optimizer_join_elimination_enabled”=false;

For more information refer below metalink notes
BUG:5851267 - ORA-07445 DURING EXECUTION OF PACKAGE WHERE DELETE OCCURS
NOTE:463899.1 - ORA-7445 [Delrefi] Where Delete Occurs

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

125 comments:

  1. hi, I am a student and i need the patch for BUG:5851267 .

    ReplyDelete
    Replies
    1. IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes. IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble.Final Year Projects for CSE

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining .

      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

      The Angular Training covers a wide range of topics including Angular Directives, Angular Services, and Angular programmability.Angular Training

      Delete
  2. Thanks. This resolved the issue that i was facing!

    ReplyDelete
  3. Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai

    ReplyDelete
  4. If you are interested in developing programs across various platforms, learning java tutorials can help you do just that.programming forum

    ReplyDelete
  5. Does anybody know if this persist in 12c

    Tks in Advance

    Ccarlos

    ReplyDelete
  6. The next time I read a blog, I hope that it doesn't disappoint me just as much as this particular one. I mean, I know it was my choice to read, but I actually believed you would probably have something useful to say. All I hear is a bunch of whining about something you can fix if you were not Tech too busy searching for attention.

    ReplyDelete
  7. This website was... Web develop how do you say it? Relevant!! Finally I've found something which helped me. Many thanks!

    ReplyDelete
  8. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    Data Science Course

    ReplyDelete
  9. Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!

    Data Science Training

    ReplyDelete
  10. Salesforce ROI by hiring an expert partner for development purposes. They need to customize solutions to get them aligned with the objectives of the business. Salesforce training in Chennai

    ReplyDelete
  11. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    Artificial Intelligence Course

    ReplyDelete
  12. great java tips At SynergisticIT we offer the best java online training

    ReplyDelete
  13. I like to share my Click Here from the best and experienced AWS cognex trained and become the expert in AWS training in Chennai

    ReplyDelete
  14. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Primavera Course in Chennai | Primavera online course

    ReplyDelete
  15. Evo Syah adalah seorang Freelancer Website Developer Bali, dia sangat menyukai hobbynya dalam menelusuri setiap blok yang Anda di internet. Dia memiliki banyak pengetahuan tentang Digital Marketing dan bagaimana penerapan dalam bisnis.

    ReplyDelete
  16. I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging endeavours.
    data science course in bangalore with placement

    ReplyDelete
  17. This is an excellent post I saw thanks for sharing it. It is really what I wanted to see. I hope in the future you will continue to share such an excellent post.

    best data science institute in hyderabad

    ReplyDelete
  18. This is an excellent post I saw thanks for sharing it. It is really what I wanted to see. I hope in the future you will continue to share such an excellent post.

    best data science institute in hyderabad

    ReplyDelete
  19. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    Data Science Course in Bangalore

    ReplyDelete
  20. สหพันธ์ฟุตบอลระหว่างประเทศไฟเขียวให้ ไอเมอริค ลาปอร์ต ปราการหลังจาก สโมสรฟุตบอลแมนเชสเตอร์ ซิตี้ แห่งศึก ฟุตบอลพรีเมียร์ลีกอังกฤษ เปลี่ยนจากการเป็นตัวแทนทีมชาติ ฝรั่งเศส ไปรับใช้ทีมชาติ สเปน ได้ ทำให้เซ็นเตอร์แบ็ควัย 26 ปีจ่อลงเล่นใน ยูโร 2020 นี้กับทัพ กระทิงดุ... ufa

    ReplyDelete
  21. I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    data science course fees in bangalore

    ReplyDelete
  22. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    machine learning training in aurangabad

    ReplyDelete
  23. Baccarat is actually money making and it's remarkable accessibility. Optimal In your case it's readily available that you will find pretty fascinating choices. And that is thought to be one thing that is really different And it's very something that is really prepared to hit with Pretty much the most wonderful, as well, is actually a really positive option. Furthermore, it's a really fascinating solution. It is a better way which can make money. Superbly prepar The number of best-earning baccarat will be the accessibility of generting the most money. Pretty much as practical is very well suited for you A substitute that could be assured. To a wide range of accessibility and performance And find out outstanding results also.บาคาร่า
    ufa
    ufabet
    แทงบอล
    แทงบอล
    แทงบอล

    ReplyDelete
  24. pgslot ซึ่งเกมคาสิโนออนไลน์เกมนี้เป็นเกมที่เรียกว่าเกม สล็อตเอ็กซ์โอ คุณรู้จักเกมส์เอ็กซ์โอหรือไม่ 90% ต้องรู้จักเกมส์เอ็กซ์โออย่างแน่นอนเพราะในตอนนี้เด็กนั้นเราทุกคนมักที่จะเอาก็ได้ขึ้นมา สล็อต เล่นเกมส์เอ็กซ์โอกับเพื่อนเพื่อนแล้วคุณรู้หรือไม่ว่าในปัจจุบันนี้เกมส์เอ็กซ์โอนั้นกลายมาเป็นเกมซะลอสออนไลน์ที่ให้บริการด้วยเว็บคาสิโนออนไลน์คุณสามารถเดิมพันเกมส์เอ็กซ์โอกับเว็บคาสิโนออนไลน์ได้โดยที่จะทำให้คุณนั้นสามารถสร้างกำไรจากการเล่นเกมส์เดิมพันออนไลน์ได้เราแนะนำเกมส์ชนิดนี้ให้คุณได้รู้จักก็เพราะว่าเชื่อว่าทุก

    ReplyDelete
  25. sustainable nice blog post
    sustainable https://nonicecoproduct.com/

    ReplyDelete
  26. I read that Post and got it fine and informative. Please share more like that...
    Best Data Science courses in Hyderabad

    ReplyDelete
  27. perfumes samples nice and informative post thanks for the update
    perfumes samples https://shop.fragrancereviews.in/ nice and informative post thanks for the update

    ReplyDelete
  28. Daily news Dealy news and updates please follow us.Latest news

    ReplyDelete
  29. Digital Marketing Agency in IndiaWe are a Website Design Company and Digital marketing agency worldly known for our super creative blend in the projects that we do deliver. Internet Marketing Agency

    SEO services in IndiaIn the Website Building segment, our strategy involves blending in design and development with sustainable practice. In the end, your Business will be able to achieve digital marketing goals with long-term growth. Top SEO companies in India

    ReplyDelete
  30. I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    data science training in chennai

    ReplyDelete
  31. I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
    Data Science Course Syllabus

    ReplyDelete
  32. vehicle noc bangalore nice and informative post thanks for the update

    vehicle noc bangalore
    https://www.itzeazy.com/noc-for-car-bike-bangalore.html

    ReplyDelete
  33. Mixpoint nice blog post
    https://mixpoint.in/
    Mixpoint

    ReplyDelete
  34. I see some amazingly important and kept up to length of your strength searching for in your on the site
    data scientist course

    ReplyDelete
  35. ROC Compliance Services nice and informative post thanks for the update

    Company/ LLPs are required to furnish certain MCA forms. Our ROC Compliance Services includes all forms incl. AOC-4, MGT-7, ADT-1, and more.

    ReplyDelete
  36. Product Reviews nice and informative post thanks for the update

    Product Reviews https://marketerhunt.com/

    ReplyDelete
  37. Cordelia Cruises nice and informative post thanks for the update

    Cordelia Cruises
    https://triplou.com/cordelia-cruise/

    ReplyDelete
  38. Portable oxygen bottle Very good content and this is very helpful. Here you get the latest updates. Thank You

    ReplyDelete
  39. Your work is very good and I appreciate you and hopping for some more informative posts
    data scientist course

    ReplyDelete
  40. fragrance online with us nice and informative post thanks for the update

    ReplyDelete
  41. Lakme Academy Delhi nice and informative post thanks for the update

    ReplyDelete
  42. Closure of a Company nice and informative post thanks for the update

    ReplyDelete
  43. budget tour packages nice and informative post thanks for the update

    ReplyDelete
  44. Apart from generic Furniture Bali designs that we mass manufacture and distribute globally, we do our best to experiment with furniture designs that we either get through our commercial or hospitality customers or we simply mix-match or tinker around with some of the well-known furniture designs till we end up with some striking furniture pieces . We developed expertise in working furniture made from both metal, bamboo & wood and we began our journey as a manufacturer of industrial furniture. That’s the point where our interest piqued and we relentlessly began pursuing the holy grail of furniture manufacturing – developing expertise in intricate furniture styles like vintage furniture, art deco furniture, villa furniture, restaurant furniture, hotel contemporary, Balinese furniture, and bamboo designs.

    ReplyDelete
  45. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    data science course

    ReplyDelete
  46. Blackgoat Creative nice and informative post thanks for the update

    ReplyDelete
  47. kochi to mumbai cruise nice and informative post thanks for the update

    ReplyDelete
  48. Your writing is perfect and complete. 메리트카지노 However, I think it will be more wonderful if your post includes additional topics that I am thinking of. I have a lot of posts on my site similar to your topic. Would you like to visit once?


    ReplyDelete
  49. AOC-4 and MGT-7 form filing for Companies I read this post your post so quite an exceptionally instructive post much obliged for sharing this post, a Great article. Couldn't be composed much better! Keep it up

    ReplyDelete
  50. AOC-4 and MGT-7 form filing for Companies a Great article. Couldn't be composed much better! Keep it up

    ReplyDelete
  51. This comment has been removed by the author.

    ReplyDelete
  52. The Power of Social Media a Great article. Couldn't be composed much better! Keep it up

    ReplyDelete
  53. Hi, I am John Smith I am Web Developer, It is an amazing blog thanks for the sharing the blog. Frantic infotech provide the tablet app development such as an information about software development for costumer service. Franti infotech also provide the wearable app development. The development of advanced web applications is Orient Software’s specialty and we will successfully fulfill all your web application development requirements, from small-sized to wider-ranged projects. We Also do work multiple platforms like:
    mobile app development services
    android app development on mobile
    ios app development services
    react native app development
    ionic app development company
    flutter app development company
    angularjs web development

    ReplyDelete
  54. ITR for Salaried Individuals a Great article. Couldn't be composed much better! Keep it up

    ReplyDelete
  55. It is extremely nice to see the greatest details presented in an easy and understanding manner.
    full stack web development course in malaysia


    ReplyDelete
  56. BTMS 50 a Great article. Couldn't be composed much better! Keep it up

    ReplyDelete
  57. 360DigiTMG, the top-rated organisation among the most prestigious industries around the world, is an educational destination for those looking to pursue their dreams around the globe. The company is changing careers of many people through constant improvement, 360DigiTMG provides an outstanding learning experience and distinguishes itself from the pack. 360DigiTMG is a prominent global presence by offering world-class training. Its main office is in India and subsidiaries across Malaysia, USA, East Asia, Australia, Uk, Netherlands, and the Middle East.

    ReplyDelete
  58. Furniture stores hyderabad a Great article.Well said, your every point is true. Thanks for sharing its an informative post

    ReplyDelete
  59. Shreeja Oil Maker is a global leading manufacturer, wholesaler, supplier, exporter of various small scale machinery. Shreeja oil maker machine or Mini oil extraction machine is one of our innovative product which is able to extract 100% pure oil from the various seed. This is also known as a Oil Maker Machine or mini oil Ghani. We have a stronghold in national as well as a worldwide market.

    ReplyDelete
  60. mixpoint biography a Great article.Well said, your every point is true. Thanks for sharing its an informative post

    ReplyDelete
  61. How the Popular Beverage Brand Mad & Co Grew Its Business with PickcelWith the desire to begin an 'Air pocket Tea Insurgency,' Distraught and Co have turned into a brand for its unique Air pocket Teas. Some could say that our client is gradually refining the air pocket tea industry each delightful tea in turn.

    ReplyDelete
  62. Difference Between Cocoa Butter, Shea Butter, Kokum Butter and Mango Butter a Great article.Well said, your every point is true. Thanks for sharing its an informative post

    ReplyDelete
  63. I just got to this amazing site not long ago was actually captured with the piece of resources you have got here and big thumbs up for making such wonderful blog page!
    Data Scientist Course

    ReplyDelete
  64. Digital sign software Pickcel is a leading digital signage company with customizable and powerful software. Their solutions are perfect for businesses of all sizes, and our software can be easily integrated into existing systems. They are one of the top digital signage companies around because of the quality of our products and services of all sizes. Best digital signage software

    ReplyDelete
  65. Digital billboard software Pickcel is a leading digital signage company with customizable and powerful software. Their solutions are perfect for businesses of all sizes, and our software can be easily integrated into existing systems. They are one of the top digital signage companies around because of the quality of our products and services of all sizes. Best digital signage software

    ReplyDelete
  66. Buy High Quality SEO Links. More than 48k Websites. Single Payment for Permanent Links. Prices are below the average due to direct agreements with the sites
    https://participer.lausanne.ch/profiles/backlink-profile/activity
    https://participez.nanterre.fr/profiles/backlink-profile/activity
    https://participez.nouvelle-aquitaine.fr/profiles/backlink-profile/activity?locale=en
    https://participa.terrassa.cat/profiles/backlink-dofollow/activity
    https://participa.reus.cat/profiles/backlink-profile/activity?locale=es
    https://budget-participatif.rivp.fr/profiles/kursus-marketing/activity
    https://jeparticipe.impactons.debatpublic.fr/profiles/kursus-marketing/activity
    https://participation.bordeaux.fr/profiles/kursus-marketing/activity

    ReplyDelete
  67. a href="https://www.globalmarketestimates.com/market-report/global-payment-orchestration-market-2964">Global Payment Orchestration Market

    ReplyDelete
  68. https://www.fashionmakefashion.com/makeup-artist-course-chandigarh

    ReplyDelete
  69. Say goodbye to termites with the powerful Agenda 25 EC anti-termite chemical. Its potent formula ensures complete eradication of these destructive pests, providing long-lasting protection for your property.
    Get rid of stubborn roaches with the highly acclaimed Czar Roach Gel and Warrior Cockroach Gel. These gels are specially designed to attract and eliminate cockroaches, leaving your home roach-free.
    Protect your property from termite damage with Solignum Colourless. This reliable solution creates a barrier against termites, ensuring the structural integrity of your building for years to come.
    Transform your garden into a paradise with a visit to our comprehensive gardening & pesticide store. Explore our wide range of products, including fertilizers, pesticides, and tools, to elevate your gardening experience.
    Combat termite infestations effectively with the potent Agenda 25 EC anti-termite chemical. Its advanced formula penetrates deep into wood and soil, providing a reliable shield against these destructive pests.

    ReplyDelete