Home » RDBMS Server » Server Administration » ORA-00020: maximum number of processes num exceeded
ORA-00020: maximum number of processes num exceeded [message #369401] Wed, 13 September 2000 16:17 Go to next message
Laura
Messages: 12
Registered: September 2000
Junior Member
Hi,

I am getting the following error message: "ORA-00020: maximum number of processes num exceeded." The number of PROCESSES is currently set at 300 in the init.ora file and this error message has been occurring on a daily basis this week on our Oracle Enterprise 8.0.5.0.0 Server. The number of PROCESSES in the init.ora file was originally set at 200 and we increased it to 300 but, we are still getting the following error message. Oracle sits on Windows NT 4.0. Our site server here replicates up to a Central Database Server. Do you know what the maximum value is for the number of PROCESSES? Also, do you have any suggestions on what else to try?

Thanks,
Laura

Report message to a moderator

Re: ORA-00020: maximum number of processes num exceeded [message #369412 is a reply to message #369401] Fri, 15 September 2000 15:14 Go to previous message
salman
Messages: 22
Registered: March 1999
Junior Member
Did you bounce the database after changing in your init.ora file?

And check in your Instance manager ini paremeters what is the value of process .

Bye
Salman Khan

Report message to a moderator

Previous Topic: utl_file package over a network
Next Topic: Is there any utilites to monitor what statement is being processed in the server?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:46:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.