Oracle Listener Status Locked

Question

I have a webpp that works fine under light load. However, when we start many threads each with their own connection to the database, we begin to get an error

ORA-12519: TNS:no appropriate service handler found

After searching the Internet, I found that starting up lsnrctl serviceswas a good diagnostic step, so I did it. The result of our service was

Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:130 refused:0 state:blocked
         LOCAL SERVER

The number of connections established corresponds to the number of threads. However, state:blockedit seems to be the cause and / or symptom of this problem.

So what is my next step? The maximum number of open sessions is 1024, which is more than enough, and there are no restrictions on the number of sessions for each user. I performed this test after rebooting the machine and no other programs were connected. I'm really not sure what to do next, so any help would be greatly appreciated.

EDIT: Accelerated parameters processesand sessionsshowed that this is a trick. In addition to searching for Matthew's suggestion, this letter fully described my problem.

Answer 1

You checked your alert log, it should tell you what happens if the oracle has run out of resources? It looks like you might be outside the processes,

Run in sqlplus,

SQL >

, oracle . , .

metalink, 240710.1 .