Oracle 12c - getting SQL Error: 17410, SQLState: 08000
<p>I am working on the project which used ORACLE 12c db as back-end. and My application is build in java 8. It was working fine since last few month. But suddenly client got an error </p>

<pre><code>SQL Error: 17410, SQLState: 08000
No more data to read from socket. 
</code></pre>

<p>I searched about the issue, so I found the following solutions related to the 11g not for 12c...</p>

<p>Case 1: <strong>When using two JDBC connections accessing the same Oracle database, “SqlException : No more data to read from socket” thrown.</strong></p>

<p>This is  because your database doesn’t support connection sharing, or it’s a dedicated server that will not respond to different clients.</p>

<p><strong>Solution:</strong> (same to 1 but manual work):</p>

<pre><code>open $ORACLE_HOME/network/admin/tnsnames.ora
change “(SERVER = DEDICATED)” to “(SERVER = SHARED)”
restart database and listener
</code></pre>

<p><strong>BUT I am not running two jdbc connections.</strong></p>

<p>Case 2: <strong>If you are using java this might helo you:</strong>
java/jdk1.6.0_31/jre/lib/security/java.security
change
securerandom.source=file:/dev/urandom
to
securerandom.source=file:///dev/urandom</p>

<p>Anyone can give the correct reason of this issue and which solution will be best to resolve the issue, so that in future we will not get this again.</p>

<p><strong>Update</strong>: I have two separate application that deal with same db. One is a service that create pending items to be process and saving in DB and client is pick the pending item from db and process it. and both runs in separate JVM. </p>