SQL Developer No more data to read from socket

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.

1 thought on “SQL Developer No more data to read from socket

  1. Anonymous

    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.

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.