Home » RDBMS Server » Server Administration » ORA-00020: maximum number of processes (150) exceeded (Oracle 9i)
ORA-00020: maximum number of processes (150) exceeded [message #349457] Sun, 21 September 2008 23:17 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,
How can this issue be solved with out increasing the value of the PROCESSES initialization parameter.

Thanks in Advance.
Re: ORA-00020: maximum number of processes (150) exceeded [message #349463 is a reply to message #349457] Sun, 21 September 2008 23:47 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
one user got 115 sessions opened.
But "alter system kill session '141,30';" is not working.

Is there any way by which we can terminate all sesions opened by a user forcefully.
Re: ORA-00020: maximum number of processes (150) exceeded [message #349488 is a reply to message #349457] Mon, 22 September 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can this issue be solved

Close your sessions in yuor application.

Regards
Michel
Re: ORA-00020: maximum number of processes (150) exceeded [message #349506 is a reply to message #349463] Mon, 22 September 2008 02:02 Go to previous messageGo to next message
dilip56
Messages: 6
Registered: September 2008
Junior Member
if you know the sid of the process, then you can get the spid of that particular process from v$process, and then kill that specific session from unix prompt using KILL command.

$> kill -9 spid

[Updated on: Mon, 22 September 2008 02:06]

Report message to a moderator

Re: ORA-00020: maximum number of processes (150) exceeded [message #349530 is a reply to message #349506] Mon, 22 September 2008 02:42 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dilip56 wrote on Mon, 22 September 2008 09:02
if you know the sid of the process, then you can get the spid of that particular process from v$process, and then kill that specific session from unix prompt using KILL command.

$> kill -9 spid

Another way: shutdown and restart the server.

Regards
Michel

Previous Topic: Error on Alert Log
Next Topic: Keep log statement
Goto Forum:
  


Current Time: Fri Dec 09 10:01:16 CST 2016

Total time taken to generate the page: 0.08656 seconds