-
제목
"No more data to read from socket" in Oracle agent log -
설명
"No more data to read from socket" in Oracle agent log
"Caused by: java.sql.SQLRecoverableException: No more data to read from socket"
-
원인
"no more data read from socket" means that the shadow process that your TCP connection was connected to was abruptly terminated, not even allowing an error message to be sent to your client on your next call. Bascially the Oracle server rudely disconnected your application connection while it was reading some sort of resultset. This is not a JDBC or an Oracle error. Rather, it is a generic communications error, often as the result of a TNS connectivity issue. This is usually being caused by an ORA-0600 (internal error) or ORA-7445.
-
해결 방안
The first step in resolving this error is to look for a trace file in the user_dump_dest directory and/or an entry in the alert log. Ask the DBA to if the user doesn't have access. Presumably it's a bug, but the real underlying error will let you check that with Oracle Support. After you find the specific error message and details, we can go to support.oracle.com. Use the "ora-600 tool" and then lookup the first number after the ORA-600 message.
select value from v$parameter where name = 'background_dump_dest'; will give the location of the log.
There could be another root cause, such as a firewall timeout cutting the connection or another common reason for these errors is a network disconnection caused by SQLNET.EXPIRE_TIME or some other process that kills old sessions.