监听日志报 TNS-12518、TNS-12547,TNS-00517和 Linux Error：32：Broken pipe

郑全

如题，
在客户端不停的报：ORA-12537,

在服务器监听日志中，报：

TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
   TNS-12560: TNS:protocol adapter error
     TNS-00517: Lost contact
       Linux Error: 32: Broken pipe

怎么解决？

郑全

ORACLE MOS上文档 ID 550859.1  有这个解释，可以参考一下 ：

Cause:
The error 32 indicates the communication has been broken while the listener is trying to hand off the client connection to the server process or dispatcher process.

Action:
1.  One of reason would be processes parameter being low, and can be verified by the v$resource_limit view.
2. In Shared Server mode, check the 'lsnrctl services' output and see if the dispatcher has refused any connections, if so, then consider increasing the number of dispatchers.
3. Check the alert log for any possible errors.
4. Memory resource is also another cause for this issue. Check the swap, memory usage of the OS.
5. If RAC/SCAN or listener is running in separate home, check the following note: