Connections Fail with Java.sql.SQLException: OALL8 Is In An Inconsistent State and java.sql.SQLRecoverableException: No more data to read from socket (Doc ID 2301162.1)

Last updated on AUGUST 25, 2017

Applies to:

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

WebLogic 10.3.3 application using JDBC 11.1.0.7 fails with exception java.sql.SQLRecoverableException: No more data to read from socket.

Data source is found in state SUSPENDED and in the application logs the following messages are reported:




#### <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <Test "SELECT 1 FROM DUAL" set up for pool "jndiSCL" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
#### <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <Test "SELECT 1 FROM DUAL" set up for pool "<pool>" failed with exception: "java.sql.SQLException: OALL8 is in an inconsistent state".>



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms