• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
Bartenders:
  • Himai Minh
  • Carey Brown
  • Frits Walraven

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

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We have the same problem, we were using oracle 9i and everyting was ok until we move to oracle 10 g. any help!!!
 
Ranch Hand
Posts: 775
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
http://www.orindasoft.com/public/PL-SQL%20Recordstwo.php4
 
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Rashid Darvesh
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
can you tell me what you have set your "cursor_sharing" system parameter to ?
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 19
jQuery Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic