I found an error that is new to me: ORA-12516 TNS:listener could not find instance with matching protocol stack
Every new remote connection into the database from GUI tools like TOAD and SQL Developer received this error. The listener was blocking connections. The problem went away on its own after the server and Oracle became less busy. The server was being slammed at the time of the errors.
(A friend of mine calls GUI tools point-click and drool environments)
After further research and a Service Request with Oracle Support, this is what I found. The error can happen when resources are low. Apparently, when resources are at a premium the listener can block new connections and return this ORA-12516. By increasing the initialization parameter PROCESSES, I hope to keep this from happening again.
Kind of a weird error and response from Oracle whenever resources are low. Oh well, strange error messages keep us gainfully employed.
See Oracle Note: 240710.1 on MetaLink for more information.
No comments:
Post a Comment