My Oracle Support Banner

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 MAY 31, 2023

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)'> <> <> <> <Test "SELECT 1 FROM DUAL" set up for pool "<pool>" 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.