OraFAQ Forum: Server Administration » ORA-00020: maximum number of processes (150) exceeded

Home » RDBMS Server » Server Administration » ORA-00020: maximum number of processes (150) exceeded (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00020: maximum number of processes (150) exceeded [message #349457]

Sun, 21 September 2008 23:17

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.

Report message to a moderator

Re: ORA-00020: maximum number of processes (150) exceeded [message #349463 is a reply to message #349457]

Sun, 21 September 2008 23:47

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.

Report message to a moderator

Re: ORA-00020: maximum number of processes (150) exceeded [message #349488 is a reply to message #349457]

Mon, 22 September 2008 01:27

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

How can this issue be solved

Close your sessions in yuor application.

Regards
Michel

Report message to a moderator

Re: ORA-00020: maximum number of processes (150) exceeded [message #349506 is a reply to message #349463]

Mon, 22 September 2008 02:02

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 15:17:45 CST 2025