Oracle listener refuses connections or unavailable

If a large number of connections (more than the value of PROCESSES) to Oracle are opened and closed within a short period of time (~10 min), the listener service might assume that the Oracle instance is unable to accept new connections and block new connections until it receives an update on load and connection status from the Oracle instance.

Symptoms

One or more of the following errors might occur:

InForm error in the Application event log:
Action: Connect to database

DSN: <pfst45>

Error: SQL Connection Error #1 State: S1000 Message: [Oracle][ODBC][Ora]ORA-12520: TNS:listener could not find available handler for requested type of server

SQL Connection Error #2 State: S1000 Message: [Oracle][ODBC][Ora]ORA-12520: TNS:listener could not find available handler for requested type of server
Error in Oracle Listener Log (default location: <oracle_home>\NETWORK\log\listener.log):
01-SEP-2009 10:24:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Trial1.world)(CID=(PROGRAM=C:\WINDOWS\system32\dllhost.exe)(HOST=RDNEPTUNQ005)(USER=PfUSR_RDNEPTUNQ005))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2046)) * establish * Trial1.world * 12520

TNS-12520: TNS:listener could not find available handler for requested type of server

Resolution

Increase the value of PROCESSES for the Oracle instance to allow room for the number of connections that will be opened/closed within a 10-minute period.

For more information about the Oracle listener and connection information, see the Oracle MetaLink article 240710.1 on the Oracle website.

Validation package

You may use the Validation Package to perform Installation Qualification (IQ), Operational Qualification (OQ), and Performance Qualification (PQ) for the User Management Interface software. It is your responsibility to request the Validation Package from Oracle, if required.