When using two JDBC connections accessing the same Oracle database, “SqlException : No more data to read from socket” thrown.
This is because your database doesn’t support connection sharing, or it’s a dedicated server that will not respond to different clients.
Solution 1:
- $ dbca
- –Configuration & Migration Tool
- —-database Configuration Assistant
- Select radio button —Configure Data base options in database
- Select your database—e.g. Oracle or pspl
- Select —– shared server mode
Solution 2 (same to 1 but manual work):
- open $ORACLE_HOME/network/admin/tnsnames.ora
- change “(SERVER = DEDICATED)” to “(SERVER = SHARED)”
- restart database and listener
Now your database is sharable, so we can use from different client.
Thank you so much. This is helpful
I am Getting the same error while i am connecting to Oracle 10g database from my Client machine and executing SQL Query through PL/SQL Developer Tool.
I have tried executing the same Query through SQL*Plus and Toad also. The same error i am getting.
I have browsed through Google for the Resolution, bit most of the sites says that, the error is due ti JDBC Client.
Any Suggestions.
Raja