Re: Intermittent ORA-12516 ( TNS:listener could not find available handler with matching protocol stack)

  • From: David Barbour <david.barbour1@xxxxxxxxx>
  • To: frasebook4@xxxxxxxxx
  • Date: Mon, 7 Jul 2014 14:42:33 -0500

What is the operating system?


On Fri, Jul 4, 2014 at 10:07 AM, nico torres <frasebook4@xxxxxxxxx> wrote:

> Hi guys,
>
> JDBC Connections to my 11.2.0.4 Database are getting this error quite
> intermittently:
>
> TNS-12516: TNS:listener could not find available handler with matching
> protocol stack
>
>  I am asking you because I researched quite a lot about this error, and
> all solutions say this is a number of processes/sessions, but this is not
> the case, since sessions/processes number is quite low, and far from the
> maximum.
>
> I searched in the listener.log, and only found "Warning: Subscription For
> Node Down Event Still Pending" warnings, and solved them
> setting SUBSCRIBE_FOR_NODE_DOWN_EVENT=OFF, but it had nothing to do with
> the error, because it keeps showing up.
>
> Couldn't find any more information on the listener.log, only the same
> errors JDBC connections are getting (TNS-12516: TNS:listener could not find
> available handler with matching protocol stack)
>
> Any ideas?
>
> Thanks a lot.
>

Other related posts: