ORA-12519 error

[fitz80]

Hi,

I am currently experiencing problems with one of our 9i database instances running on unix. Users are being kicked out of any applications running on this database for periods of up to 10 minutes with the following error:

ORA-12519: TNS:no appropriate service handler found.

Connection comes back on its own. We have looked at the database and it is fine - it seems to be a network issue.

Any input would be appreciated.

 

[karluk]

I suggest that you read Metalink note 424566.995, which was posted by a user with a similar problem. He claims that investigation showed that disconnections from Oracle were not being passed immediately to the listener. This caused the listener to (incorrectly) think that Oracle had reached its session limit. He fixed the problem by increasing the value of the "processes" startup parameter. (He says that increasing the value of the "sessions" parameter also worked.) That doesn't prevent the listener from having an incorrect count of sessions, but it does get around the ORA-12519 error.