Re: end-of-communication chanel

T wrote:
>
> Any idea to avoid error..???

The error is not The Error. It a symptom of The Error. So it is meaningless - it simply says that something went wrong.

The error is generated by the Oracle client driver. It is informing the client application that the communication channel (e.g. TCP socket connection) to the Oracle server has been terminated, without it receiving any notification to that effect. In socket terms, it attempted a socket call (like a write() call) only to discover that the socket is no longer connected to the server.

The server process thus terminated the connection - usually. In a very small minority of cases, this is caused by actual errors on the network (e.g. a bug that causes the FIN bit in the TCP packet to be "accidentally" set which results in the protocol stack tearing down that connection).

Why would the server process terminate the connection? Because of a fatal and unrecoverable error (such as an ORA-0600). Which means there will be (should be) errors listed in the alert log and trace files or core dumps generated.

--
Billy