This content has been marked as final. Show 4 replies
You need to look for an Oracle specific error code and message. The error text you have posted does not seem to be an Oracle error.
The error however could result from an ORA-3113 end-of-file on communication channel.
This Oracle error means that the Oracle server process servicing your request (executing SQL or PL/SQL code) ran into a fatal error (potentially an Oracle bug). The server process then proceeds with a "crash dump" - writes an error to the database instance's alert log, writes a trace file and then terminiates abnormally.
It terminates without telling the client and without tearing down the tcp client-server connection. When the client then attempts to use this connection, the socket read fails. No data to read as the socket connection no longer exists.
But this is speculation - we need to see the actual Oracle error (from the server or from the client driver). And you seem to be using an Oracle client that suppresses Oracle error codes and text. Which places a serious question mark over the actual usability of such client s/w for Oracle client-server.
Anupam_Halder wrote:Ask your DBA to check if you have a matching entry in the alert log. Something like an ora-600 error. Sometimes this is the cause for a connection lost issue. This might need a later call to oracle support.
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 18351
Session ID: 834 Serial number: 4869