0

OALL8 issue occurs while deploying an application on JBoss 6.1 EAP. Here is the stacktrace:

java.sql.SQLException: OALL8 is in an inconsistent state at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:199)

I am using racojdbc14.jar to connect to the oracle database.

Oracle Database: Oracle 11g. It is an RAC Cluster

Can anyone please post the solution to resolve this issue?

Draken
  • 3,134
  • 13
  • 34
  • 54
Aditya Neurgaonkar
  • 123
  • 1
  • 13
  • Try to upgrade your JDBC driver first, the fact it contains `14` in the name suggest it is a Java 1.4 driver, which means it is ancient and might have problems with newer Oracle versions. – Mark Rotteveel Mar 02 '17 at 18:41
  • Actually the issue got resolved when we restarted our setup. Thanks for your help. – Aditya Neurgaonkar Apr 25 '17 at 11:30

1 Answers1

0

Possible Solution: It is very hard to troubleshoot and the simplest solution is to upgrade your JDBC Driver. For more explanation please visit this and Oracle: OALL8 is in an inconsistent state.

Community
  • 1
  • 1
VijayD
  • 826
  • 1
  • 11
  • 33