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

174 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. ARY News is a wonderful channel always disclose the govt sectors scams without any fear. There are Many channels are in Pakistan but only few are working in right and exact ways. Let's watch ARY News Live channel and
    acknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.

    ReplyDelete
  5. ARY News is a wonderful channel always disclose the govt sectors scams without any fear. There are Many channels are in Pakistan but only few are working in right and exact ways. Let's watch ARY News Live channel and
    acknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.

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

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

    Tks in Advance

    Ccarlos

    ReplyDelete
  8. 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
  9. This website was... Web develop how do you say it? Relevant!! Finally I've found something which helped me. Many thanks!

    ReplyDelete
  10. 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
  11. 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
  12. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    Data Science Institute in Bangalore

    ReplyDelete
  13. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    Data Science Certification in Bangalore

    ReplyDelete
  14. 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
  15. 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
  16. great java tips At SynergisticIT we offer the best java online training

    ReplyDelete
  17. Tally Solutions Pvt. Ltd., is an Indian multinational company that provides enterprise resource planning software. It is headquartered in Bengaluru, Karnataka India.
    tally training in chennai

    hadoop training in chennai

    sap training in chennai

    oracle training in chennai

    angular js training in chennai

    ReplyDelete
  18. 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
  19. Dr. Vivek Galani is a leading expert in skin and hair. At hair transplant clinic in Surat Skin Care, Cosmetic Laser, Hair Transplant & Slimming Center, Dr. Galani offers the most advanced cosmetic and dermatologic care treatments. The clinic uses advanced FUE methods to produce high-quality hair transplants.

    ReplyDelete
  20. 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
  21. 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
  22. 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.
    cyber security training in bangalore

    ReplyDelete
  23. I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
    data analytics training in bangalore

    ReplyDelete
  24. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    data analytics course in bangalore

    ReplyDelete
  25. 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
  26. 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
  27. 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
  28. 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
  29. อีกทั้งเรายังให้บริการ เกมสล็อต ยิงปลา แทงบอลออนไลน์ รองรับทุกการใช้งานในอุปกรณ์ต่าง ๆ HTML5 คอมพิวเตอร์ แท็บเล็ต สมาทโฟน คาสิโนออนไลน์ และมือถือทุกรุ่น เล่นได้ตลอด 24ชม. ไม่ต้อง Downloads เกมส์ให้ยุ่งยาก ด้วยระบบที่เสถียรที่สุดในประเทศไทย

    ReplyDelete
  30. หาคุณกำลังหาเกมส์ออนไลน์ที่สามารถสร้างรายได้ให้กับคุณ เรามีเกมส์แนะนำ เกมยิงปลา รูปแบบใหม่เล่นง่ายบนมือถือ คาสิโนออนไลน์ บนคอม เล่นได้ทุกอุปกรณ์รองรับทุกเครื่องมือ มีให้เลือกเล่นหลายเกมส์ เล่นได้ทั่วโลกเพราะนี้คือเกมส์ออนไลน์แบบใหม่ เกมยิงปลา

    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.
    cyber security training in bangalore

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

    ReplyDelete
  33. 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
  34. 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
  35. 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
  36. pgslot ซึ่งเกมคาสิโนออนไลน์เกมนี้เป็นเกมที่เรียกว่าเกม สล็อตเอ็กซ์โอ คุณรู้จักเกมส์เอ็กซ์โอหรือไม่ 90% ต้องรู้จักเกมส์เอ็กซ์โออย่างแน่นอนเพราะในตอนนี้เด็กนั้นเราทุกคนมักที่จะเอาก็ได้ขึ้นมา สล็อต เล่นเกมส์เอ็กซ์โอกับเพื่อนเพื่อนแล้วคุณรู้หรือไม่ว่าในปัจจุบันนี้เกมส์เอ็กซ์โอนั้นกลายมาเป็นเกมซะลอสออนไลน์ที่ให้บริการด้วยเว็บคาสิโนออนไลน์คุณสามารถเดิมพันเกมส์เอ็กซ์โอกับเว็บคาสิโนออนไลน์ได้โดยที่จะทำให้คุณนั้นสามารถสร้างกำไรจากการเล่นเกมส์เดิมพันออนไลน์ได้เราแนะนำเกมส์ชนิดนี้ให้คุณได้รู้จักก็เพราะว่าเชื่อว่าทุก

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

    ReplyDelete
  38. 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 Training in Chennai

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

    ReplyDelete
  40. 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
  41. Daily news Dealy news and updates please follow us.Latest news

    ReplyDelete
  42. 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
  43. Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

    data science course in faridabad

    ReplyDelete
  44. 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
  45. Thanks for posting the best information and the blog is very important.data science course in Lucknow

    ReplyDelete
  46. 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
  47. 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
  48. Mixpoint nice blog post
    https://mixpoint.in/
    Mixpoint

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

    ReplyDelete
  50. This is the best blog post I have read till date. I'm glad to be here.
    Best Mobile App development company in Hyderabad

    ReplyDelete
  51. 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
  52. Product Reviews nice and informative post thanks for the update

    Product Reviews https://marketerhunt.com/

    ReplyDelete
  53. Bank PO coaching in jaipur nice and informative post thanks for the update

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

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

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

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

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

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

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

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

    ReplyDelete
  61. 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
  62. 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
  63. Blackgoat Creative nice and informative post thanks for the update

    ReplyDelete
  64. Thanks for posting the best information and the blog is very good.Cloud Computing course in Bangalore

    ReplyDelete
  65. Extraordinary post I should state and a debt of gratitude is in order for the data. Instruction is unquestionably a clingy subject. Be that as it may, is still among the main subjects within recent memory. I value your post and anticipate more.data science training in lucknow

    ReplyDelete
  66. Your Professional Agency nice and informative post thanks for the update

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

    ReplyDelete
  68. Check ingredients in cosmetics Very good site. Here you will get latest product

    ReplyDelete
  69. AOC-4 and MGT-7 form filing for Companies ROC Annual LLP compliances include filing of Annual Returns Form8, Form11, and Filing of DIR-3 KYC form. Call/ Whatsapp @ 76790 91881

    ReplyDelete
  70. 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
  71. thanks for sharing nice blog https://duckcreektraining.com/

    ReplyDelete
  72. 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
  73. AOC-4 and MGT-7 form filing for Companies a Great article. Couldn't be composed much better! Keep it up

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

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

    ReplyDelete
  76. 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
  77. Excellent effort to make this blog more wonderful and attractive.
    cyber security training malaysia

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

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


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

    ReplyDelete
  81. 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
  82. 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.
    business analytics course in gwalior

    ReplyDelete
  83. Candela GentleLASE medical grade laser applies precise, controlled pulses of laser. Auckland Laser Hair Removal energy that reach down the hair shaft into the follicle underneath the skin, cauterizing the hair at its root. the encompassing tissue or skin isn’t damaged. The laser’s gentle beam of sunshine damages and consequently prevents the follicle from growing.

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

    ReplyDelete
  85. 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
  86. Through this post, I realize that your great information in playing with all the pieces was exceptionally useful. I advise this is the primary spot where I discover issues I've been scanning for. You have a smart yet alluring method of composing.https://360digitmg.com/course/certification-program-on-digital-marketing

    ReplyDelete
  87. FAB VOGUE STUDIO provide all kind of Fabric which can be use for Making any designer apparel. Kora Silk Fabric We guarantee you’ll love working with us. Design Customization Available. Wholesale price available on request. Quality Assurance. COD Available.

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

    ReplyDelete
  89. 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
  90. 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
  91. RQC is one of the Best Best Hair Clinic In Surat, with services, including Hair Transplant, Hair Treatment, Hairfall and Hair Loss, dermatology. RQC brings you the best services in hair transplant, Hair Treatment.

    ReplyDelete
  92. 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
  93. 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
  94. 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
  95. 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
  96. a href="https://www.globalmarketestimates.com/market-report/global-payment-orchestration-market-2964">Global Payment Orchestration Market

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

    ReplyDelete