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.

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 )

Google photo

You are commenting using your Google 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.