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.

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 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.

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
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

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 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: 68666
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 01:28:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.