aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-12170: TNS:Connect timeout occurred

ORA-12170: TNS:Connect timeout occurred
Cause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.
Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).

请先 登录 后评论

1 个回答

小智
ORA-12170:TNS:发生连接超时,
.原因:服务器关闭,因为与客户端的连接建立或通信未能在分配的时间间隔内完成。这可能是网络或系统延迟的结果; 或者这可能指示恶意客户端正在尝试对服务器造成拒绝服务攻击。,
.操作:如果由于网络或系统较慢而出现错误,请将sqlnet.ora中的一个或所有参数SQLNET.INBOUND_CONNECT_TIMEOUT,SQLNET.SEND_TIMEOUT,SQLNET.RECV_TIMEOUT重新配置为较大的值。如果怀疑有恶意客户端,请使用sqlnet.log中的地址来标识源并限制访问。注意,记录的地址可能不可靠,因为它们可以被伪造(例如在TCP / IP中)。,
.
请先 登录 后评论