Hello Experts,
I've a java app server. Intermittently it throws the below error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
I did listener services and I see some refusal entries there. Please see below:
----
LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.129.120.152)(PORT=1521)))
Services Summary...
Service "ORA112DB" has 1 instance(s).
Instance "ORA112DB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:220702 refused:105798 state:ready
LOCAL SERVER
Service "ORA112DBXDB" has 1 instance(s).
Instance "ORA112DB", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: orcl-cust-4, pid: 20257>
(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-cust-4.bmc.com)(PORT=55666))
The command completed successfully
LSNRCTL>
----
Please help.
Many thanks!