Information
The INBOUND_CONNECT_TIMEOUT_[listener-name] and SQLNET.INBOUND_CONNECT_TIMEOUT defines the limit the database listener and database server respectively will wait for a client connection to complete after a connection request is made. This limit protects the listener and database server from a Denial-of-Service attack where multiple connection requests are made that are not used or closed from a client. Server resources can be exhausted if unused connections are maintained.
Solution
Using a text editor or administrative tool, modify the listener.ora file to include a limit for connection request timeouts for the listener.
Example entry (value unit is in seconds):
INBOUND_CONNECT_TIMEOUT_LISTENER = 2
Modify the sqlnet.ora file to include a limit for connection request timeouts for the listener.
Example entry (value unit is in seconds):
SQLNET.INBOUND_CONNECT_TIMEOUT = 3
Review the Oracle Net Services Administrator's Guide for information about configuring these parameters.