SQL Developer No more data to read from socket
When tried to executed the SQL script form the Oracle SQL Developer.
Error from SQL Developer
Getting the following message:
No more data to read from socket
Error from SQLPLUS
When tried to execute the same query from SQLPLUS then get the error:
SELECT count(*)
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7740
Session ID: 203 Serial number: 43145
ERROR:
ORA-03114: not connected to ORACLE
Solution
This error indicates that connection is break or abort.
First check the alert and listener log file for it.
it seems to be a generic communications error, often as the result of a TNS connectivity issue.
When we tried with using the Oracle 11g version, Then we got the error. May be any bug fixes.
But when i tried the same query on Oracle 12c SQLPLUS then its working fine.
Smart way of Technology 
If you are joining CTE and if same value you r showing in two columns then you might face this problem. so do not use same value in 2 column in cte becsz oracle doesnt hv control on CTE becz it is memory based not table.
LikeLike