GUI is unresponsive, logs show 'Connections exceeded limit of 50' errors

Document ID : KB000090217
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
GUI is unresponsive, logs show 'Connections exceeded limit of 50' errors
Resolution:

Symptoms

In most cases the GUI is unresponsive and the RmiServer log files contain error messages like this:


Connections exceeded limit of 50 jdbc:oracle:thin:@xxx.xx.xx.xxx:1521:appmgrdg:AM_PROD

.....


Cause

The maximum number of connections to the database is exceeded.


Resolution

Applications Manager uses a connection pooling for the JDBC connections to the database. Normally as connections are no longer used, they are removed from the pool.

You can increase the number of connections by adding the following line in the Options.properties file (default setting is 50). The example shown below increases the number to 75:

MaxPooledConnections=75

Afterwards stop and restart the RmiServer:
>stopso rmiserver>startso rmiserver
Additionally, you can have your DBA check and eventually change a setting on the oracle database:

You can increase the number of processes allowed in Oracle by modifying the init.ora file usually located in $ORACLE_HOME/dbs directory. A sample code is shown below:

$ORACLE_HOME/dbs/init$ORACLE_SID.ora
# processes=50
# SMALL
processes=150
# MEDIUM
#processes=200
# LARGE