关于这个报错是因为上次监听报错TNS-12637
因为在client和server涉及到这个参数,这里重点说明下
INBOUND_CONNECT_TIMEOUT_listener_name
简单的说是设置监听在特定的时间内要收到客户端请求连接的信息,这个特定时间默认为 60 seconds
Purpose
To specify the time, in seconds, for the client to complete its connect request to the listener after the network connection had been established.
If the listener does not receive the client request in the time specified, then it terminates the connection. In addition, the listener logs the IP address of the client and an
ORA-12525:
TNS: listener has not received client's request in time allowed
error message to the listener.log
file.
To protect both the listener and the database server, Oracle recommends setting this parameter in combination with the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in the sqlnet.ora
file. When specifying values for these parameters, consider the following recommendations:
-
Set both parameters to an initial low value
-
Set the value of the
INBOUND_CONNECT_TIMEOUT_
listener_name
parameter to a lower value than theSQLNET.INBOUND_CONNECT_TIMEOUT
parameter.
For example, you can set the INBOUND_CONNECT_TIMEOUT_
listener_name
parameter to 2 seconds and the INBOUND_CONNECT_TIMEOUT
parameter to 3 seconds. If clients are unable to complete connections within the specified time due to system or network delays that are normal for the particular environment, then increment the time as needed.
上面只是打个比方,实际的不要这么设置,可以参考如下,如果你的alert等频繁报相关错误的话
Sqlnet.ora: SQLNET.INBOUND_CONNECT_TIMEOUT=180
Listener.ora: INBOUND_CONNECT_TIMEOUT_listener_name=120
60 seconds
INBOUND_CONNECT_TIMEOUT_listener=2
See Also:
Oracle Database Net Services Administrator's Guide for additional information about configuring these parameters