Re: Intermittent ORA-12516 ( TNS:listener could not find available handler with matching protocol stack)
- From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
- To: frasebook4@xxxxxxxxx
- Date: Sat, 5 Jul 2014 09:04:22 -0400
Hello Nico,
Do you have the local_listener value set already, if not, could you
please set it and retry and let us know if the error goes away.
Thanks,
Rajeev
On Fri, Jul 4, 2014 at 11: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:
