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
hi, I am a student and i need the patch for BUG:5851267 .
ReplyDeleteThanks. This resolved the issue that i was facing!
ReplyDeleteGreat and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
Java Articles | IT Technical Articles | Dot Net Framework Articles |
ReplyDeleteJavaScript Articles | Java Training Institutes | Single Page Application Development
Java Training in Chennai
ReplyDeleteOnline MVC Training India | Angularjs Training | javase j2ee javaee interview questions | Java Training in Chennai
Online JSF Training JSF Training Institutes in Chennai Java Training Institutes Java Training Institutes Struts2 Training Institutes in Chennai Struts2 Training Institutes in Chennai
ReplyDeleteEJB Training Institutes in Chennai EJB Training Institutes in Chennai Java EE Training Institutes in Chennai Java EE Training Institutes in Chennai Java Training in CHennai
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
ReplyDeleteARY 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
ReplyDeleteacknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.
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
ReplyDeleteacknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.
If you are interested in developing programs across various platforms, learning java tutorials can help you do just that.programming forum
ReplyDeleteDoes anybody know if this persist in 12c
ReplyDeleteTks in Advance
Ccarlos
شركة نقل عفش بخميس مشيط
ReplyDeleteشركة نقل عفش بابها
شركة نقل عفش بتبوك