Database Networking (MOSC)

MOSC Banner

ORA-12516, TNS:listener could not find available handler with matching protocol stack

edited Jan 12, 2018 2:22AM in Database Networking (MOSC) 5 commentsAnswered

Hello All,

On one of our Prod server application team while trying to coonect got below error:

 

ORA-12516, TNS:listener could not find available handler with matching protocol stack

The issue was resolved on its own after some time. So it looks we reached threshold on sessions OR processes limit and once the count went down issue was resolved.

Now the catch here is we do not see this error captured in the alert logs.

Is there a way I can check on the max. numbers of sessions or processes that we hit during the time the issue was reported?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center