Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web

Hi,

I am using Oracle 10g with WebLogic 8.1 SP3 connection pooling.
I am getting the below error.

Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state.

Please suggest a fix.

We have the same problem, we were using oracle 9i and everyting was ok until we move to oracle 10 g. any help!!!

http://www.orindasoft.com/public/PL-SQL%20Recordstwo.php4

Try the 10.2.0.1 version of ojdbc14.jar, the driver for Java 1.3 and 1.4

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

It is supposed to be cross-compatible with older versions of the database.

i downloaded the latest Oracle Database 10g Release 2 (10.2.0.1.0) JDBC Drivers (ojdbc14.jar) but still i get the error. is there some problem with the weblogic server since i updated the library in my code and the database is 10g, but looks like there needs to be something done in
weblogic to check the connection pool which i am using to create the data source. it gives me the following message.
<Feb 7, 2006 12:09:46 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "CHARGER" failed with exception: "java.sql.SQLException: OA
LL8 is in an inconsistent state.".>

Any ideas,
Rashid

can you tell me what you have set your "cursor_sharing" system parameter to ?

In general, these OALL8 errors simply indicate a mismatch between the oracle driver, the oracle database version and the JDK version. Assuming you are running Weblogic on the Java 1.4 Sun JVM supplied by the BEA Weblogic installation, you should update the Oracle driver to match the database you are using. Give this a try:

Rename the file BEA_HOME/weblogic81/server/lib/ojdbc14.jar to ojdbc14.jar.old

If you are using Oracle 9.2:
Copy BEA_HOME/weblogic81/server/ext/jdbc/oracle/920/ojdbc14.jar to BEA_HOME/weblogic81/server/lib

If you are using Oracle 10g:
Copy BEA_HOME/weblogic81/server/ext/jdbc/oracle/10g/ojdbc14.jar to BEA_HOME/weblogic81/server/lib

Restart the Weblogic server.

If the problem still persists, you may want to download the latest Oracle 10.2 ojdbc14.jar driver jar from Oracle at: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

This has fixed the problem every time we have seen it at customer sites.

I've just solved this issue thanks to another post...

This problem is a result of 'stale' connections that generates an error when the application tries to retrieve an invalid connection from the pool. You can simply solve this by change the resource setup in your context.xml:

Don't forget to specify a valid validation query.