"no more data to read from socket", oracle 11g
Every now and then we experience the following ora error
"no more data to read from socket" when trying to load a portlet. The query runs fine from oracle developer indicating that there is something between the app layer and db. Were running ppm 9.22 with Oracle 22.214.171.124.
I can provide more info when I get acces to the actual environment.
Anyone that experienced this?, maybe known by HP?
I was researching about this error messenger and I found the following information:
The error means that the Database connection is lost.
Check if the database is up and running and/or try to restart it.
Check if the connection to the database is still working.
If the same issue occurs frequently, the values of these parameters can be increased in the server.conf file:
This error indicates some problem on the Oracle side.
Ask the Database Administrator (DBA) to review Oracle logs and check if there are any errors.
See if there are any timeouts for connections to the database server.
This Oracle error occurs when a connection that has been timed out or has been staled is used to connect to the database.
Try restarting the database and run the upgrade again.
"from my investigation, most likely this is an Oracle issue.
the exception "java.sql.SQLRecoverableException: No more data to read from socket" is what happens to the client when the DBMS has killed the session/connection out from under the driver. Please ask customer's DBA to check the DBMS error log, something bad was happening there at that moment.
Hope it helps.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
We have considered most of your tips. No success yet though!
We suspect that we might have an inappropriate version of the JDBC driver; the JDBC driver does not match the Oracle database version.
Database version is 126.96.36.199
JDBC driver version is 188.8.131.52.0
This is a recommendation from Oracle
We will try it out.
We ran into this issue with one of our users and even though this may seem silly the issue was that the user's laptop was connecting to a different WiFi which was not behind our firewall which was causing the loss of connection.
We ended up removing that network from the users profile and it solved the issue.
Thought I'd share my experience since it happened last week.
Hope it helps!
We still suffer from this problem even on Oracle 12 in test environment, have tried lots of stuff, changed MTU size in windows, jdbc drivers, etc etc, if someone have some more tip it would be nice, seems like the problem increase with load. Maybe some issue with loadbalancing and application server grabbing stale connections from pool? Have no idea...