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:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7740
Session ID: 203 Serial number: 43145
ORA-03114: not connected to ORACLE
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.