ORA-12520: TNS:listener could not find available handler for requested
- Article Type: General
- Product: Aleph
- Product Version: 20, 21, 22, 23
Description:
We are running p_manage_01 on our Production database.
We find that the $data_scratch/p_manage_01_a_1 - p_manage_01_a_6 processes are processing normally, but p_manage_01_a_7 and p_manage_01_a_8 are just going rapidly on to the next cycle. (This can be seen in the p_manage_01_a.cycles file.)
The fcl03 $data_scratch/p_manage_01_a_7.log and p_manage_01_a_8.log's -- which are much bigger than the 1-6 logs -- have errors like this:
Oracle error: handle_connection
ORA-12520: TNS:listener could not find available handler for requested type of server
^[[2J^[[H^[[0m
{Note: It sometimes appears in the truncated form:
ORA-12520: TNS:listener could not find available handler for requested }
Resolution:
It was determined that Oracle was hitting a max-process limit of 150.
The immediate solution was to stop/restart Aleph and Oracle.
The maximum number of Oracle processes is set in the $ORACLE_HOME/dbs/init<$ORACLE_SID>.ora file. (For example, "initaleph0.ora")
I find this in the $ORACLE_HOME/dbs/initaleph0.ora for the old Oracle:
processes=800
while the $ORACLE_HOME/dbs/initaleph0.ora for the new Oracle has:
processes=150
This # processes needs to be increased to 400 or 800:
200 for (recommended value for a 'small' system),
400 for (recommended value for a 'medium' system).
NOTE: See the article: cir-51: "TNS:listener could not find available handler for requested type" for another, different situation.
- Article last edited: 15-May-2018