重庆思庄Oracle、Redhat认证学习论坛

标题: 监听日志报 TNS-12518、TNS-12547,TNS-00517和 Linux Error：32：Broken pipe [打印本页]

作者: 郑全 时间: 2020-6-12 12:43
标题: 监听日志报 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

怎么解决？

作者: 郑全 时间: 2020-6-12 12:45
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:

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)