11gR2 Listener With RATE_LIMIT Set: Slow Connect Time and Tnsping Response Time High with TNS-1158 Error
Last updated on MAY 02, 2017
Applies to:Oracle Net Services - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Information in this document applies to any platform.
Incoming connections take a long time to establish. Also tnsping report high response times without any network delay (normal ping times for that network).
Restarting the listener solve the issue temporarily but it will appear later on again.
The listener is using RATE_LIMIT for a TCP endpoint and this limit is often enforced. In other words, the TNS-1158 error is frequently thrown in the listener log due to the high number of incoming connections and the threshold for RATE_LIMIT being reached.
This behavior would be exhibited with either of the following listener.ora file configurations:
Again, the TNS-1158 message is frequently thrown in the listener.log because the limit has been reached and connections are being rejected.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms